How to Consecutively Number Pages in Different Tabs

[jrocco]

In Excel, is there a way to consecutively number pages in different tabs?

I.E....
I have a Workbook with information in multiple tabs. I want to print all tabs, but I want the footer to display the page number in sequence. Sheet1 may have 3 pages to print. When Sheet2 prints, I want the page number to start with Page4.

Is this possible?

 

[RonB1111]

In the Page Setup window, click the Header/Footer tab, then click Custom Footer.
Click the 2nd icon from the left to insert "page #",
If you also want the total number of pages (eg 1 of 8) type " of " and then click the 3rd icon.
Do this on every tab.
When printing, in the Print window place a check next to "Entire Workbook" and then click ok.