How to make a cell permanently fixed
 

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

How to make a cell permanently fixed
 

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


"Omer" wrote:

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