Adding a Standard Header or Footer in Excel 2010

By Greg Harvey

Headers and footers typically appear on every page of a report. In Excel 2010, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to identify the document and to display the page numbers and the date and time of printing. Unless you specify otherwise, Excel does not automatically add either a header or footer to a new workbook.

1Click the Page Layout button on the View tab of the Ribbon.

Or you can click the Page Layout View button on the Status bar (it’s the one in the middle).

2Position the mouse pointer over the Click to Add Header section at the top, or in the Click to Add Footer section at the bottom.

Before you click one of these areas, decide whether you want your headers or footers on the left, on the right, or in the middle.

221943.image1.jpg

3Click to position the insertion point in either the left, center, or right section of the header or footer area.

Excel adds a Header & Footer Tools contextual tab with its own Design tab.

4Click the Design tab if it isn't already selected.

The Design tab is divided into Header & Footer, Header & Footer Elements, Navigation, and Options groups.

221945.image3.jpg

5Click either the Header or Footer button (as appropriate) in the Header & Footer group at the left end of the Design tab.

The standard options for the Header or Footer appear in a drop-down list.

221947.image5.jpg

6Click the header or footer example you want to use on the Header or Footer drop-down menu.

The option you selected now appears in the header or footer area of the worksheet. Repeat Steps 3–6 if you want to try another selection.

7Click in the worksheet area and then click the Normal button on the View tab to return to Normal view.

You won’t see the added header or footer in Normal view, but it’s there when you preview or print the worksheet.