How do I keep a formula from changing?
Just as a primitive example:
In cell A1 is the formula =B1
In cell B1 I write the word cat.
Now A1 will show the word cat.
So far, so good.
However, if I insert a column between A and B
the formula in A1 now shows =C1.
I want the formula in cell A1 to stay and continue saying =B1 after I insert a column.
Is it possible to "freeze" a formula.