Workbook template
Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting you want in new workbooks based on the template.
Worksheet template
Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type.
To create the default workbook template or default worksheet template, select either the XLStart folder or the alternate startup folder. The XLStart folder is usually
C:\Program Files\Microsoft Office\Office11\XLStart
To create a custom workbook or worksheet template, select the Templates folder, which is usually
C:\Documents and Settings\user_name\Application Data\Microsoft\Templates
Workbook template
Type book to create the default workbook template.
To create a custom workbook template, type any valid file name.
Worksheet template
Type sheet to create a template for default worksheets.
To create a custom sheet template, type any valid file name.