13 Setting worksheet headers and footers

Worksheet headers and footers

Headers and Footers can be added to a worksheet using the Page Setup box:

To add an existing header:

1. Open up the Page Setup box.
2. Click on the Header/Footer tab to ensure that it is uppermost.
3. Underneath Header: is a long white box. Click on the downward pointing triangle to the right of this box.
4. In the pop-down menu click on a header.
5. Click on Print Preview to preview the header on the worksheet.
6. Click the Close button. You will be returned to the worksheet and the header will be set.

To add an existing footer:

1. Open up the Page Setup box.
2. Click on the Header/Footer tab to ensure that it is uppermost.
3. Underneath Footer: is a long white box. Click on the downward pointing triangle to the right of this box.
4. In the pop-down menu click on a header.
5. Click on Print Preview to preview the header on the worksheet.
6. Click the Close button. You will be returned to the worksheet and the footer will be set.

You can have 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.

Custom Headers and Footers

As well as adding existing headers and footers to a worksheet it is possible to add customised headers and footers to a worksheet.

To insert a custom header or footer based on an existing one:

1. Open up the Page Setup box.
2. Click on the Header/Footer tab to ensure that it is uppermost.
3. 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 to position the header or footer.
6. Click the buttons to insert the header or footer information you want in that section.
7. To enter additional text for the header or footer, enter the text in the Left section, Center section, or Right section box.
8. To start a new line in one of the section boxes, press ENTER.

To delete a section of a header or footer:

1. Select the section of a header or footer that you want to delete in the section box.
2. Press the Backspace key.

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

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, use &[Page]+ or &[Page]- followed by the number you want to add or subtract from the actual page number. For example, to print starting with number 3 on the first page, type &[Page]+2. To print page 4 with the number 3, type &[Page]-1.

For a further tutorial on setting headers and footers click here.

Exercises

For exercises to practice the above click here.

Back to Excel Home Page