Page Numbering

[Guest]

First, if this comes through a second time, I am sorry, my PC hung up.
I have 4 worksheets within a workbook. I want page numbers to start:
page 1 of 200. Question: In my footer: I want to start the numbering with
page 1 of 200 and continue on through all my worksheets. Is there a way to
continue with page numbering on other worksheets. (on worksheet b, it would
start with whatever ended from worksheet A, etc with the total)

Thanks,

 

[Gord Dibben]

Pam

Select first sheet then right-click and "Select all sheets".

File>Page Setup>Headers and Footers.

From the default settings select Page 1 of ?

All sheets will be included in the print setup.

Then just go to File>Print>Active sheets or Entire workbook.


Gord Dibben Excel MVP