Workbook Page Numbering

[Andrew]

Any way I can number worksheet pages that reflect the
entire workbook? For example, let's say sheet1 has 3
pages and sheet2 has 4 pages... to have each page
print "page 1 of 7", "page 2 of 7"... thanks!

 

[Gord Dibben]

Andrew

Select first sheet then right-click on the sheet tab and "select all sheets".

Then in Print check "Entire Workbook"

Gord Dibben Excel MVP

 

[John L]

Set the footers to print x of y in the normal way. When
you are printing highlight/group both sheets and then
select "Print Active Sheets" This will then print as 1 of
7 etc