Clear Worksheet

  • Thread starter Thread starter Treeskier
  • Start date Start date
T

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!
 
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 **
 
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.
 
Depends on version. In MacXL Delete clears only the active cell, The Del
key clears all cells in a selection.
 
Back
Top