Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Clearing Contents of Cell
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 -- Incoming & Outgoing mail scanned with NAV |
#2
|
|||
|
|||
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 "Burt" wrote in message ... 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 -- Incoming & Outgoing mail scanned with NAV |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
Insert new row as cell contents change | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |