If you spend a lot of time in Excel and have ever tried printing images you’ve imported, you would probably notice that they come out squashed, distorted or stretched. This is a problem that has plagued me ever since my huge Excel projects of TPE and TRSG which contain hundreds of images between them.
After much searching through posts online I finally found a solution to the bug which Microsoft hasn’t ever bothered fixing. You have to go into ‘Page Layout’ > ‘Fonts’ and select the ‘Metro’ font.
This doesn’t actually change the font of the cells, but it does change the fonts used for the headers and footers of the Excel sheet.
I decided to dive deeper into other fonts that don’t alter the images because I hated the style of the ‘Metro’ font on my headers and footers. After a lot of testing I found 5 fonts in total which are the most accurate when printed. That’s not to say they are perfect, but they are off by such as small amount that you won’t be able to tell the difference.
To find the fonts which are least affected by this glitch I inserted a circle into my excel file swapping between the fonts and measuring the length and the width of it each time. This gives you the middle column below. This column shows the stretch of the shape and which direction it’s stretched in. If the width (first number) is bigger than the height, this font creates a horizontally stretched circle and if the height is bigger, this means the circle was stretched vertically.
Afterwards I subtracted the difference between the two number which gives me the ‘Offset’ number which signifies how warped the circle is as seen in the table below. The table below lists the different fonts in Excel 2010 and their offset. The lower the number on the end, the more perfect the shape. You could get away with a 1 or even 2 without people noticing the warping, but try to stay low.
These are the links which proved invaluable to me to figure out where to start to solve this problem:
Excel will not print images at correct height/width!! (Post by “Chinchilla”)
Images distorted when previewing or printing from Excel
|Font Name||Font Type||Width / Height||Offset|
|Office Classic 2||80×77||3|
|Angles||Franklin Gothic Book||71×71||0|
|Grid||Franklin Gothic Medium||71×71||0|
|Metro||Consolas – Corbel||80×80||0|
|Module||Corbel – Corbel||80×80||0|
|Pushpin||Constantia – Franklin Gothic Book||71×71||0|
|Trek||Franklin Gothic Book||71×71||0|