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

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-

"Rookie 1st class" wrote:

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-

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-

Did you try naming THE workbook template Book.xlt?

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



Mari wrote:

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-

"Rookie 1st class" wrote:

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-



--

Dave Peterson

You cannot change the default Excel Template that creates the FileNew...Blank
Workbook.

Make your own and call it from the FileNew Icon or from FileNew(not
filenew... with the ellipsis)


Gord Dibben MS Excel MVP

On Mon, 21 Aug 2006 17:12:34 -0700, Mari wrote:

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-

"Rookie 1st class" wrote:

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-

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