Book1 - Save Default Format Settings

M

mdalby

How do I save some settings so that when I stgart a new workbook i
automatically brings up my new default settings. I like to have
specific fill color and a default border and font etc...

I have tried saving it that way as Book1 but it doesn't seem to brin
back the settings.

Thank
 
P

papou

Hello
Save your workbook as Excel.XLT and place it in the xlStart folder.
HTH
Cordially
Pascal
 
D

Dana DeLouis

Hello. In Excel Help, look for "About Excel templates." You want to save
it as "Book.xlt"

Here is a short copy:

Storing default workbook and worksheet templates:

If you've created a template named Book.xlt or Sheet.xlt and saved it in the
XLStart folder, Microsoft Excel uses the template to create new default
workbooks (default startup workbook: The new, unsaved workbook that's
displayed when you start Excel. The default startup workbook is displayed
only if you haven't included other workbooks in the XLStart folder.) or to
insert new worksheets. The XLStart folder is usually located at:

C:\Program Files\Microsoft Office\Office11\XLStart

HTH
Dana DeLouis
 
Top