Positioning Headers and Footers

Summary: Excel allows you to control where a header and footer appear on each page of a worksheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Besides allowing you to control what appears in a header or footer, Excel allows you to also control where they appear on each page of your spreadsheet. To position the header or footer, follow these steps:

Select Page Setup from the File menu. This displays the Page Setup dialog box.
Make sure the Margins tab is selected. (Click here to see a related figure.)
Use the Header and Footer controls to specify the distance from the edge of the paper at which the header or footer should appear.
Click on OK.

Make sure that when you specify a position for the header or footer that the value is smaller than what you have set for top or bottom margins. If the Header or Footer values are larger than the margins, your header or footer could overlap with data printed on the page.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2636) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.

Check out PivotTables for the Faint of Heart today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Positioning Headers and Footers