-
From the View menu, select Templates, Manage Templates.
-
Click New in the Manage Worksheet Templates dialog.
-
Enter the template name and then click OK.
-
In the Template Properties dialog, select any of the following tabs:
General - to enter the worksheet title and worksheet contact information
Order - to enter order information
Columns - to customize the columns displayed and their order in the worksheet
Header/Footer - to define the header and footer when printing the worksheet
Adjustments- to add price adjustments such as taxes, installation fees and shipping charges
International - reserved for international businesses
Report - to add images to use in reports. -
Click OK.
-
To apply this template to the current worksheet, click Apply.