Article ID: 288966 - View products that this article applies to.
This article was previously published under Q288966
When you insert an image in the header or the footer in a Microsoft Excel worksheet, the image may overlap into the data area of the worksheet.
This issue occurs because the image is not automatically resized to fit inside the header or footer section when you place an image in a header or a footer. Additionally, the image is not resized when header or footer margins are subsequently changed.
To resolve this issue, resize the image that you place in a header or a footer to fit inside the area of the header or footer section.
To do this, follow these steps, as appropriate for the version of Excel that you are running.
Microsoft Office Excel 2007
Microsoft Office Excel 2003 and earlier versions of Excel
You need to match the sizes of images that you place in worksheet headers or footers to the size of the header or footer area if the images are to be displayed properly and not obscure data in the body of the worksheet. You can do this either by adjusting the size of the header or footer area or resizing the image after you have placed it in that area.
When you put graphics in a header or footer, it is important to keep in mind the way in which the size of the header area is related to the dimensions of the Top Margin and the Header Margin, and the corresponding relationships for the Bottom Margin and the Footer Margin. At the top of the page, the actual amount of space available for text and graphics in the top margin is the difference between the Top Margin and Header Margin dimensions; the bottom margin behaves similarly.
To adjust the header area or the footer area to a specific size, follow these steps, as appropriate for the version of Excel that you are running.
Excel 2003 and earlier versions of Excel
For more information about how to put images in headers or in footers, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/288964/ )How to insert a picture into the header or footer in Excel 2002
(http://support.microsoft.com/kb/826918/ )How to insert a picture into the header or footer in Excel 2003
Contact us for more help
Connect with Answer Desk for expert help.