Print Multiple Sheets to PDF Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a workbook of 13 tabs. I am trying to print 9 of them to a single
PDF file. I highlight, all 9 sheets by pressing and holding the Ctrl key,
then press print. The result is 3 seperate PDF files (PDF1 with sheets 1-4
combined, PDF2 file with sheets 5 & 6 combined, and PDF3 with sheets 7-9
combined). Additionally, it seems to always group the same sheets together.
For example, if I select sheets 1, 2, 6, 8, and 9 for printing, sheets 1 & 2
will be one PDF, 6 will be its own PDF, and 8 & 9 will be the third PDF.

Why is it doing this? How can I get all 9 sheets to print to a single PDF
file?
 
That solution is a little intense for my needs, but thanks for the reference.

As a side, I found that if I print from the print preview screen (vs.
selecting File>Print), it will print all pages to one file. Strange... just
a Microsoft quirk I guess...

Thanks!
 
Back
Top