Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PRINT PAGES FROM DIFF TABS WITH PAGE NUMBER 11 TO 19
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PRINT PAGES FROM DIFF TABS WITH PAGE NUMBER 11 TO 19
Right-click on a sheet tab and "select all sheets".
FilePage SetupFirst 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 On Thu, 6 Sep 2007 13:12:06 -0700, Flabank wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
How do you attach tabs to make one page or several pages? | Excel Worksheet Functions | |||
sheet tabs as page number and in a cell page of pages? | Excel Discussion (Misc queries) | |||
How do I fix diff from print preview and the actual printed page | Excel Discussion (Misc queries) | |||
Can I print 2 pages on 1 page? | Excel Discussion (Misc queries) |