Hi,

is there any way to change the excel "new" (blank) template, like you can
with Word? The reason I ask is that I would like each new excel workbook to
automatically be formatted with all the cells in "date" format, instead of
"general". Is this possible?

m-

Start a new workbook.
Format the cells the way you want.
Save it as a template file named book.xlt in your XLStart folder.

Excel will use that template workbook when you create a new workbook by clicking
on the new icon on the standard toolbar.

You can create a workbook named Sheet.xlt in the same XLStart folder and any new
worksheet added to an existing workbook will inherit those settings.

Ps. Remember where you saved this file--you'll want to find it and delete it
when you realize how irritating it will be <vbg.

Mari wrote:

Hi,

is there any way to change the excel "new" (blank) template, like you can
with Word? The reason I ask is that I would like each new excel workbook to
automatically be formatted with all the cells in "date" format, instead of
"general". Is this possible?

m-

--

Dave Peterson

Tee-hee-hee! I can see already why you say that, so maybe I will not change
to date format. However, what will REALLY help me is knowing how to
manipulate the blank template for all my other idiosyncratic needs. :)

Thanks so much. you are awesome.

m-

"Dave Peterson" wrote:

Start a new workbook.
Format the cells the way you want.
Save it as a template file named book.xlt in your XLStart folder.

Excel will use that template workbook when you create a new workbook by clicking
on the new icon on the standard toolbar.

You can create a workbook named Sheet.xlt in the same XLStart folder and any new
worksheet added to an existing workbook will inherit those settings.

Ps. Remember where you saved this file--you'll want to find it and delete it
when you realize how irritating it will be <vbg.

Mari wrote:

Hi,

is there any way to change the excel "new" (blank) template, like you can
with Word? The reason I ask is that I would like each new excel workbook to
automatically be formatted with all the cells in "date" format, instead of
"general". Is this possible?

m-

--

Dave Peterson

Yes create a spreadsheet with the format you want and [Save As] [Save as
type:] [Template (*.xlt)].
Lou

"Mari" wrote:

Hi,

is there any way to change the excel "new" (blank) template, like you can
with Word? The reason I ask is that I would like each new excel workbook to
automatically be formatted with all the cells in "date" format, instead of
"general". Is this possible?

m-