Open the workbook that you want to use as a template. The template file is located in the Templates folder. Perform the following steps to create a template:
1. Click the Microsoft Office Button and click Save As.
2. In the Save As dialog box, do these:
a. Type a name in the File name: dropdown box.
b. Click the Save As type: dropdown box and click Excel Template.
3. Click Save.
If the workbook contains macros then choose the Excel Macro-Enabled Workbook option in the Save As type: dropdown box.
To know:
Location of the Templates folder:
Windows XP - C:\Documents and Settings\\Application Data\Microsoft\Templates
Windows Vista and Windows 7 - C:\Users\\AppData\Roaming\Microsoft\Templates
Alternate way to create a template:
Copy the workbook and place it in the Templates folder.
1. Click the Microsoft Office Button and click Save As.
2. In the Save As dialog box, do these:
a. Type a name in the File name: dropdown box.
b. Click the Save As type: dropdown box and click Excel Template.
3. Click Save.
If the workbook contains macros then choose the Excel Macro-Enabled Workbook option in the Save As type: dropdown box.
To know:
Location of the Templates folder:
Windows XP - C:\Documents and Settings\
Windows Vista and Windows 7 - C:\Users\
Alternate way to create a template:
Copy the workbook and place it in the Templates folder.
0 comments:
Post a Comment