how do I delete data from a worksheet without deleting the formul.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to clear just the data from a large sheet, and I want to keep the
formulas. This has to be possible, right?
 
Jack

Select all cells with CTRL + A(twice in 2003)

OR possibly you don't want to touch titles so select just the range to clear.

F5>Special>Constants. Check or uncheck what you want to find/keep and OK.

Edit>Clear>Contents.


Gord Dibben Excel MVP
 
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

Excel How do I delete images in a specific range 1
Protecting cell formulas in excel 2007 1
Adding Columns, Then deleting old columns 4
Need help deleting data 2
Formulating between worksksheets 2
Deleting blank rows with formulas in them 7
Easiest Way to Delete Rows 4
Excel Cannot delete empty cells/rows 4

Back
Top