Excel: Customizing Default Document Templates

• Microsoft Excel for Windows, version 4.0
• Microsoft Excel for the Macintosh, version 4.0

SUMMARY

In Microsoft Excel 4.0, you can modify the built-in templates in order to change the appearance or functionality of a default document.

To modify a default file for Microsoft Excel on the Macintosh, save a document of the same name in Template format in the Microsoft Excel Startup folder. On the Macintosh, the default startup directory is called Excel Startup Folder (4) in the System Folder (in System Folder:Preferences in System 7.0). In Microsoft Excel for Windows, the default startup directory is called XLSTART in the EXCEL directory.

MORE INFORMATION

The default worksheet, macro sheet, and chart may be changed by saving templates with the following names:

                              Template Name
   Document Type       Macintosh        Windows
   ---------------------------------------------

   Worksheet           Worksheet        SHEET.XLT
   Chart               Chart            CHART.XLT
   Macro sheet         Macro            MACRO.XLT

1. Create a document to be used as the default template.

2. From the File menu, choose Save As.

3. Direct the Save As dialog box to the Excel Startup Folder (4) on the Macintosh or XLSTART directory under Windows.

4. In the Save As dialog box, choose Options.

5. From the File Format list, select Template.

6. Change the name to "Worksheet" and choose Save.

To modify the default chart or macro sheet, follow steps 1 through 4 above. At step 5, select the appropriate file format. At step 6, change the name to match the file format you selected in step 5.

The default workbook cannot be modified workbooks are not based on a template.