(Msg. 1) Posted: Mon Jun 18, 2007 11:50 am
Post subject: How to make a cell permanently fixed Archived from groups: microsoft>public>excel>newusers (more info?)
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.
(Msg. 2) Posted: Mon Jun 18, 2007 12:09 pm
Post subject: RE: How to make a cell permanently fixed [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office