Saving a Workbook as a Template
Earlier in this chapter, you met some of Excel's templates, the templates included with Excel and those in the Templates Gallery on the Web. After you have created a workbook, you can save your custom workbook as a template, so you can use it over and over again to create new workbooks. Templates store the following information and settings for new workbooks:
To have the first page of your template displayed in the preview area of the Templates dialog box, open the File menu and click Properties. Click the Summary tab and click the Save Preview Picture check box. Click OK.
Before you save a workbook or worksheet as a template, you must create a custom workbook or worksheet, as explained in Part 2, "Creating Your First Worksheet." You can then save the workbook or worksheet (a one-sheet workbook) as a template.
After you have created a custom workbook or worksheet, take the following steps to save it as a template:
Open Excel's File menu and choose Save As. The Save As dialog box appears, as you saw in Figure 3.6, displaying the names of all Excel workbook files in the My Documents folder.
Open the Save as Type list and click Template (*.xlt). (When Excel saves a workbook, it adds the extension .xls to the end of the file name, to indicate that the file is a workbook. Templates are saved with the extension .xlt.) The Save As dialog box automatically opens the Templates folder, and Templates appears in the Save In box. (See Figure 3.7.)
If you want to give this template a different name than what is displayed in the File Name box, type the desired filename.
You must save your templates in the C:\Documents and Settings\username\Application Data\Microsoft\Templates folder for the templates to appear in the Templates dialog box. Whenever you choose to save a workbook or worksheet as a template, the Save As dialog box automatically opens this folder and displays its contents.
Figure 3.7 You can save your workbook as a template for creating additional workbooks.