Add headers and footers for printing

ShowAdd a header or footer

  1. Click the worksheet.
  2. On the View menu, click Header and Footer.
  3. In the Header or Footer box, click the header or footer you want.

ShowCreate custom headers and footers

You can have only one custom header and one custom footer on each worksheet. If you create a new custom header or footer, it replaces any other custom header or footer on the worksheet.

  1. Click the worksheet.
  2. On the View menu, click Header and Footer.
  3. To base a custom header or footer on an existing header or footer, click the header or footer in the Header or Footer box.
  4. Click Custom Header or Custom Footer.
  5. Click in the Left section, Center section, or Right section box, and then click the buttons to insert the header or footer information you want in that section.
  6. Do one or more of the following:
    • To enter additional text for the header or footer, enter the text in the Left section, Center section, or Right section box.
    • To start a new line in one of the section boxes, press ENTER.
    • To delete a section of a header or footer, select the section that you want to delete in the section box, and then press BACKSPACE.

Notes

  • You can use the buttons in the Header or Footer dialog boxes to format or further customize your headers and footers.
  • Make sure the header or footer margin allows enough space for the custom header or footer.

ShowTips

  • To include a single ampersand (&) within the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors & Services.
  • To start numbering pages with a number other than 1, specify the first page number, and then use &[Page] in the header or footer. To specify the first page number:
    1. On the File menu, click Page Setup.
    2. In the First page number box, type the first page number.
 
 
Applies to:
Excel 2003