|
In Microsoft Office Excel, you can add or change headers or footers to provide useful information in worksheet printouts. For example, you can add predefined header and footer information or insert elements such as page numbers, date and time, and the file name. To define where in the printout the headers or footers should appear and how they should be scaled and aligned, you can choose from several header and footer options.
For worksheets, you can work with headers and footers in Page Layout view, or use the Page Setup dialog box to specify the same headers or footers for more than one worksheet at the same time. For other sheet types, such as chart sheets, or for embedded charts, you can only work with headers and footers in the Page Setup dialog box.
This How To gives you steps on how to use the Page Layout view to add or edit a header or footer.
Click the worksheet to which you want to add headers or footers, or that contains headers or footers that you want to change.
- On the Insert tab, in the Text group, click Header & Footer.
- Do one of the following:
- To add a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.
- To change a header or footer, click the header or footer text box at the top or the bottom of the worksheet page respectively, and then select the text that you want to change.
- Now you can either insert your text OR you can use one of the predefined header or footer elements.
- Note: The Header & Footer Elements group is found on the Design tab of the Header & Footer Tools Contextual tab.
- When you are done, you can click anywhere in the document to close Header and Footer.
NOTES:
- To start a new line in a header or footer text box, press ENTER.
- To delete a portion of a header or footer, select the portion that you want to delete in the header or footer text box, and then press DELETE or BACKSPACE. You can also click the text and then press BACKSPACE to delete the preceding characters.
- To include a single ampersand (&) in the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services.
- To close the headers or footers without keeping the changes that you made, press ESC.
For more information on adding or changing a header or footer in Excel 2007, you can also use the Help button (little blue questions mark at top right corner of your Excel window) and type in header. Click the Search button.
|
