freezing formulas after calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I freeze/maintain a cell's formula calculation so it won't alter under any circumstance. And is it possible to designate a continuous row of cells to freeze? The only way I know how to do this is to copy and paste special "values" to erase the formula and maintain the values

Thanks.
 
You can set calculation to manual

Tools>Options..Calculation

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




PTW said:
How can I freeze/maintain a cell's formula calculation so it won't alter under any circumstance. And is it possible to
Click to expand...
designate a continuous row of cells to freeze? The only way I know how to do this is to copy and paste special "values" to
erase the formula and maintain the values.
 
I've tried that and it won't work because as I move down the rows it will manually calculate all formulas within sheet. I'm adding information to target cells in which the formula cells are pulling from. Then I need to keep changing the target cells without altering the prior cells calculations. Does this make sense?
 
Back
Top