Excel Template

[Mari]

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]

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]

Thank you for your reply.
Actually, I already tried that, but I could not find a "normal.xlt"
template, like there is for the word main template. I know that I can make
"a" template, but I want to change "the" template. Do you know where the
main blank workbook template is stored?

m-

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

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-

 

[Rookie 1st class]

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

 

[Dave Peterson]

Did you try naming THE workbook template Book.xlt?

Not normal.xlt, not nothing but book.xlt.

Thank you for your reply.
Actually, I already tried that, but I could not find a "normal.xlt"
template, like there is for the word main template. I know that I can make
"a" template, but I want to change "the" template. Do you know where the
main blank workbook template is stored?

m-

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

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-

 

[Gord Dibben]

You cannot change the default Excel Template that creates the File>New...Blank
Workbook.

Make your own and call it from the File>New Icon or from File>New(not
file>new... with the ellipsis)


Gord Dibben MS Excel MVP

Thank you for your reply.
Actually, I already tried that, but I could not find a "normal.xlt"
template, like there is for the word main template. I know that I can make
"a" template, but I want to change "the" template. Do you know where the
main blank workbook template is stored?

m-

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

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-

 

[Mari]

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-