How to Use Excel 2010's Scale to Fit Printing Options
How to Repeat Row and Column Headings When You Print in Excel 2010
Previewing Pages in Excel 2010's Backstage View

Adding a Standard Header or Footer in Excel 2010

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.

1

Click 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).

2

Position 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.

3

Click 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.

4

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

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

5

Click 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.

6

Click 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.

7

Click 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.

If, after selecting some stock header or footer info, you decide that you no longer need either the header or footer printed in your report, you can remove it. Simply click the (None) option at the top of the Header button's or Footer button's drop-down menus.

Use the Go to Header and Go to Footer buttons in the Navigation group of the Design tab to quickly jump between the header and footer of the worksheet. Remember that the Design tab appears only after you've clicked inside the header or footer area.

blog comments powered by Disqus
How to Select a Printer in Excel 2010
How to Print Gridlines and Row and Column Headings in Excel 2010
How to Print Particular Parts of an Excel 2010 Workbook
How to Print a Worksheet in Excel 2010
How to Change the Print Margins in Excel 2010
Advertisement
Learning anything is easy with For Dummies eLearning!

Inside Dummies.com