[AccessD] OT: Excel Question - Lock a Formula

Dear List:

 

I have a formula in a cell in Column E that averages the next 12 cells in
the row (=(F4-R4)/R4). When I insert a column after this formula, it changes
the formula to =(G4-S4)/S4.  I would like the formulas in column E to not
change.  Everything else can.  Is there a way to ‘lock’ the formulas in just
this column?

 

MTIA

 

Rocky

 


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 10/6/2006