Excel Insert Column & prevent formula change

By tnowen
Jun 26, 2006
  1. Column A has formulas $C1-$D1. I want to insert a column in front of C which will cause the new data in C to subtract data in D but Excel changes the formula to $D1-$E1 when I insert a column. How can I make the formula remain the same no matter what changes in worksheet?

Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...