Select File, Page Header/Footer to customize the header and footer when printing a worksheet.
This command opens the Worksheet Properties dialog, with the Header/Footer tab active.
Notice the $ codes in the Header/Footer tab. This is a simple computer code instructing the program to pull the data from the worksheet. These codes are used because the information may change but the placement and format will remain the same.
In addition to using the $ codes, you may also type in any information you would like to appear in the header or footer. Click in the proper area (Header or Footer tab; Left Aligned, Centered or Right Aligned) and type the text.
Note: When modifying the Header/Footer, insert the code first before typing in text. Otherwise, the text you entered will be overwritten by the code.
|
To |
Do this |
|
Modify the header |
Click the Header tab. |
|
Modify the footer |
Click the Footer tab. |
|
Access the list of codes and view their current values |
Click the Legend button. |
|
Adjust the space given to the header and footer |
Click Page Setup. |
|
Change the font type and size |
Click Font. |
Header tab
Use the Header tab to place information at the top of the worksheet.
$R is a default symbol for the Title of the worksheet. The Worksheet Title is set in the General tab of the Worksheet Properties dialog box. By default, the title appears in the upper left corner of the worksheet .
$P is a default symbol for current page number and $N is the default symbol for number of pages. By default, the page number appears in the upper right corner of the worksheet.
Note: Click the Legend button for all legend codes and descriptions.
Footer tab
Use the Footer tab to place information at the bottom of the worksheet.
$L is the default symbol for the path and filename of the worksheet. By default, this appears in the lower left corner of the worksheet.
$D is the default symbol for the Date/Time stamp. By default, this appears in the lower right corner of the worksheet.
Note: Click the Legend button for all legend codes and descriptions.
Example: customize the header
In this example you will add a line to the header.
-
In the Header tab, click the second cell under the column Left Aligned.
-
Click the Legend button to access the list of codes.
-
In the Header/Footer Legend dialog, select the code $C - Prepared by Company Name then click Insert Code.

-
Type Designed by:in the box, before $C.
-
Click Font. Select Font = Arial, Font Style = Regular and Size = 12. Click OK.
-
Click Page Setup to open the Page Setup dialog.
-
Click Print Preview in the Page Setup dialog. Notice the header that you just entered.
-
Click Close.