Add Page x of x based on sheets.

[myhnews]

I have a document with about 40 sheets. Is there a way to have the
Page x of x be displayed on all sheet. But Page 1 should be sheet 1.
Page 2 should be Sheet 2 etc.

Let's go one more step.

Each sheet has 2 pages. Is it possible to have
Sheet 1, Page 1 to display Page 1 of 80
Sheet 1, Page 2 to display Page 2 of 80
Sheet 2, Page 1 to display Page 3 of 80
Sheet 2, Page 2 to display Page 4 of 80
Etc.

Thank you

 

[Gord Dibben]

Select Sheet1 then right-click and "select all sheets".

Set up your footer or header as Page 1 of ? on the activesheet.

Then print the lot as one print job.

Page numbers will be incremented as you ask.


Gord Dibben MS Excel MVP