Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplex Printing of Workbook with multiple worksheets | Excel Discussion (Misc queries) | |||
selecting a series of worksheets for printing not whole workbook | New Users to Excel | |||
Printing multiple worksheets in a workbook | Excel Discussion (Misc queries) | |||
Printing multiple worksheets from one workbook | Excel Worksheet Functions | |||
Printing all worksheets in a workbook using a duplex printer | Excel Discussion (Misc queries) |