Creating Headers and Footers

Headers and footers contain information that appears at the top and bottom of each page of your printed worksheet. You can select a premade header or footer that contains information about your file, or you can create your own custom headers and footers using pre-defined text. Excel 2007 comes with a list of expressions you can insert into your headers and footers to display certain information about your worksheet, such as page numbers or file names. Headers might include helpful information such as a workbook name, and footers can include page numbers, file names, or dates.

Add a Premade Header and Footer

Click the Insert tab.
Click Header & Footer.
Click Header.
Click the premade header you want to use.
If desired, click Footer, and then click the premade footer you want to use.
Tip
Click the Microsoft Office button, click the Print item’s arrow, and then click Print Preview to preview your headers and footers before you print.
See Also
For more information about how to change the size of your headers, see "Adjust Header and Footer Height".

Add Pre-Defined Text to the Header or Footer

Click the Insert tab.
Click Header & Footer.
Click the section of the header or footer where you want your text to appear and type the text you want.
If you want to use pre-defined text, position the insertion point where you want the text to appear.
Click a button to insert the pre-defined text.
Tip
You can change the appearance of your header and footer text by selecting the text or the code representing the value to be printed (for example, the current time) and using the controls on the Home tab of the ribbon.

Adjust Header and Footer Height

Click the Microsoft Office button.
Click the Print item’s arrow.
Click Print Preview.
If necessary, click Show Margins to display the header and footer lines.
Hover the mouse pointer over one of the gray lines until the mouse pointer becomes a two-headed arrow. Drag the line until the header or footer is the height you want.
Click Close Print Preview.
Tip
The directions of the arrowheads show you in which direction you can move the line.