Microsoft Office Tutorials and References
In Depth Information
Customizing the Default Workbook
To create a new default workbook template, all you need to do is customize a blank workbook
exactly as you like it. Here’s a list of some of the items you can change:
h Number of sheets: Add or delete sheets as you like. You can also change their names.
h Styles: Use the Style Gallery (Home
Styles) to customize styles. By default, all cells use
the Normal style, so if you want to change the default font in any way (including fill color,
number format, font, and borders), modify the Normal style. To change the Normal style,
right-click its name in the Style Gallery and choose Modify. Then make the changes in the
Style dialog box.
h Print settings: Use the commands on the Page Layout tab to specify print-related
settings. For example, you can include header or footer information or adjust the margins.
h Column widths: If you don’t like the default column widths, change them.
h Graphics: You can even insert a graphical object or two — for example, your company
logo or a picture of your cat.
When the new default workbook is set up to your specifications, choose File
Save As. In the
Save As dialog box, follow these steps:
1. Select Template ( *.xltx ) in the Save As Type drop-down list.
If your template contains any VBA macros, select Excel Macro-Enabled Template
( *.xltm ).
2. Name the file book.xltx (or book.xltm if it has macros).
3. Make sure that the file is saved to your XLStart folder.
Excel proposes that you save the file in your Templates folder, but it must be saved in
your XLStart folder.
The location of the XLStart folder varies. To find the location of your XLStart folder,
press Alt+F11 to activate the VB Editor. Press Ctrl+G to display the Immediate window,
and then type this statement and press Enter:
After you save the file, you can close it. Now, every time you start Excel, the blank workbook
that’s displayed will be based on the template you created. In addition, when you press Ctrl+N,
the new workbook will be created from your template.
If you ever need to bypass your new default workbook and start with one of the normal Excel
default workbooks, choose File
New and choose the Blank Workbook item.