PRINT PAGES FROM DIFF TABS WITH PAGE NUMBER 11 TO 19

[Guest]

I am working with a worksheet with multiple tabs, and would like to print all
of my worksheets from these tabs with sequential page numbers starting with,
let's say 11 thru 19 without having to number them individually

Thanks

 

[Gord Dibben]

Right-click on a sheet tab and "select all sheets".

File>Page Setup>First Page Number........enter 11

Also while in page setup go to header/footer and place a header or footer with
Page1 of ?

The 1 will change to the number 11 when you preview or print.

DO NOT FORGET to ungroup the sheets when done with the setup and printing of the
selected sheets.


Gord Dibben MS Excel MVP