Microsoft KB Archive/268071

= XL2000: Unable to Insert Image/Picture into Header or Footer =

Article ID: 268071

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q268071



SYMPTOMS
When you create a custom header or footer in Microsoft Excel, you are not able to insert the following items into the custom header or footer:
 * Image or graphic
 * Cell reference
 * Formula



CAUSE
Microsoft Excel does not provide these capabilities for custom headers or footers.



WORKAROUND
To work around this limitation, use print titles if you want to repeat cell contents or a graphic on every printed page. For example, to have the same graphic appear at the top of every page, follow these steps:
 * 1) Save and close all open workbooks and then open a new workbook.
 * 2) On the Tools menu, click Customize.
 * 3) Right-click any toolbar button, and then click Copy Button Image. Click Close.
 * 4) On the Edit menu, click Paste.

This will paste the button image into cell A1.
 * 1) On the Edit menu, click Go To.
 * 2) In the Reference box, type A1:C100 and click OK.
 * 3) Type my test and press CONTROL+ENTER. This will populate the range A1:C100 with the string my test.


 * 1) Clear the text in cells A1:C1, leaving only the pasted image in cell A1.
 * 2) On the File menu, click Page Setup, and then click the Sheet tab.
 * 3) In the Rows to repeat at top box, type 1:1 . Click OK.
 * 4) On the File menu, click Print Preview.
 * 5) Click Next. The image in cell A1 will be repeated at the top of the page.



MORE INFORMATION
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

213618 XL2000: Inserting and Formatting Text in Headers and Footers

213742 XL2000: Macro to Change the Date/Time Format in a Header/Footer

213615 XL2000: How to Add the Workbook Path to the Footer

