Select the entire worksheet, then Copy, then Edit >Paste Special, and select
Value. This will convert all formulas to values.
"MatthewFlinchem" wrote:
>
> 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...o&userid=34112
> View this thread: http://www.excelforum.com/showthread...hreadid=542955
>
>
Bookmarks