You can customize each worksheet with the Worksheet Properties icon in the Standard toolbar.
The information you enter in the Worksheet Properties dialog box is saved with the specific worksheet. To apply this setting to other worksheets use Worksheet templates.
There are six panes available in the Worksheet Properties dialog box:
General - to enter the worksheet title (for reports and other outputs as opposed to worksheet file name) and worksheet contact information.
-
Order - to enter order information.
-
Columns - to customize the columns displayed and their order in the worksheet.
-
Header/Footer - to customize the header and footer when printing the worksheet.
-
Adjustments- to add price adjustments such as taxes, installation fees and shipping charges.
-
Report - to add images to use in reports.
-
International - to specify the currency used for the worksheet and any other currency to convert prices to. Get coaching on this.