Printing page numbers in sequence order...

[Guest]

Is there a way to format excel so that when you select the print entire workbook option and you have multiple sheets within your workbook, the pages will print out in sequence order? For example if I have 5 sheets within my workbook and sheet one has 3 pages, sheet two has 5 pages, sheet three has 2 pages, sheet four has 1 page and sheet 5 has 3 pages... is there a way to format excel so that when I select print entire workbook it automatically prints page numbers 1-3 for pages in sheet one, page numbers 4-8 for pages in sheet two, page numbers 9-10 for pages in sheet three, page number 11 for sheet four page and page numbers 12-14 for pages in sheet five?

 

[Frank Kabel]

Hi
just select the sheets you want to print and in the File - Pagesetuo
dialog set the page numbering to 'automatic' (ithis option is on the
first tab)

 

[roger016]

I want to do exactly the opposite. I want to multiple select and prin
all pages ina worksheet but I want the numbering to read sheet A- page
1-3 followed by sheet B pages 1-5 et

 

[Frank Kabel]

Hi
set the number to 1 in this dialog