Printing Multiple worksheets as a single print job

mpiquet

New Member
Joined
Feb 26, 2007
Messages
2
Here's a simple problem that has been bugging me for a couple years now. If I select a group of worksheets in a workbook (contiguous or not, doesn't matter) and print the group, sometimes I get a single print job and sometimes I get multiple print jobs. Multiple print jobs are an annoyance when printing to PDF or other "virtual" printers as each job requires its own filename. I then have to combine the PDF's later. I've tried everything I can think of to determine what's different about the workbooks that a single print job vs. the workbooks that create several print jobs.

Please help!

Best,
Marcus
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
It has to do with different page settings - try setting the margins equally on all pages. This goes easiest by selecting all sheets, then go to page settings and click ok (this makes all the sheets' settings according to the active sheet).
 
Upvote 0
Actually it's not the margins. Having different margins does not affect how many print jobs are created. I found the answer on Adobe's website - it is the page's resolution. I had a worksheet in the middle of my workbook whose "print quality" was blank instead of 600 dpi. That caused a discreet print job for the one worksheet with a different print resolution than the others.
 
Upvote 0

Forum statistics

Threads
1,214,861
Messages
6,121,973
Members
449,059
Latest member
oculus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top