Images blurry when saving PDF from Excel
If I insert images into Excel, then save the worksheet as a PDF, the images become extremely blurry and jagged, even worse than the "lowest" JPG setting in Photoshop. It's so bad that the image is barely recognizable.
Is it because Excel is automatically compressing all images? Or some setting with exporting PDFs? I do not have Acrobat on this work computer.
microsoft-excel pdf images adobe-reader
asked Apr 4 '16 at 13:43
Heartcloud
324
add a comment |
If I insert images into Excel, then save the worksheet as a PDF, the images become extremely blurry and jagged, even worse than the "lowest" JPG setting in Photoshop. It's so bad that the image is barely recognizable.
Is it because Excel is automatically compressing all images? Or some setting with exporting PDFs? I do not have Acrobat on this work computer.
microsoft-excel pdf images adobe-reader
asked Apr 4 '16 at 13:43
Heartcloud
324
add a comment |
If I insert images into Excel, then save the worksheet as a PDF, the images become extremely blurry and jagged, even worse than the "lowest" JPG setting in Photoshop. It's so bad that the image is barely recognizable.
Is it because Excel is automatically compressing all images? Or some setting with exporting PDFs? I do not have Acrobat on this work computer.
microsoft-excel pdf images adobe-reader
asked Apr 4 '16 at 13:43
Heartcloud
324
If I insert images into Excel, then save the worksheet as a PDF, the images become extremely blurry and jagged, even worse than the "lowest" JPG setting in Photoshop. It's so bad that the image is barely recognizable.
Is it because Excel is automatically compressing all images? Or some setting with exporting PDFs? I do not have Acrobat on this work computer.
microsoft-excel pdf images adobe-reader
microsoft-excel pdf images adobe-reader
asked Apr 4 '16 at 13:43
Heartcloud
324
asked Apr 4 '16 at 13:43
Heartcloud
324
asked Apr 4 '16 at 13:43
Heartcloud
324
asked Apr 4 '16 at 13:43
Heartcloud
324
asked Apr 4 '16 at 13:43
Heartcloud
324
324
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):
Check what your current setting is, it might be set to Email or so.
Also, not that if your picture is very small while in the Excel Sheet (because you plan to click into it to really use it), excel might just think that small size is all you need. Make sure you drag it large enough to represent the size you really want.
answered Apr 4 '16 at 14:04
Aganju
8,42231335
Compress pictures settings is already set to highest (print: 220dpi). The icon is sized to fit cells, I can't make them any bigger. They're pretty big already, at least 100x100.
– Heartcloud
Apr 4 '16 at 14:17
did you try 'Use Document Resolution'? I would understand that as 'leave it as it is'
– Aganju
Apr 4 '16 at 14:20
Yeah I tried all 4 compression settings, they seem to make no difference at all. If I insert an image then make it smaller, it seems it turns out even worse. If I just leave the image at its original size then it becomes very blurry still, but slightly less jagged.
– Heartcloud
Apr 4 '16 at 14:22
add a comment |
Since I came here via Google and the answer to this question didn't help me I found a solution that works for me. The printing quality depends on several factors. One factor is the standard quality of the document itself. In newer Excel Versions (in my case Office 365), the default quality can be set to high in the options.
File-->Options-->Advanced
The relevant options are under the sections Image Size and Quality as well as Printing. For best results, the default resolution has to be set to High Fidelity.
The second factor that can decrease the image quality is a PDF printer with a low quality. With the standard Microsoft print to PDF printer, the quality can be set inside the print dialog under the Page Setup options. (If you accidentialy or intentionally removed the Microsoft print to PDF printer, here is a tip on how to get it back.)
The third factor is a wrongly scaled image. To avoid multiple conversion steps, I scale my images according to the print resolution. Although I don't fully understand the inner workings of the print to pdf function, this three things help me to get a decent image quality when the quality of the input images is good enough.
answered Dec 13 at 13:22
Dschoni
1062
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1061204%2fimages-blurry-when-saving-pdf-from-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):
Check what your current setting is, it might be set to Email or so.
Also, not that if your picture is very small while in the Excel Sheet (because you plan to click into it to really use it), excel might just think that small size is all you need. Make sure you drag it large enough to represent the size you really want.
answered Apr 4 '16 at 14:04
Aganju
8,42231335
Compress pictures settings is already set to highest (print: 220dpi). The icon is sized to fit cells, I can't make them any bigger. They're pretty big already, at least 100x100.
– Heartcloud
Apr 4 '16 at 14:17
did you try 'Use Document Resolution'? I would understand that as 'leave it as it is'
– Aganju
Apr 4 '16 at 14:20
Yeah I tried all 4 compression settings, they seem to make no difference at all. If I insert an image then make it smaller, it seems it turns out even worse. If I just leave the image at its original size then it becomes very blurry still, but slightly less jagged.
– Heartcloud
Apr 4 '16 at 14:22
add a comment |
In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):
Check what your current setting is, it might be set to Email or so.
Also, not that if your picture is very small while in the Excel Sheet (because you plan to click into it to really use it), excel might just think that small size is all you need. Make sure you drag it large enough to represent the size you really want.
answered Apr 4 '16 at 14:04
Aganju
8,42231335
Compress pictures settings is already set to highest (print: 220dpi). The icon is sized to fit cells, I can't make them any bigger. They're pretty big already, at least 100x100.
– Heartcloud
Apr 4 '16 at 14:17
did you try 'Use Document Resolution'? I would understand that as 'leave it as it is'
– Aganju
Apr 4 '16 at 14:20
Yeah I tried all 4 compression settings, they seem to make no difference at all. If I insert an image then make it smaller, it seems it turns out even worse. If I just leave the image at its original size then it becomes very blurry still, but slightly less jagged.
– Heartcloud
Apr 4 '16 at 14:22
add a comment |
In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):
Check what your current setting is, it might be set to Email or so.
Also, not that if your picture is very small while in the Excel Sheet (because you plan to click into it to really use it), excel might just think that small size is all you need. Make sure you drag it large enough to represent the size you really want.
answered Apr 4 '16 at 14:04
Aganju
8,42231335
In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):
Check what your current setting is, it might be set to Email or so.
Also, not that if your picture is very small while in the Excel Sheet (because you plan to click into it to really use it), excel might just think that small size is all you need. Make sure you drag it large enough to represent the size you really want.
answered Apr 4 '16 at 14:04
Aganju
8,42231335
answered Apr 4 '16 at 14:04
Aganju
8,42231335
answered Apr 4 '16 at 14:04
Aganju
8,42231335
answered Apr 4 '16 at 14:04
Aganju
8,42231335
8,42231335
Compress pictures settings is already set to highest (print: 220dpi). The icon is sized to fit cells, I can't make them any bigger. They're pretty big already, at least 100x100.
– Heartcloud
Apr 4 '16 at 14:17
did you try 'Use Document Resolution'? I would understand that as 'leave it as it is'
– Aganju
Apr 4 '16 at 14:20
Yeah I tried all 4 compression settings, they seem to make no difference at all. If I insert an image then make it smaller, it seems it turns out even worse. If I just leave the image at its original size then it becomes very blurry still, but slightly less jagged.
– Heartcloud
Apr 4 '16 at 14:22
add a comment |
Compress pictures settings is already set to highest (print: 220dpi). The icon is sized to fit cells, I can't make them any bigger. They're pretty big already, at least 100x100.
– Heartcloud
Apr 4 '16 at 14:17
did you try 'Use Document Resolution'? I would understand that as 'leave it as it is'
– Aganju
Apr 4 '16 at 14:20
Yeah I tried all 4 compression settings, they seem to make no difference at all. If I insert an image then make it smaller, it seems it turns out even worse. If I just leave the image at its original size then it becomes very blurry still, but slightly less jagged.
– Heartcloud
Apr 4 '16 at 14:22
Compress pictures settings is already set to highest (print: 220dpi). The icon is sized to fit cells, I can't make them any bigger. They're pretty big already, at least 100x100.
– Heartcloud
Apr 4 '16 at 14:17
Compress pictures settings is already set to highest (print: 220dpi). The icon is sized to fit cells, I can't make them any bigger. They're pretty big already, at least 100x100.
– Heartcloud
Apr 4 '16 at 14:17
did you try 'Use Document Resolution'? I would understand that as 'leave it as it is'
– Aganju
Apr 4 '16 at 14:20
did you try 'Use Document Resolution'? I would understand that as 'leave it as it is'
– Aganju
Apr 4 '16 at 14:20
Yeah I tried all 4 compression settings, they seem to make no difference at all. If I insert an image then make it smaller, it seems it turns out even worse. If I just leave the image at its original size then it becomes very blurry still, but slightly less jagged.
– Heartcloud
Apr 4 '16 at 14:22
Yeah I tried all 4 compression settings, they seem to make no difference at all. If I insert an image then make it smaller, it seems it turns out even worse. If I just leave the image at its original size then it becomes very blurry still, but slightly less jagged.
– Heartcloud
Apr 4 '16 at 14:22
add a comment |
Since I came here via Google and the answer to this question didn't help me I found a solution that works for me. The printing quality depends on several factors. One factor is the standard quality of the document itself. In newer Excel Versions (in my case Office 365), the default quality can be set to high in the options.
File-->Options-->Advanced
The relevant options are under the sections Image Size and Quality as well as Printing. For best results, the default resolution has to be set to High Fidelity.
The second factor that can decrease the image quality is a PDF printer with a low quality. With the standard Microsoft print to PDF printer, the quality can be set inside the print dialog under the Page Setup options. (If you accidentialy or intentionally removed the Microsoft print to PDF printer, here is a tip on how to get it back.)
The third factor is a wrongly scaled image. To avoid multiple conversion steps, I scale my images according to the print resolution. Although I don't fully understand the inner workings of the print to pdf function, this three things help me to get a decent image quality when the quality of the input images is good enough.
answered Dec 13 at 13:22
Dschoni
1062
add a comment |
Since I came here via Google and the answer to this question didn't help me I found a solution that works for me. The printing quality depends on several factors. One factor is the standard quality of the document itself. In newer Excel Versions (in my case Office 365), the default quality can be set to high in the options.
File-->Options-->Advanced
The relevant options are under the sections Image Size and Quality as well as Printing. For best results, the default resolution has to be set to High Fidelity.
The second factor that can decrease the image quality is a PDF printer with a low quality. With the standard Microsoft print to PDF printer, the quality can be set inside the print dialog under the Page Setup options. (If you accidentialy or intentionally removed the Microsoft print to PDF printer, here is a tip on how to get it back.)
The third factor is a wrongly scaled image. To avoid multiple conversion steps, I scale my images according to the print resolution. Although I don't fully understand the inner workings of the print to pdf function, this three things help me to get a decent image quality when the quality of the input images is good enough.
answered Dec 13 at 13:22
Dschoni
1062
add a comment |
Since I came here via Google and the answer to this question didn't help me I found a solution that works for me. The printing quality depends on several factors. One factor is the standard quality of the document itself. In newer Excel Versions (in my case Office 365), the default quality can be set to high in the options.
File-->Options-->Advanced
The relevant options are under the sections Image Size and Quality as well as Printing. For best results, the default resolution has to be set to High Fidelity.
The second factor that can decrease the image quality is a PDF printer with a low quality. With the standard Microsoft print to PDF printer, the quality can be set inside the print dialog under the Page Setup options. (If you accidentialy or intentionally removed the Microsoft print to PDF printer, here is a tip on how to get it back.)
The third factor is a wrongly scaled image. To avoid multiple conversion steps, I scale my images according to the print resolution. Although I don't fully understand the inner workings of the print to pdf function, this three things help me to get a decent image quality when the quality of the input images is good enough.
answered Dec 13 at 13:22
Dschoni
1062
Since I came here via Google and the answer to this question didn't help me I found a solution that works for me. The printing quality depends on several factors. One factor is the standard quality of the document itself. In newer Excel Versions (in my case Office 365), the default quality can be set to high in the options.
File-->Options-->Advanced
The relevant options are under the sections Image Size and Quality as well as Printing. For best results, the default resolution has to be set to High Fidelity.
The second factor that can decrease the image quality is a PDF printer with a low quality. With the standard Microsoft print to PDF printer, the quality can be set inside the print dialog under the Page Setup options. (If you accidentialy or intentionally removed the Microsoft print to PDF printer, here is a tip on how to get it back.)
The third factor is a wrongly scaled image. To avoid multiple conversion steps, I scale my images according to the print resolution. Although I don't fully understand the inner workings of the print to pdf function, this three things help me to get a decent image quality when the quality of the input images is good enough.
answered Dec 13 at 13:22
Dschoni
1062
answered Dec 13 at 13:22
Dschoni
1062
answered Dec 13 at 13:22
Dschoni
1062
answered Dec 13 at 13:22
Dschoni
1062
1062
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1061204%2fimages-blurry-when-saving-pdf-from-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
