Navigate between header and footer - footer is inactive

Hi,

i want to add a header and footer to different tabsheets in my excelsheet - so they are all similar.

On some tgabsheets i am unable to add a custom footer - the button to navigate to the footer is grey - I only can open the standard menu to add standard footers like page n of 1 - author etc - but I want to add a picture - and that is inactive in my meny..

Can somebody advise how I can solve this ?
I would be very grateful !

Kind regards
Sandra

Originally Posted by vlady

if you insert header or footer--there will be a "Design" tab in the main menu bar this will be used to insert pictures and other formatting for the header / footer.I think you are using the"Insert menu" that'swhy you said it is greyed out.

Hi

Thank you for you reply - I added a snapshot from my screen in attachment - I am indeed working in the design part menu - but you can see on my snapshot that the menu to go to the footer is grey-inactive ....I am wondering how i can set this active

Strange thing is that in one tabsheet this is active and in other one it isn't active ...

Kind regards
Sandra

I had this same problem. I noticed that the workbook had custom margins. I changed the margins back to standard and I was able to switch to the footer. After I made the changes that I needed to, I changed the margins back to the custom margins, which did make the footer inactive once again, but I made my changes.

Hope this helps,


Steve