Forum Discussion
Images in Headers not working and causing issues printing
Matt_MobiusNZ Indeed frustrating when things don't function as you expect them to. But, allow me to add one more comment. In your screenshot you show the Insert ribbon while inside the header. Don't you have a separate "Header & Footer" ribbon when you click inside the header? See picture below. I have all the header and footer options here, including inserting pictures and reformatting them once inserted.
This is my Excel version, running W10 on a virtual machine on a MB Pro.
Matt_MobiusNZ Indeed frustrating when things don't function as you expect them to. But, allow me to add one more comment. In your screenshot you show the Insert ribbon while inside the header. Don't you have a separate "Header & Footer" ribbon when you click inside the header? See picture below. I have all the header and footer options here, including inserting pictures and reformatting them once inserted.
This is my Excel version, running W10 on a virtual machine on a MB Pro.
Thanks Riny - Thats good info - I'd completely missed that and the answer is Sort of 🙂
Looks like microsoft Rapid development is at it again. You are dead right, by default when in Layout view and sitting in the Header it takes me to a new ribbon - Although mine is called "Design" not "Header and Footer" like yours but the content looks the same so Microsoft must be dabbling and finalising what they are doing. That ribbon does make it much easier to add the pictures and does work but its still a terrible far from WYSIWYG as you can't resize the image once its inserted. Interestingly even when I insert a massively oversized image that ends up being a background for the entire sheet rather than sitting in the header the file will print for me.
Now I need to work out if something has become corrupted in his sheet or if Microsoft have pushed some rapid development fixes out overnight because yesterday Mine wouldn't print with a Brand new sheet with an image inserted in the header.
It was just tricky as every search I did lead to documents referring to the wrong instructions for older versions of Excel and I found one reference that seemed to indicate images weren't supported in Headers which seemed to fit with the inability to insert using the insert tab. No idea why MS Dev's decided that the logical way to insert a picture in a header isn't the right way.