PRINT PAGES FROM DIFF TABS WITH PAGE NUMBER 11 TO 19


G

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top