This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I'm currently working on a spreadsheet, and I need three pictures in the header. However, I can't find how to do this in Excel 2016. Did Microsoft remove the option? Does anybody know how to do this?
It's funny because I opened a previous version created in Excel 2011, and it shows the picture and then Excel crashes.
Thank you in advance for your answers
William
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
The ability to insert images in the header and footer has now been solved by Microsoft in Excel version 15.36. And about time. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_officeinsider-mso_mac/excel-for-mac-insert-pictures-in-headers-footers/b5bc467a-7189-4bf6-be3d-c1a0c928249f
I can't get the above to work, using 2016 on Mac. No option to add picture. Version 15.35 no upgrade..
The issue is that Microsoft didn't quite get it right. In 2011 when you inserted a Graphic the image was placed in a layer on top of the spreadsheet. You could click on the image and custom resize. In 2016 bless their hearts, they did it wrong. Instead of putting in a layer on Top They insert the image as a layer behind the spreadsheet, and there is no way to click on the image and custom resize.
Here is the method for resizing you have to do this as soon as you insert the image.
In modern Mac's with "Retina Displays," the system now saves "Photos" in Raw format, and a real size image may end up being 80 inches by 60 inches. 4. Now click on the size and type in desired height and width and if you can measurement system change to mm or in (") as desired.
_________
Disclaimer:
The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.
In the latest update version 15.37 the problem with the images sizes in the Header/Footer being only in imperial has been fixed. Now in metric. However, images in the header/footer with respect to those in the normal body of the spreadsheet are considerably degraded in quality when printed to a printer or PDF. See example:
This is a screen shot of the spreadsheet, upper graphic in the Header, lower on in the body of the spreadsheet.
When printed to PDF
I have informed Microsoft via the usual button.