Change the Normal Template

  • Thread starter Thread starter Cindi
  • Start date Start date
C

Cindi

How do I change the normal template? I want to make
global changes to my Excel Workbooks. I would like to
change the default margins, and I assume that change needs
to be made to the global template. Please explain how to
do this.

Thanks,

Cindi
 
Cindi,

Open a new workbook, format as desired, and save as a template file named
Book.xlt in the XLStart directory.
 
Cindi

The Help facility in excel explains this easily - I have
copies the extract for you, but if you go into the Help
menu and search on 'templates' there is a lot more info.

Create a workbook template for new workbooks
Create a workbook that contains the sheets, default text
(such as page headers and column and row labels),
formulas, macros, styles, and other formatting you want
in new workbooks that you base on the template.


On the File menu, click Save As.


In the Save as type box, click Template (*.xlt).


In the Save in box, select the folder where you want to
store the template.
To create the default workbook template, select either
the XLStart folder or the alternate startup folder. The
XLStart folder is usually
C:\os\Profiles\user_name\Application
Data\Microsoft\Excel\XLStart
where os is the operating system folder - for example,
Windows.

To create a custom workbook template, select the
Templates folder, which is usually
C:\os\Profiles\user_name\Application
Data\Microsoft\Templates
where os is the operating system folder, for example,
Windows.

In the File name box, type book to create a default
workbook template.

Hope this helps
Lindsey
 
Cindi

Please note that the template will be for NEW workbooks only. Previously
saved workbooks will have to be changed individually.

Gord Dibben Excel MVP XL2002
 
Back
Top