Images blurry when saving PDF from Excel












0















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.










share|improve this question



























    0















    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.










    share|improve this question

























      0












      0








      0








      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.










      share|improve this question














      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






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 4 '16 at 13:43









      HeartcloudHeartcloud

      324




      324






















          2 Answers
          2






          active

          oldest

          votes


















          1














          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.






          share|improve this answer































            0














            In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):



            Save-As Options



            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.






            share|improve this answer
























            • 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











            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
            });


            }
            });














            draft saved

            draft discarded


















            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









            1














            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.






            share|improve this answer




























              1














              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.






              share|improve this answer


























                1












                1








                1







                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.






                share|improve this answer













                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.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Dec 13 '18 at 13:22









                DschoniDschoni

                1163




                1163

























                    0














                    In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):



                    Save-As Options



                    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.






                    share|improve this answer
























                    • 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
















                    0














                    In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):



                    Save-As Options



                    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.






                    share|improve this answer
























                    • 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














                    0












                    0








                    0







                    In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):



                    Save-As Options



                    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.






                    share|improve this answer













                    In Excel's 'Save-As' dialog, you can chose the resolution used for PDF (bottom left, 'Tools/Compress Pictures'):



                    Save-As Options



                    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.







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Apr 4 '16 at 14:04









                    AganjuAganju

                    8,47731335




                    8,47731335













                    • 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













                    • 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


















                    draft saved

                    draft discarded




















































                    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.




                    draft saved


                    draft discarded














                    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





















































                    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







                    Popular posts from this blog

                    How to make a Squid Proxy server?

                    Is this a new Fibonacci Identity?

                    19世紀