Save values only?

I

ianripping

Easy question - ive forgotten how to save an excel document where i
only saves values and not formula's
 
D

Dave Peterson

Save your workbook as a new name first!

Group all the sheets you want converted to values.
(Click on the first worksheet tab and ctrl click on subsequent)

Ctrl-A (twice with xl2003) to select all the cells

rightclick on the selection
copy
paste special|Values

select A1 (or not)
ungroup the sheets

Save the file once more.
 
Top