Workbook sheet page numbering?

[Don]

Is there away to get sequential page numbers in each
footer for each page if I print an entire workbook?
Example: If Sheet One is 3 pages, Sheet Two would start
number at 4 and so on..Thanks

 

[Erica]

Go to File -> Page Setup. Choose the Header/Footer tab.
Change the footer to "Page 1 of ?" on each page of your
workbook. Now, choose File -> Print. Choose "Workbook"
from the list and click the Preview button. You will see
the page numbers.

 

[don]

THANKS!

-----Original Message-----
Go to File -> Page Setup. Choose the Header/Footer tab.
Change the footer to "Page 1 of ?" on each page of your
workbook. Now, choose File -> Print. Choose "Workbook"
from the list and click the Preview button. You will see
the page numbers.


.

 

[Debra Dalgleish]

Add the page number to the footer of each sheet in the workbook.
To format all sheets at the same time, you can group them --

Right-click on any sheet tab
Choose Select All Sheets

To add the footer:
While the sheets are grouped, choose View>Header and Footer
From the Footer dropdown, choose Page 1, or click the Custom Footer
button and add the Page # to one of the footer sections
Click OK, click OK

To ungroup the sheets, right-click on a sheet tab,
and choose Ungroup Sheets

To print all the sheets with sequential numbers, group the sheets, then
click the Print button.