printing multiple worksheets in a workbook
in [General]
|
Prev: Data visible in formula bar, but not in cells
Next: Export data from the same cell from multiple spreadsheets into a n
From: SFM on 16 Apr 2010 11:11 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!!!!
From: dlw on 16 Apr 2010 12:26
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!!!! |