Continuous page numbering when printing whole book
Hello again, I want to be able to print all the sheets in a workbook, each
sheet might print on one page or many pages, BUT... I want the first sheet to start numbering at 1 and then, if sheet one prints over three pages (numbered 1, 2 & 3), I want sheet two to be numbered starting at 4, etc... so the whole book will print as one document with consecutive page numbers from start to end. Is there a known way to do this? Thanks Michelle |
Continuous page numbering when printing whole book
Try selecting all the sheets that you want to print and then printing. Click on
the first tab and ctrl-click on subsequent tabs. Remember to ungroup the sheets when you're done. Almost everything you do to one sheet will be done to the others in that grouping. If you want to print all the sheets, you can show the print dialog: File|Print (in xl2003 menus) Select Entire Workbook in the Print What section -- don't use active sheet(s). Michelle wrote: Hello again, I want to be able to print all the sheets in a workbook, each sheet might print on one page or many pages, BUT... I want the first sheet to start numbering at 1 and then, if sheet one prints over three pages (numbered 1, 2 & 3), I want sheet two to be numbered starting at 4, etc... so the whole book will print as one document with consecutive page numbers from start to end. Is there a known way to do this? Thanks Michelle -- Dave Peterson |
Continuous page numbering when printing whole book
I was just about to reply and tell you that you hadn't addressed my
page-numbering issue, when I tried it and of course you had! Thanks M "Dave Peterson" wrote in message ... Try selecting all the sheets that you want to print and then printing. Click on the first tab and ctrl-click on subsequent tabs. Remember to ungroup the sheets when you're done. Almost everything you do to one sheet will be done to the others in that grouping. If you want to print all the sheets, you can show the print dialog: File|Print (in xl2003 menus) Select Entire Workbook in the Print What section -- don't use active sheet(s). Michelle wrote: Hello again, I want to be able to print all the sheets in a workbook, each sheet might print on one page or many pages, BUT... I want the first sheet to start numbering at 1 and then, if sheet one prints over three pages (numbered 1, 2 & 3), I want sheet two to be numbered starting at 4, etc... so the whole book will print as one document with consecutive page numbers from start to end. Is there a known way to do this? Thanks Michelle -- Dave Peterson |
All times are GMT +1. The time now is 04:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com