HOW TO: Insert a Picture into the Header or the Footer in Excel 2003 (826918)

SUMMARY

This article describes how to insert a picture into the header or the footer of an Excel 2003 worksheet.

back to the top

How to Insert a Picture in the Header or the Footer

In Excel 2003, a new permits you to insert pictures into the header or the footer areas of a worksheet.

To insert a picture into the header or the footer of a worksheet, follow these steps:

1. Start Excel 2003.
2. On the View menu, click Head and Footer.
3. Click Custom Header or Custom Footer (depending on where you want to add the picture).
4. Click anywhere in the Left section box, the Center section box, or the Right section box.
5. On the row of buttons in the Header or the Footer dialog boxes, click Insert Picture, and then find the graphic that you want to insert.
6. Double-click the graphic.
7. Click OK two times.

back to the top

How to Improve the Appearance of a Worksheet That Contains a Picture in the Header or in the Footer

Use one of the following methods to improve the appearance of the worksheet and to make sure that all the data is displayed:

• Increase the header margin by dragging the margin indicators that appear on the screen.
  
  -or-
• Change the size of the picture.

back to the top

How to Change the Size of the Picture

To change the size of the picture, follow these steps:

1. On the View menu, click Head and Footer.
2. Click Custom Header or Custom Footer.
3. Click any where in the &(Picture) text.
4. Click the Format Picture button.
5. Click to clear the Height check box, and then type .5 in the Height box.
   
   Because both the Lock aspect ratio and the Relative to original picture size check boxes are selected, the width changes in proportion to the change that you make in the Height box.
6. Click OK three times.

Note If you decide to move the picture to another section of the header or the footer after you have positioned and formatted it, you can copy and paste the code &[Picture], but you must select the picture again and reformat it if you do so.

back to the top