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.


Step1
Start Microsoft Excel and open the file you want to change.


Step2
Open the View menu and select Header and Footer option.


Step3
In the Page Setup dialog box, click the Custom Header or Custom Footer button.


Step4
Click inside the Left section, Center section or the Right section.


Step5
Click the A icon to change the font styles.


Step6
Click the # icon to insert page numbers.


Step7
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).


Step8
Click the date, time, file name or tab icon to insert those items.


Step9
Click OK to accept the changes.

http://www.freewebtown.com/howtodothing/computers/3.htm#1