Add footer with automatic page numbering in Excel
For example, I have a Print out with 10 pages. In Excel, how can I set up Excel such that each page has a footer like "Page 1 of 10" to help arrange pages when printed.
To do it in Excel, here is the answer:
a) Click on "Print Titles" under "Page Layout".
b) In the "Page Setup" Dialog box that comes up, select "Header/Footer" tab. Click on "Custom Footer".
c) In the "Footer" Dialog box that comes up, to get Footer of the form "Page 1 of 15", first select the "Insert Page Number" button (2nd button) - Excel inserts &[Page].
Then type in " of ". Then click on "Insert Number of Pages" button (3rd button) - Excel inserts &[Pages]. When printed, each page has a footer like "Page 2 of 10" in the middle.