Finding just values in a spreadsheet

  • Thread starter Thread starter Snoopy
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding value in the last cell in column A 1
Sending a copy of spreadsheet to mailrecipient; mail adress indicatedin a cell in the spreadsheet 4
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Macro vs Pivot table problem 1
Making a macro return to spreadsheet 4
Make a complete list of words from texts in a range 3
Disappearing cell values in Excel 2007 3
Spreadsheet produces error values 3

Back
Top