There are many posts about this on the internet. Here are a few:
- [SU] Microsoft Excel -- Images distorted when printing
- Images distorted when previewing or printing from Excel - Microsoft Community
The gist is, you put a perfect square picture on an excel spreadsheet, you get a vertically squished rectangle when you print. The workaround is to have distorted images on the page and then they print properly. This bug hasn't been fixed in 20 years.
There are 2 reproducable ways to fix it
- Images with oneCellAnchor do not distort! But images with twoCellAnchor do!
I haven't found any official MS office explanation for these, but you can read about it here on the openofficexml site:
- http://officeopenxml.com/drwPicInSpread-twoCell.php
- http://officeopenxml.com/drwPicInSpread-oneCell.php
This has been proven to work. Take a picture that was distorting on print, edit its anchor from twocell to onecell, put a new drawing1.xml into the xlsx file and reopen it and the picture will no longer distort!
- Changing the fonts will stop pictures from distorting
Source: Excel will not print images at correct height/width!! @ ExcelForum
For me I haven't found Metro but Corbel or manually choosing Segoe UI in there worked. But for some reason, changing all cells to Segoe UI didnt! Only setting it in the fonts menu (and I could change back to Calibri everywhere and it still worked)
AND IT KEEPS THEM TWO CELL ANCHORED!
I think we're really close to solving this once and for all. So I'm asking for help. Maybe someone has also experimented with this or knows Excel in and out better than me.
Questions left to asnwer:
- What does setting font in the "page layout" actually change? What changes if font is set as "Segoe UI" but every cell font is still Calibri?
- How can you make Excel anchor pictures with oneCellAnchor? It seems changing a single picture property (like "lock aspect") immediately transforms it to twoCellAnchor and it starts distorting again?
