Excel Superhero : Aspect Ratio of Images - Does not lock on print : Solution possible? (2016 / 2013)

[utilichoice]

I've looked through different posts but do not see a solution to this question that seems to have plagued Excel since day 1.

All I would like to do is insert an image (our logo... simple jpeg... see images below) into a spreadsheet. I do and it looks great. I lock the aspect ratio.

Then when I print, I have to choose "Fit All Columns on One Page" for the sheet to print nicely. This however, understandably... since it is reproportioning the column widths and not the row heights, squeezes or expands the jpeg image accordingly, as all print is affected by the resizing to nicely fit all the columns on one page.

What I am hoping exists is some sort of "mystery feature" that somehow lets the jpeg image "float" above the page, albeit anchored--if necessary--to a cell, so that it simply gets repositioned relative to the page (or some other coordinates) when the "Fit All Columns on One Page" is used, and thus prints at its natural aspect ratio.

This issue makes it difficult to brand spreadsheet products. ...but I have to believe that in all the years Excel has been around, that someone somewhere, if not Microsoft itself, has developed a solution. Even if it requires vbscript or form/activeX controls, that's fine. Just need that logo to remain intact independent of the resizing of the sheet on printout.

If you can solve this issue once and for all, I'd be so grateful (and I'm sure many other would be as well!)

Thanks for reading!

Mark at UtiliChoice


On the screen...

On the print/print preview...

 

[CalcSux78]

Have you looked into adding a background image to the worksheet(s) to give a visual logo on the worksheet? (the background image wouldn't print, but you could add a cropped version w/ proper ratios as a header/footer image)

 

[utilichoice]

Have you looked into adding a background image to the worksheet(s) to give a visual logo on the worksheet? (the background image wouldn't print, but you could add a cropped version w/ proper ratios as a header/footer image)

Those are clever ideas, though they wouldn't work for us:

• Background images don't print or export to PDFs, both of which we need.
• Putting the logo in the header does not work because the header also stretches with the sheet when printing.

Still though, this is the kind of thinking that's gonna solve this! Thanks for replying. I'm sure there must be a solution.