[AccessD] OT: Excel Question - Lock a Formula

Dan Waters dwaters at usinternet.com
Sat Oct 7 18:14:39 CDT 2006


Wait!  Wait!  I thought I said you could get clever!

Dan Waters


-----Original Message-----
Subject: Re: [AccessD] OT: Excel Question - Lock a Formula

Dan says so!  :o)

Rocky


-----Original Message-----
Subject: Re: [AccessD] OT: Excel Question - Lock a Formula

Hi Rocky

Are you looking for $E$4 to lock to E4 ??

Not sure I understood the question but thought I'd give it a try.


HTH

Bill


----- Original Message ----- 
Subject: [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







More information about the AccessD mailing list