Adding Headers and Footers
HEADERS AND FOOTERS are text and images that appear at the top (header) and bottom (footer) of a printed page. They are repeated on all pages of a single print job and may include information such as the file name, page number, date and time, and a logo.
Excel includes a number of predefined headers and footers. All you have to do is tell Excel where to put the information. With the Page Layout view selected, follow these steps:
1. | Click in the header or footer area. This area is divided into three sections: left, centered, or right based on where the text will be aligned on the page. Excel adds a new Header & Footer Tools Design tab. |
2. | Choose Header & Footer Tools Design > Header & Footer > Header (or Footer). The drop-down menu reveals several predefined text options (see Figure 9-23). |
3. | Select the option you want to add. Predefined text will be inserted into the center area of the header or footer. |
Adding a Header/Footer in Normal ViewYou can also add a header or footer from the Normal view by choosing Insert > Text > Header & Footer from the Ribbon. |
You are not limited to these predefined headers and footers. Table 9-3 indicates the elements that may be included in a custom header or footer.
| Button | Code | Description |
|---|---|---|
| Page Number | &[Page] | Inserts the current page number |
| Number of Pages | &[Pages] | Inserts the total number of pages that will be printed |
| Current Date | &[Date] | Inserts the current date |
| Current Time | &[Time] | Inserts the current time |
| File Path | &[Path]&[File] | Inserts the complete path, including file name, for this workbook |
| File Name | &[File] | Inserts the file name for this workbook |
| Sheet Name | &[Tab] | Inserts the name of the worksheet as displayed on the sheet tab |
| Picture | &[Picture] | Enables you to insert a picture; also used for watermarks, as described in the next section |
| Format Picture | Displays the Format Picture dialog box to adjust the size and scale of the picture |
To add a custom header or footer, select the Page Layout view and follow these steps:
1. | Click in the area of the header or footer where you would like the custom text to be aligned on the page. Excel adds a new Header & Footer Tools Design tab. |
2. | Choose Header & Footer Tools Design > Header & Footer Elements and select any combination of the elements you want to see on your printed document. Excel inserts the code associated with the element, as shown in Figure 9-24. Alternatively, you can type directly into the header or footer area. |
3. | Switch between the header and footer area of the page by choosing Header & Footer Tools Design > Navigation > Go to Header (or Go to Footer). |
4. | If you want to create a separate header or footer for the first page, or for odd and even pages, click the appropriate check boxes in the Options group of the Header & Footer Tools Design tab. |
Figure 9-25 illustrates how these custom headers and footers can add useful information to your printed pages.
