Template/Theme settings

[Guest]

How can I set up a template or theme or whatever so that when I open excel it
starts as I want it?
I'm particularly talking about text boxes here, which I want to start up
with black borders as in excel 2003 and with font 10 (not 11), but in general
I want to be able to start up with my settings.
If I save a template excel still starts with the default template. How can
I change this default template or start mine easily.
Thanks

 

[Gord Dibben]

Steven

Excel doesn't have a BOOK.xlt by default.

It uses its own default new workbook template and that cannot be modified.....an
internal default.

You must create your own default template.

Open a new workbook. Customize as you wish.

File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

 

[Guest]

Thanks for the help, I've now set up my sheets better.

Regards