Excel Insert Column & prevent formula change

Status
Not open for further replies.
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?

tnowen
 
Status
Not open for further replies.
Back