How do I lock cell formulas???

[Guest]

For example, formaula is cell C1 adds cell A1 and B1. If I insert column
between B1 and C1, the formule will shift to D1. How do I make D1 formula add
cells B1 and C1 automatically. D1 currently will continue to add A1 and B1.

 

[Guest]

You could use the OFFSET fuction.

In C1 enter:
=OFFSET(C1,0,-1)+OFFSET(C1,0,-2)

This adds the cells that are 1 column and 2 columns to the left of C1. When
you insert a column, the formula will be moved to D1, but still add the cells
that are 1 and 2 columns to the left.

HTH,
Elkar

 

[Guest]

Thanks. Never used that fuction before. Still learning.