create a new worksheet with the same formula
 

I am trying to rename a worksheet to 2007. I want to keep the formulas, but
clear the data so I can put in new information.

create a new worksheet with the same formula
 

Copy the entire worksheet (or workbook) using
Edit, Move or Copy, besure to sheck the Copy box,
then on the new worksheet which you can rename,
you can delete all of the Constant information in a selection.

Select the entire sheet if you like, but it is unlikely that
you'd want to remove row 1 and column 1 descriptive
constants. You can select nontinguous areas if you like
such as most of different columns. One way to protect
some constant information is to change them to formulas
For example: ="Description"

Then invoke a macro such as the following.

Sub Clear_Constants() 'D.McRitchie 2005-11-19 rightclick.htm - insrtrow.htm
'-- provide for in rightclick cell, row, and column commandbars
Dim rng As Range 'prevent expansion of a single cell selection
Set rng = Intersect(Selection, Selection.SpecialCells(xlConstants))
If rng Is Nothing Then
MsgBox "No constants in selection area(s) -- no removal"
Else
rng.ClearContents
End If
End Sub

Directions to install and use the above macro in
http://www.mvps.org/dmcritchie/excel....htm#havemacro
The macro described above is part of some macros, that I
invoke from the context menu.
http://www.mvps.org/dmcritchie/excel/rightclick.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fuddy321" wrote in message ...
I am trying to rename a worksheet to 2007. I want to keep the formulas, but
clear the data so I can put in new information.