Creating a Footer

Excel allows you to add footers to your spreadsheet. Footers are nothing more than repeating text that appears at the bottom of every page of your printed spreadsheet. The beauty of footers is that they only have to be defined once, and then Excel places them on your printed pages automatically. To define a page footer, 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 Footer drop-down list, select any of the predefined footers 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 footers in Excel, or if you have special footer needs, you can create a custom footer. 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 Footer button. This displays the Footer 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 footer.
5. When you are through defining your footer, click on OK to close the Footer dialog box.
6. Click on OK to close the Page Setup dialog box.