printing multiple worksheets in a workbook

S

SFM

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!!!!
 
D

dlw

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top