by Allen Wyatt
(last updated May 6, 2017)
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:
Figure 1. The Header/Footer tab of 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:
Figure 2. The Footer dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2694) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Place an ampersand into the text of a page header or footer, and you might be surprised to see it missing in your printout. ...Discover More
When printing a worksheet, you may want to have the footer different on the first page of your document than it is on ...Discover More
Ever wish that you could create nice, long footers that appear at the bottom of each page when you print your worksheet? ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.