Putting a Graphic in a Header or Footer

Excel users have, for years, asked if there is a way to place graphics in headers or footers. Various methods have been devised to do just that, as discussed in other ExcelTips. Users of Excel 2002 and Excel 2003 may be glad to know that it is even easier to add graphics to headers or footers. In fact, Microsoft added a direct capability to place graphics in headers or footers. Just follow these steps:

1. Choose Page Setup from the File menu. Excel displays the Page Setup dialog box.
2. Make sure the Header/Footer tab is selected. (Click here to see a related figure.)
3. Click on the Custom Header or Custom Footer button, depending on which one you want to change. Excel displays either the Header or Footer dialog box. (Click here to see a related figure.)
4. Select the section of the header or footer (left, center, or right) in which you want your graphic to appear.
5. Click on the Insert Picture button. It is the second button from the right. Excel displays the Insert Picture dialog box.
6. Use the controls in the dialog box to locate and select the graphic you want in the header or footer.
7. Click on Insert. Excel places the graphic at the designated spot in the header or footer, displaying the code &[Picture] where the graphic will appear.
8. Make other changes to the header or footer, as desired.
9. Click on the OK button to close the Header or Footer dialog box.
10. Click on OK to close the Page Setup dialog box.

Excel 2007 still allows you to place graphics in headers or footers; the only thing different is the steps by which you display the Header or Footer dialog box: Display the Insert tab of the ribbon and then click either Header or Footer within the Header & Footer group. At this point you can continue to actually locate and insert the graphic, as indicated earlier in steps 4 through 10.