Page x of y in WorkBook

  • Thread starter Thread starter Trainer
  • Start date Start date
T

Trainer

Using Excel 2007 on Windows XP. We have 3 worksheets with 10 pages each.
We want the total pages in the workbook. For example, Page 1 of 30, Page 2
of 30, etc. I tried grouping the 3 worksheets but that didn't give me the
result I want. Can this even be done? Most stuff can, if you just know
how. Thanks for any ideas.
 
That's how I would do it.

Select all three sheets and set up your footer as page 1 of ?.

Print as one print job using ActiveSheet(s)


Gord Dibben MS Excel MVP
 
Back
Top