+ Reply to Thread
Results 1 to 19 of 19

Excel will not print images at correct height/width!!

  1. #1
    Registered User
    Join Date
    01-09-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    5

    Exclamation Excel will not print images at correct height/width!!

    The issue involves how Excel is distorting images when placed in a sheet.

    I won't bore you with all the details on the exact graphics I made, but if you want to duplicate this problem, simply create a graphic in Photoshop or someplace, and have a border on your graphic, used a grid pattern for testing if you can. Make the graphic something like 5"x5" at 600DPI, or any square or rectangle size that should fit in a 8.5x11 sheet in Excel.

    The graphic I NEED to use happens to be 7.45" x 9.605" and is 4470x5763 pixels in size. This file was created in Photoshop and I export it as a TIFF.

    First thing to note is that in Excel, my page properties say that it will print at 600dpi, so that's why I'm working with that in Photoshop. Note that I've tried to use 200dpi, and even lower as well, it happens at any dpi.

    Next, insert the graphic into Excel, I've done this three different ways for testing, and I have the problem in all cases. I've used Insert-Picture. I've inserted the picture into the header (which is what I need to do), and I've also set the image as the sheet background.

    Here is the problem. You would THINK that because my graphic is 7.45x9.605, it would fit on a 8.5x11 sheet in Excel? It doesn't, the left and right part of the graphic are completely off page, and the top and bottom are are nearly squished to the far edges. This I don't understand, my graphic is smaller than 8.5x11 so why wouldn't it fit inside a page? Excel is widening it to a second page! My math may be weird, but 7.45" should fit on a sheet 8.5" wide and not need two pages right?

    To try and fix this, I played with margins and the ONLY way to see my graphic on a single sheet is to set all margins to ZERO! And even then, there is almost no room top to bottom, and the left and right sides are also wider, and if I try to print, it gets cropped.

    The question is, I KNOW my graphic is 7.45x9.605. And I KNOW that an Excel sheet is 8.5x11. And I KNOW my graphic is not being distorted, because in the image properties, scale is 100% and everything is original size. I KNOW my Photoshop document was 600dpi, and I KNOW Excel Page property says 600dpi. I KNOW that if I print my border from Word, or from the exported PDF, or from the Photoshop document, or the TIFF export, they ALL come out identical in size, but only if I place the image in Excel I cannot get it to size right no matter what I do.

    I have spent hours and hours researching and checking every option I can find and nothing makes a difference, Excel just will not display the image at the correct size.
    I've tried images at 4"x4", 5"x5", 7.5"x9.5" and all of them distort and come out different sizes. I've tried different DPIs, I've tried JPG as well as TIFF. I've done everything I can and Excel simply will NOT print or show the images correctly!

    Here are two screen shots of one test. This one is a view of my sheet, I have TWO grids on the sheet, a black grid inserted into the header, and a red grid inserted as a picture, they are both 4"x4" images and you can see here they overlay perfectly, you only see the red grid, not the black one.
    http://www.mediafire.com/view/?w3q9xmx30d1d9o2

    In this shot, I simply enter print preview, now for no apparent reason, the red grid moves, and the black grid expands in width and they aren't lined up any more.
    http://www.mediafire.com/view/?s4de2hdydhgpr1n

    Here is another test. on my 5"x5" image, when I print it, instead of being 5" wide, it is 5 and 5/16ths wide. And instead of 5" tall, it is 4 and 13/16ths! So here it gets wider, then shrinks in height! No rhyme or reason!
    On the image I am really needing, I tested a graphic 7.5x9.5 inches and on that one, I get 9/16ths wider and 5/16ths smaller height.

    It is very important that my images maintain the correct size. Excel becomes rather useless for my needs if I can't put an accurate image in it! Surely something is wrong on my end? I would love if some of you test and print an image and measure it to see if it comes out right, or can tell me why mine are distorting in size. Here is a 5"x5" grid you can test with:
    http://www.mediafire.com/view/?23ele2nbq9yk6fa

    I have a LOT of work to do and cannot continue until I figure out why images don't print at the right size and are being resized even when the properties show no changes to proportion or size.


    Thanks a TON for any suggestions!

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel will not print images at correct height/width!!

    Have you tried going through Word by pasting as a bitmap and then copy-pasting into Excel??
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    01-09-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel will not print images at correct height/width!!

    OK, I put the TIFF in Word and printed it, came out good. So I did a copy/paste into Excel and printed, and it came out the right width, but 5/32" shorter in height.

    I do need this to work as a file insert, not a copy/paste. Word doesn't operate at as high a DPI as Excel? I think Word is like 200dpi max, I forget. I need the highest quality graphic I can for the Excel.

    What is the reason for going through Word first? Should I try this as something other than JPG or TIFF?

    Thanks

  4. #4
    Registered User
    Join Date
    01-09-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel will not print images at correct height/width!!

    By the way, Word seems to convert images to 96DPI, so that's way too low quality to use that workaround, even though it didn't really work anyway.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel will not print images at correct height/width!!

    What is the reason for going through Word first? Should I try this as something other than JPG or TIFF?
    Maybe BMP???

  6. #6
    Registered User
    Join Date
    08-27-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Excel will not print images at correct height/width!!

    Why are you using Excel for hi-res graphics work?

    If you'll post a graphic, I'll play around and see if I can get it to work, but I'm too busy to create my own to solve your problem.

  7. #7
    Registered User
    Join Date
    01-09-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel will not print images at correct height/width!!

    I posted a 5"x5" grid in the OP. To test all I want is insert the image in a sheet and print. It will either measure wrong or right.

    So far I've tested Excel 2007 and 2010, and also tested Excel on Mac, and using two different printers and 3 computers. None have printed correct sizes.

    I've also tested with TIFF, JPG, BMP, and PNG. I've tested from 96DPI all the way up to 600DPI. I've changed umpteen printer and print properties, quality settings etc. I've probably printed 50 test pages.

    The reason I'm in Excel is because it's for data entry, however, data is being printed from numerous sheets with the entered data, overlaid on the graphic. It's sort of like a mail merge would be in Word, except that I need Excel functionality on the data.

    Word is actually worse, since it wants to convert images to even lower res. Excel tells me in the page properties that it is printing 600DPI, which is plenty adequate.

    Here is a link to he grid, the forum doesn't allow TIF I guess:
    http://www.mediafire.com/view/?23ele2nbq9yk6fa


    I won't allow any excuses for MS on this one, people can say "well Excel isn't for graphics" but that doesn't matter. It's distorting images, this would apply to any graphical need on Excel, it looks different on page then on print preview, and measures different on print! That can mess with any important graphic like technical graphics, borders (which is like what I need), corporate logos/letterheads etc. Excel should most definitely be smart enough to accept a 5x5 graphic and print it 5x5, not 5 5/16" x 4 13/16". Not when Excel reports the image dimensions correctly in the program. Something is certainly wrong, or bugged, in image handling. Unless one of you can find out what is wrong!


    Thanks

  8. #8
    Registered User
    Join Date
    08-27-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Excel will not print images at correct height/width!!

    I played with your image, and I can confirm the problem you are having. It is definitely an Excel issue, and not a printer or computer issue. I put the image into a header and put text in several cells, and when I enter Print Preview, the image moves relative to the text.

    I did a google search for "excel resizes images when printing" and this is not unique to you. It apparently started with Excel 2007. If you have access to an older version, you may want to try that.

    I also found this in one of the search results:
    I had this problem before, this seem to work in early versions of
    excel, but not in 2007. Here is how I solved the issue:
    1) Click on the image.
    2) Hold down Shift and go to the Edit menu, then select Copy Picture.
    3) Hit Paste.
    Good luck.

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel will not print images at correct height/width!!

    The reason (or the main reason) that I stayed with 2003 is that 2007 messed up my shapes. I'm also a misribbonist!

  10. #10
    Registered User
    Join Date
    01-09-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel will not print images at correct height/width!!

    The copy/paste trick didn't do anything, it pasted the image exactly as the copied one.

    I tried doing a save-as to Excel 97-2003 and then inserting the image, it also did the same thing.


    I really hope there is a fix for this in the world, maybe there is a patch or hotfix out that is hard to find?

  11. #11
    Registered User
    Join Date
    01-11-2013
    Location
    Farmington, New Mexico
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Excel will not print images at correct height/width!!

    Quote Originally Posted by handerson0603 View Post
    Why are you using Excel for hi-res graphics work?
    .....
    I would want to do hi-res.graphics work with Excel because I know Excel and it already does most of the graphics I need. I am able to use Excel's visual basic editor and don't know if I would have to learn a lot of new stuff to use another program. Can someone just improve Excel to make hi-res graphics efficient?
    Last edited by Fun Value; 01-11-2013 at 06:24 PM.

  12. #12
    Registered User
    Join Date
    08-27-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Excel will not print images at correct height/width!!

    Quote Originally Posted by handerson0603 View Post
    I did a google search for "excel resizes images when printing" and this is not unique to you. It apparently started with Excel 2007. If you have access to an older version, you may want to try that.
    I got here from a Google Search of "excel not printing to scale" so leaving a comment for anyone else.

    I am having this problem too. Using Excel 2010. I don't have access to an AutoCAD or Visio license and wanted to mock up a quick layout to scale. I used VBA code to set column width and height in cm, and inserted basic shapes which I sized exactly using the properties menu. I also changed their properties to "Move but do not size with cells" just in case.

    Visually, on-screen this is fine. Perfect circles are visually perfect circles.

    When I print the document, the entire thing is stretched horizontally by 2mm - both column widths AND inserted shapes are stretched. All heights (rows and shapes) are perfect - I checked with a ruler.

    TL;DR: A 50mm x 50mm (HxW) inserted circle shape in Excel prints out as a 50mm x 52mm oval FOR NO DISCERNABLE REASON.

    People say "why are you using Excel for graphics?" well, I'm sure Mr Joe Accountant doesn't want his perfect circle call-out to magically change into an oval either... This is a real problem

  13. #13
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel will not print images at correct height/width!!

    Have you tried running it through the publisher?

  14. #14
    Registered User
    Join Date
    07-12-2016
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    1

    Re: Excel will not print images at correct height/width!!

    I know this is an old thread but I encountered this issue recently when trying to insert photos into Excel and noticed in print preview and when printing, they came out distorted/squashed. Anyway, I found a solution for anyone else searching for answers. It worked for me on Excel version 2010 on Windows 10.
    Here is how I fixed it!

    Go to Page Layout
    In the drop down box "Fonts", when you hover over the options, you should see your columns resizing.
    Now select "Metro"

    ExcelFixDistortedImage.jpg

    Go into print preview and your images should display correctly.
    Note: you can still change the fonts and column widths to whatever size you want even though you initially selected "Metro" as the font theme.

    Why does this work?
    I don't really know but I think it has something to do with the column sizing being based on number of characters - not pixels. So the size of the column changes depending on the font theme you choose. "Consolas" is a fixed width font so I am guessing the calculation of the column width is more accurate. In that case, it should also work with any font theme that has a fixed width font like "Courier". How this is linked to the distortion of images/shapes I don't know.

  15. #15
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel will not print images at correct height/width!!

    Hi Chinchilla,

    Welcome to the Forum! Thanks for the tip

  16. #16
    Registered User
    Join Date
    12-29-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Excel will not print images at correct height/width!!

    Quote Originally Posted by Chinchilla View Post
    I know this is an old thread but I encountered this issue recently when trying to insert photos into Excel and noticed in print preview and when printing, they came out distorted/squashed. Anyway, I found a solution for anyone else searching for answers. It worked for me on Excel version 2010 on Windows 10.
    Here is how I fixed it!

    Go to Page Layout
    In the drop down box "Fonts", when you hover over the options, you should see your columns resizing.
    Now select "Metro"

    Attachment 470016

    Go into print preview and your images should display correctly.
    Note: you can still change the fonts and column widths to whatever size you want even though you initially selected "Metro" as the font theme.

    Why does this work?
    I don't really know but I think it has something to do with the column sizing being based on number of characters - not pixels. So the size of the column changes depending on the font theme you choose. "Consolas" is a fixed width font so I am guessing the calculation of the column width is more accurate. In that case, it should also work with any font theme that has a fixed width font like "Courier". How this is linked to the distortion of images/shapes I don't know.
    Thank you Chinchilla, this tip works great..

  17. #17
    Registered User
    Join Date
    03-27-2015
    Location
    México
    MS-Off Ver
    2010
    Posts
    1

    Re: Excel will not print images at correct height/width!!

    Damn dude, you saved me, thanks for that tip, I would never figured it out. Thanks again.

  18. #18
    Registered User
    Join Date
    08-14-2019
    Location
    Maryland
    MS-Off Ver
    365 ProPlus
    Posts
    1

    Re: Excel will not print images at correct height/width!!

    I don't have the Metro or Courier font available. Consolas didn't work. Any other suggestions?

  19. #19
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,903

    Re: Excel will not print images at correct height/width!!

    Administrative Note:

    Hello Dressage Rider and Welcome to Excel Forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1