Hello,

I need to average 3 cells.  However, whenever I add a new column, the
formulas shift by a cell, but I dont want them to.  How do I keep the
formulas from changing?

Example:

Avg   Cell F   Cell G   Cell H

Now, I want to Avg Cell F-H

However, when I insert a new cell to put this latest years numbers in I
want what is currently in Cell H (Soon to be Cell I when I insert a
column at Cell F) to drop out of the equation.  I still want to Avg
Cell F-H but Excel keeps shifting the formula to Cell G-I.

Ok, hope that makes sense.  How do I lock the formula?