Creating a Header

Excel allows you to add headers to your spreadsheet. Headers are nothing more than repeating text that appears at the top of every page of your printed spreadsheet. The beauty of headers is that they only have to be defined once, and then Excel places them on your printed pages automatically. To define a page header, do the following:

1. Select Page Setup from the File menu. This displays the Page Setup dialog box.
2. Make sure the Header/Footer tab is selected. (Click here to see a related figure.)
3. Using the Header drop-down list, select any of the predefined headers you want used with your spreadsheet.
4. Click on OK to close the Page Setup dialog box.

If you don't like any of the predefined headers in Excel, or if you have special header needs, you can create a custom header. You do that by following these steps:

1. Select Page Setup from the File menu. This displays the Page Setup dialog box.
2. Make sure the Header/Footer tab is selected.
3. Click on the Custom Header button. This displays the Header dialog box. (Click here to see a related figure.)
4. In each of the three parts of the dialog box, enter the information you want to appear at the left, center, and right of the header.
5. When you are through defining your footer, click on OK to close the Header dialog box.
6. Click on OK to close the Page Setup dialog box.