Add Page x of x based on sheets.
 

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

Add Page x of x based on sheets.
 

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


On 11 Apr 2007 15:49:35 -0700, wrote:

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