If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
printing multiple worksheets in a workbook
I have 13 worksheets in my workbook (Excel 2007). They are all formatted to
have page numbers thus "Page x of y". However, when I select all worksheets and try to print them, the printer window reflects 6 documents waiting in the queue. On printing the document even with the collate box checked, the output is not sequential according to the page numbers from either back to front or front to back. This is even more frustrating when printing to pdf (Cute PDF Writer) as the print to pdf creates 6 different files instead of printing all to one pdf file. I need help!!!! |
#2
|
|||
|
|||
printing multiple worksheets in a workbook
this will fix the pdf issue, not sure about the other:
1. In Excel, hold down the Ctrl key, and select all of the sheets in the Excel workbook. 2. Choose File Page Setup Page Print Quality, and select 600dpi. It it already says 600dpi, click into the field and select it again. "SFM" wrote: I have 13 worksheets in my workbook (Excel 2007). They are all formatted to have page numbers thus "Page x of y". However, when I select all worksheets and try to print them, the printer window reflects 6 documents waiting in the queue. On printing the document even with the collate box checked, the output is not sequential according to the page numbers from either back to front or front to back. This is even more frustrating when printing to pdf (Cute PDF Writer) as the print to pdf creates 6 different files instead of printing all to one pdf file. I need help!!!! |
Thread Tools | |
Display Modes | |
|
|