Print Multiple Sheets to PDF Problem

[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?

 

[David McRitchie]

Hi Todd,
Here is a solution by Ken Puls to "Print Multiple Worksheets to a Single PDF File:"
http://www.excelguru.ca/node/21#MultiSingle
it has been written to use PDFCreator which is free. You should of course
read from the beginning of the top of the page.

 

[Guest]

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!

 

[David McRitchie]

I think I like your solution better too, as I would only be
doing such things manually anyway. Anyway had some
interesting reading.

NASA used Ken's solution or a modification:
http://www.managementmag.com/index.cfm/ci_id/9127/la_id/1