Printing multiple worksheets to one single pdf file
 

I have browsing through thread after thread of this same issue, with no
resolution found.

I have selected each worksheet using the ctrl or the shift key, selected
each worksheet, selected the Adobe pdf printer selected both "active sheets"
and "Entire Workbook" and still, keeps printing to multiple files.

Is this insane?

Printing multiple worksheets to one single pdf file
 

Try this:
Select all the sheets you want to print (with ctrl or shift like you did)
pick File / page setup / Page tab
towards the bottom, change the print quality to 300 dpi
OK
Then print it.
(ps, if it already says 300 dpi, highlight it and pick it again)



"Gene" wrote:

I have browsing through thread after thread of this same issue, with no
resolution found.

I have selected each worksheet using the ctrl or the shift key, selected
each worksheet, selected the Adobe pdf printer selected both "active sheets"
and "Entire Workbook" and still, keeps printing to multiple files.

Is this insane?

Printing multiple worksheets to one single pdf file
 

dlw,

I certainly don't know who you are, but you are a God send.

Thank you so much. It worked perfectly.

One more question though, why does this do this?

"dlw" wrote:

Try this:
Select all the sheets you want to print (with ctrl or shift like you did)
pick File / page setup / Page tab
towards the bottom, change the print quality to 300 dpi
OK
Then print it.
(ps, if it already says 300 dpi, highlight it and pick it again)



"Gene" wrote:

I have browsing through thread after thread of this same issue, with no
resolution found.

I have selected each worksheet using the ctrl or the shift key, selected
each worksheet, selected the Adobe pdf printer selected both "active sheets"
and "Entire Workbook" and still, keeps printing to multiple files.

Is this insane?