Where Is The Header And Footer Tools Design Tab

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Header & Footer Tools (Design) not showing

Thread starter djossh
Start date Jul 8, 2018
Tags

design footer header showing tools

- On the Insert tab, in the Text group, click Header & Footer.
- Under Header, click either the left, center, or right header selection box.
- On the Design tab of the Header & Footer Tools, in the Header & Footer
elements group, click Picture and then find the picture that you want to
insert.
-Double-click the picture to insert it in the header section box.
- To resize or scale the picture, click Format Picture in the Header &
Footer elements group, and then, in the Format Picture dialog box, select the
options that you want on the Size tab.

This worked great, and I spent a bit of time resizing the image and the
margins, etc. I checked my work in print preview, and saw the image wasn't
quite right. When I went back to the Insert tab and clicked Header & Footer
in the Text group, it now only brings up the Page Setup dialog box, and not
the ribbon that includes the Design tab for the Header & Footer Tools that I
need to edit the size of the image. What happened to that ribbon and how can
I get it to reappear???

Last edited: Jul 8, 2018

Which lookup functions find a value equal or greater than the lookup value?

MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Your worksheet may have several pages, as far as the printer driver's concerned. If, before you went back to the "insert tab", you clicked into a cell on a different page of your spreadsheet than the one containing the header & footer in question, you may be looking at the menu for the header & footer in a different page to the one you're trying to access.

Try selecting a cell on the same page as the one who's header your photo's in - then select the insert tab etc.
Could just be the issue.

Last edited: Jul 8, 2018