Microsoft Office 2000

Lesson 4: Excel 2000 (Part 2)

Creating Workbook Templates

Use a template to create a professional-looking Excel document quickly.

To open a template:

• Click on File - New
• Click on the Spreadsheet Solutions tab
• Click on a template
• Click on OK
• Click the Customize tab or Customize button to insert your information

See example of Spreadsheet Solutions template

You can create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, styles, and other formatting you want in new workbooks that you based on the template.

To create a workbook template from an existing template:

• Click on File – Save As
• In the Save as type box, click Template (*.xlt).
• In the Save in box, select the folder where you want to store the template

To create the default workbook template:

• Select either the XLStart folder or the alternate startup folder (the XLStart folder is usually C:\Windows\Profiles\user_name\Application Data\Microsoft\Excel\XLStart)

To create a custom workbook template:

• Select the Templates folder, which is usually C:\Windows\Profiles\user_name\Application Data\Microsoft\Templates

To create a default workbook template:

• Type book in the File name box

To create a custom template:

• Type any file name of your choice in the File name box

  1  2  3  4