Welcome toExcel.Tips.Net
Helpful Links
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Newest Tips
Assigning a Macro to a Keyboard Combination
Hiding Rows Based on a Cell Value
Subscribe
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)
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
Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.Check out ExcelTips: Filters and Filtering today!