Select all cells then F5SpecialConstants. Check what you don't want selected
like Text and OK.

EditClear Contents.

One method is to create a worksheet Template which can be inserted into a
workbook as you need more sheets.

NOTE: this will become the default InsertWorksheet for all workbooks, not just
the one. This may not be desirable so don't read on if that's the case.

Open a new workbook.

Copy the sheet you currently use into that new workbook.

Delete other sheets in the new workbook.

FileSave AsFile TypeTemplate(*.xlt)

Give it a name of SHEET and store it in your XLSTART folder usually found at

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART


Gord Dibben MS Excel MVP


On Tue, 16 Oct 2007 17:31:12 -0700, TAD wrote:

How do you clear out data in a cell of a worksheet with out clearing formulas?
Or how do you set up a master worksheet with formulas, column headings and
row headings that can be used over & over again by just changing some data?