Microsoft Office Tutorials and References
In Depth Information
Adding headers and footers to printed pages
click the View tab and then click the Page Layout button to display your workbook in Page
Layout view. Click within a header or footer and then, on the Design tool tab, select the
Different Odd & Even Pages check box. Now when you change a header or footer, Excel
indicates whether it applies to an odd or even page.
Your worksheet’s header and footer will always be the same width as the printed worksheet.
If you want to adjust the vertical size of a header or footer, click the Page Layout tab, click
the Margins button, and then click the Custom Margins command at the bottom of the
menu to display the Margins page of the Page Setup dialog box.
The Margins page of the Page Setup dialog box has boxes for you to enter your desired
header and footer sizes. Enter the values you want and then click OK to apply your changes.