Clear Worksheet

[Treeskier]

Probably a simple newbie question....
I have a Balance Sheet I'd like to clear all entries to except the
formulas and formats so I can start a new sheet. Whenever I clear contents,
it always removes the formulas and formats so I can't start a new...
This must be something simple I suppose...can anyone help if you
understand my question?
Thank You for all help!

 

[Paul B]

Treeskier, try edit, go to, special, constants, ok, delete

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[JE McGimpsey]

One way:

Choose Edit/Goto/Special. Select the Constants radio button and choose
the checkboxes you want: Numbers, Text, etc. Click OK. Choose
Edit/Clear/Contents.


You can do this with a macro:

Public Sub ClearConstants()
On Error Resume Next 'in case no constants
Cells.SpecialCells(xlCellTypeConstants, _
xlNumbers + xlTextValues).ClearContents
On Error GoTo 0
End Sub


Remove the "+ xlTextValues" if you want to leave text.

 

[Earl Kiosterud]

Yup. And you can use the Delete key. It's the same as Edit - Clear -
Contents.

 

[JE McGimpsey]

Depends on version. In MacXL Delete clears only the active cell, The Del
key clears all cells in a selection.

 

[Treeskier]

Thank You very much!!!!!

Depends on version. In MacXL Delete clears only the active cell, The Del
key clears all cells in a selection.