Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

convert formulas to values

0 views
Skip to first unread message

MatthewFlinchem

unread,
May 17, 2006, 11:27:45 AM5/17/06
to

I have a huge spreadsheet that has a formula in every cell. I want to
eliminate the formulas and just leave the results. I am sure this is an
easy step but I am lost!

Thanks,

Matt AKA Dr Evil


--
MatthewFlinchem
------------------------------------------------------------------------
MatthewFlinchem's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34112
View this thread: http://www.excelforum.com/showthread.php?threadid=542955

Paul B

unread,
May 17, 2006, 11:35:05 AM5/17/06
to
Matt, select the cells you want to change, right click and copy, right click
and paste special, check valve OK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"MatthewFlinchem"
<MatthewFlinchem.27...@excelforum-nospam.com> wrote in
message news:MatthewFlinchem.27...@excelforum-nospam.com...

Niek Otten

unread,
May 17, 2006, 11:36:13 AM5/17/06
to
Copy, Paste Special, check Values

--
Kind regards,

Niek Otten

"MatthewFlinchem" <MatthewFlinchem.27...@excelforum-nospam.com> wrote in message
news:MatthewFlinchem.27...@excelforum-nospam.com...
|

SVC

unread,
May 17, 2006, 11:39:02 AM5/17/06
to
Select the entire worksheet, then Copy, then Edit >Paste Special, and select
Value. This will convert all formulas to values.
0 new messages