|
Excel 2007 provides the following options when specifying headers and footers for different pages in your reports:
- You can specify a different header/footer for the first page. This option is useful, for example, for reports that require a different header or footer for a title or table of contents page.
- You can specify a different header/footer for odd and even pages. This option is useful, for example, if you create book-style reports. If, in addition, you specify a first page header or footer, Excel will apply the odd page header or footer starting from the second page of your report.
Follow these steps to add a separate header/footer to the first page or to add separate headers/footers to odd and even pages of your report:
1. Select the Page Layout View by clicking the Page Layout View button on the status bar or in the Ribbon's View tab.
2. Click in a section of the header or footer region.
The Ribbon displays the Header & Footer Tools contextual tab header on Excel's title bar and the Design tab below the header.
3. If necessary, click the Design tab to display the header/footer tools on the Ribbon.
4. Do one or both of the following:
• To specify a first page header/footer, select the Different First Page check box in the Options group of the Header and Footer Design tab.
• To specify odd and even page headers/footers, select the Different Odd & Even Pages check box in the Options group of the Header and Footer Design tab.
5. Enter the header or footer information for each page as follows:
• If you specified a separate first page header/footer only, enter the first page header/footer information in the first page of your document and enter the header/footer information for all subsequent pages in the second page of your document.
• If you specified odd and even headers/footers only, enter the header/footer information for all odd pages in the first page of your document and enter the header/footer information for all even pages in the second page of your document.
• If you specified both first page header/footer and odd and even page headers/footers, enter the first page header/footer information in the first page of your document. Next, enter the header/footer information for all odd pages in the second page of your document, and enter the header/footer information for all even pages in the third page of your document.
 | When you click the mouse pointer within a header or footer region, Excel indicates the type of header/footer you're working with (normal, first page, odd page, or even page) above the header or below the footer area. |
| 
