Clearing Contents of Cell

  • Thread starter Thread starter Burt
  • Start date Start date
B

Burt

I have an excel spread sheet from last year in which I put entries and then
formulas to calculate totals. I wanted to clear the worksheet so that I
could reuse it. I followed Excel help, Highlighted all of the data entries
then went to edit-clear-contents. All information was removed from the cells
(data,format,formula). I then tried a single cell with the same results.
What am I doing wrong?
Thanks
 
If you are simply trying to clear the constants (your entries) and and
trying to leave the formats intact then do the following
Select the range by prtessing control A
Press F5 on keyboard
Click on Special tab
Select constants
Hit OK
Now press the delete key on the keyboard

This will clear all the entries except formulas and also leave your formats
intact from the deleted entries
 

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

how to clear data 3
Display Empty Cell When Using SUM formula 8
Excel Data pastes into 2 cells not 1 1
Removing data entries but not formulas or formats 3
Clear contents of cells if a condition is met 2
Excel Average dates help 0
using the =page! feature to transpose a row to column 0
Selectively Clearing cell contents 2

Back
Top