Workbook Page Numbering

A

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!
 
G

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
 
J

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
 
Top