Total Page Numbers in Workbook

[Julie]

Is there a way to put the total number of pages in the
WORKBOOK in the footer of each worksheet?

Thanks.

 

[Vasant Nanavati]

Hi Julie:

File | Page Setup | Header/Footer | Custom Footer.

The third icon from the left (with two + signs) will give the total number
of pages in whatever you are printing. If you are printing the whole
workbook, you will get the number of pages in the entire workbook.

Regards,

Vasant.

 

[Julie]

Thanks, but this assumes that the entire workbook would
be printed at one time. I want to be able to print one
worksheet, but know what page number it is for the whole
workbook. Is this possible?

 

[Bob C]

Hi Julie
File | Page Setup ? Header/Footer click on footer
dropdown arrow and select Page 1 of ?
or use the icon buttons to enter &[Page] and &[Pages]
place an of between the two ie &[Page] of &[Pages]
HTH
Bob Christie

 

[Tom Ogilvy]

Not dynamically.

Unless you want to write a macro to go through and count all the pages, then
update the hard coded number in your footer/header - then there is no built
in support for what you describe.

Regards,
Tom Ogilvy