XL2000: Unable to Insert Image/Picture into Header or Footer (268071)


The information in this article applies to:

  • Microsoft Excel 2000
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.
  5. On the Edit menu, click Go To.
  6. In the Reference box, type A1:C100 and click OK.
  7. Type my test and press CONTROL+ENTER. This will populate the range A1:C100 with the string my test.

  8. Clear the text in cells A1:C1, leaving only the pasted image in cell A1.
  9. On the File menu, click Page Setup, and then click the Sheet tab.
  10. In the Rows to repeat at top box, type 1:1. Click OK.
  11. On the File menu, click Print Preview.
  12. 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

REFERENCES

For more information about custom headers or footers, click Microsoft Excel Help on the Help menu, type create custom footers in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbprb KB268071
©2003 Microsoft Corporation. All rights reserved.