Excel XP

Creating Headers and Footers

Headers and Footers can be added to any worksheet, although not required. A Header is any information that appear at the top of each page. A Footer prints at the bottom of the page. If you want a header or footer inserted onto a page then you will have to define them. Excel XP defaults to no header and no footer.

To Create a Header:

• Choose File Page Setup from the menu bar.
• Select the Header/Footer tab in the Page Setup dialog box.
  
  
  
  
• Click the Header drop down list and select and of the predefined headers:
  
  
  
  OR
  
  click the Custom Header button to create your own header. Follow the instructions in the Header dialog box to make your entry.

• Click the OK button to return to the Page Setup dialog box.

To Create a Footer:

• Choose File Page Setup from the menu bar.
• Select the Header/Footer tab in the Page Setup dialog box.
• Click the Footer drop down list and select one of the predefined footers.
  
  
  
  OR
  
  Click the Custom Footer button to create your own footer. Follow the instructions in the Footer dialog box to make your entry.

You can insert Placeholder buttons into both the header and footer to format text, insert page numbers, date, time, filename, or tab name. Excel replaces those placeholders with the information each represents when the worksheet is printed. Follow the instructions in the Header and Footer dialog boxes.