Finding just values in a spreadsheet

S

Snoopy

Goood Morning fellows :)
I several matters you have given me your kindly help - and I still hope
to get on track on this new issue by your qualified respons:

I want to use my (rather large) woorkbook for another issue - and have
saved it as a new name (wow!).
However all the values is still in place (off course) as well as
formulas (again: off course).

Do anyone out there know a simple methode to replace or delete all the
values (only) - in a way as the formulas still are untouched?

Regards
Snoopy
 
R

Roger Govier

Hi

Try this first on a copy of your data in case you make a mistake!!!

Use Ctrl+A to select the whole of your sheet (or click the small grey
square above row 1 and left of column A.
Press F5>Special>Constants>OK
You should now have all of the cells with constants in them marked.
Press Delete.
 
Top