Add headers and footers for printing

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.

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.

Tips