How to make a cell permanently fixed

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

Guest

Hi everybody

I have completed my workbook by entering different formulas in different
cells, Now, I want all cells to freeze the value they have, I dont care if
these cells just forget the formula and now retain only the numeric value
they have calculated, is their any way to do that.

Thanks all
 
Try this:

Select the range to be impacted

From the Excel main menu:
<edit><copy>
<edit><paste special>......check: Values........Press: OK

That will replace all formulas with their calculated values.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Back
Top