Clear out data
 

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?

Clear out 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?

Clear out 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?

Clear out 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