Clear out data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Thanks Ron.

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