Creating a Template to Show in the File New Dialog in Excel

• Microsoft Excel for Windows, versions 3.0, 4.0, 5.0

SUMMARY

Creating a Microsoft Excel worksheet or chart template will allow you to contain all the standard formatting, layouts, formulas, and text you use in a worksheet or chart document on a regular basis. Adding this template to the XLSTART subdirectory of EXCEL will enable you to choose it from the File New dialog box.

MORE INFORMATION

Use the following procedure to create a worksheet or a chart template to display in the File New dialog box:

1. Create or open the worksheet or chart you want to use as a template.

2. From the File menu, choose Save As.

3. Change directories to the XLSTART subdirectory in the directory that contains the EXCEL.EXE file.

4. Type a name for the chart or worksheet template.

5. From the Save File As Type list, select Template.

   In Microsoft Excel version 3.0, choose the Options button. From the File Format list, select Template, and choose OK.

6. Choose OK.

7. In Microsoft Excel version 3.0, choose Exit from the File menu, and then start Microsoft Excel again. (not necessary in versions 4.0 and 5.0)

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, page 79

"Microsoft Excel User's Guide," version 3.0, pages 555-558