add footer with automatic page numbering in Excel

Q128. In Excel, how can I add a Footer to my printout with automatic page numbering?

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".

excel add footer with automatic page numbering

b) In the "Page Setup" Dialog box that comes up, select "Header/Footer" tab. Click on "Custom Footer".

excel excel add footer with automatic page numbering

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.

excel excel excel add footer with automatic page numbering

 

You can find similar Excel Questions and Answer hereunder

1) How do I add a shape using VBA?

2) How can I dynamically add series to an existing chart using VBA?

3) How do I enter a formula in a cell using VBA (using Relative Reference)?

4) How to center excel sheet horizontally and verticaly on page in Excel

5) I want to add a trend indicator symbol next to my sales data - how can I do that?

6) How can I add a legend to a chart using VBA?

7) How can I add Trendline to a chart using VBA?

8) Every time I make an update to my Worksheet, I would like to add a timestamp to my Last Updated field. In Excel, how can I do that in Worksheet?

9) How can I dynamically add a hyperlink using VBA?

10) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

11) How can I add a WorkSheet and name it as required using VBA?

12) How can I set Page orientation, Zoom % , Title Rows and footer using VBA?

13) How can I add interval to dates?

14) How can I see where page breaks occur before actually printing?

15) How can I add a Prefix to a set of numbers in a range?