Leading the way in Microsoft Office Development

Excel

What are the Default Templates ?

There are two specific templates which are used as the defaults when you add new worksheets or create new workbooks.

These two template files can be customised to contain your own personal default formatting and layout.

Book.xlt - This controls the settings for any new workbooks that are created.

Sheet.xlt - This controls the settings for any new worksheets that are added to your workbooks.

Neither of these files exist by default so you will have to create them yourself.

Once these files have been created and saved in your xlStart Directory they will become the new defaults.

Create a Default Workbook - Book.xlt

Create a workbook that contains all the default sheets you want created when you create a new workbook.

This should contain any default headers and footers, page setup informattion, formulas, macros, styles, appropriate formatting, etc etc

Save this workbook with the name Book.xlt and save it in your startup folder.

Excel will then use this template instead when you create a blank workbook.

Create a Default Worksheet - Sheet.xlt

Create a workbook that contains one worksheet. This template must only contain one worksheet.

On the worksheet, include the formatting, styles, text, and other information you want to appear on all new worksheets.

Save this workbook with the name Sheet.xlt and save it in your startup folder.

Excel will then use this template instead when you insert a new worksheet into an existing workbook.

Things to Remember

It is not possible to create a template for a Chart Sheet.

You can always edit or delete these files if you want to revert back to the original defaults at a later date.