How to Add Headers and Footers to Excel Documents

What page is that? Those days are over; headers and footers in your Excel report remove this problem. Add page numbers, file names, and the date to the top or bottom of each spreadsheet page. These steps work with Microsoft Excel 97.

Instructions

Difficulty: Easy

Things You’ll Need:

• Excel Book
• Microsoft Excel

1. Start Microsoft Excel and open the file you want to change.
2. Open the View menu and select Header and Footer option.
3. In the Page Setup dialog box, click the Custom Header or Custom Footer button.
4. Click inside the Left section, Center section or the Right section.
5. Click the A icon to change the font styles.
6. Click the # icon to insert page numbers.
7. Click the ++ icon to insert the number of pages in the document (so if you wanted the header or footer to read "Page X of 25," you'd click the # icon followed by the ++ icon).
8. Click the date, time, file name or tab icon to insert those items.
9. Click OK to accept the changes.

Tips & Warnings

• You can insert header or footer information in each Left, Center, or Right section.
• Click the Print Preview button to view your headers and footers.
• To speed things up, choose one of the preformatted headers and footers from the Header and Footer menus in the Page Setup dialog box.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.