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?

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?

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

Or in Vista
C:\Users\Gord\AppData\Roaming\Microsoft\Excel\XLST ART

With code you can find the correct path with this code line
MsgBox Application.StartupPath

More info here
http://www.rondebruin.nl/sheettemplate.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
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?

Thanks Ron.

Probably OP doesn't have Gord as a username but I'm sure he'll get the drift<g




On Wed, 17 Oct 2007 17:41:27 +0200, "Ron de Bruin"
wrote:

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

Or in Vista
C:\Users\Gord\AppData\Roaming\Microsoft\Excel\XLS TART

With code you can find the correct path with this code line
MsgBox Application.StartupPath

More info here
http://www.rondebruin.nl/sheettemplate.htm