Excel displays either the Header or Footer dialog box.

Click on the Custom Header or Custom Footer button, depending on which one you want to change.

The Header/Footer tab of the Page Setup dialog box.

Make sure the Header/Footer tab is selected.

Excel displays the Page Setup dialog box. In fact, Microsoft added a direct capability to place graphics in headers or footers. Users of Excel 2002 and Excel 2003 may be glad to know that it is even easier to add graphics to headers or footers. Various methods have been devised to do just that, as discussed in other ExcelTips.

excelTemplateWithStaticHeaderAndFooter.Excel users have, for years, asked if there is a way to place graphics in headers or footers.

Similar to the Header you can add text/images to the Excel sheet.Īfter this you can save this Excel template and if you added your Export fields to the Excel body that will be nicely generate the desired export with your custom images & text in the Excel header and footer.

After adding the image an image placeholder will appear here which is replaced with the real image if you leave the Header by clicking on the Excel Sheets' body.

To add an image in the Header & Footer Tools menu on Design tab to find the Picture button.

Double click on the Header to start editing it, add any text you may need here.

This adds Header & Footer to your Excel document

Start with a new or existing Excel template and click on Insert menu and there click on Header & Footer submenu.

It is possible to generate Excel exports with some static images or text in the Excel's headers. How to add headers/footers with images to Excel exports

Excel add image to header