Clear out data

[Guest]

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?

 

[Gord Dibben]

Select all cells then F5>Special>Constants. Check what you don't want selected
like Text and OK.

Edit>Clear 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 Insert>Worksheet 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.

File>Save As>File Type>Template(*.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

 

[Ron de Bruin]

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\XLSTART

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

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

 

[Gord Dibben]

Thanks Ron.

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