Printing quality Excel

Formula11

Active Member
Joined
Mar 1, 2005
Messages
479
Office Version
  1. 365
Platform
  1. Windows
I often paste contents from other workbooks as a Picture (Home/Paste/Other Paste Options/Picture (U)), into the main worbook.
Reason is that layout is very different, so can't paste cells.
When the main workbook is printed to PDF, using PDF-XChange, sometimes the print was clean like a vector image, and sometimes very fuzzy, like a raster image.

Finally figured out the reason, see below.
If there is an image within the selected cells which are pasted as a picture to the main workbook, the quality seems to go to fuzzy raster, second example. Because text is so small, yo can't read it.
With cells only pasted as a picture, the quality is clean, like a vector, first example.
Both captions below are pictures.

Can this be fixed in Excel?
Tried to change settings in PDF printer but no luck.

FROM PDF PRINTOUT
1738310158351.png
 
Thanks CoffeeCup, using the export did actually make a difference for a trial I just did, which is a good outcome.
The file size was bigger for the test and will have to see what happens with a real document print ... but this is a step in the right direction at least.
Thanks for looking into.
 
Upvote 0

Forum statistics

Threads
1,226,839
Messages
6,193,267
Members
453,786
Latest member
ALMALV

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