Microsoft KB Archive/288971

= XL2002: How to Insert a Picture into the Header or Footer =

Q288971

-

The information in this article applies to:


 * Microsoft Excel 2002

-

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

MORE INFORMATION
Microsoft Excel 2002 supports greater customization of the header and footer areas of a worksheet than earlier versions of Excel.

You can create a custom header or footer with the Page Setup dialog box. To view the Page Setup dialog box, follow these steps:


 * 1) On the File menu, click Page Setup.
 * 2) In the Page Setup dialog box, click Header/Footer, and then click:


 * Custom Header if you want to create a custom header.

-or-
 * Custom Footer if you want to create a custom footer.

In the Header or Footer dialog box that appears, the following buttons are available to customize the Left section, Center section, or the Right section of the header or footer.
 * Font button. Used to change the font attributes of selected text.
 * Page Number button. Used to insert automatically updating page numbers.
 * Total Pages button. Used to insert an automatically updating page total.
 * Date button. Used to insert the current date.
 * Time button. Used to insert the current time.
 * Path & File button. Used to insert the path and file name of the active workbook.
 * File Name button. Used to insert the file name of the active workbook.
 * Sheet Name button. Used to insert the name of the active worksheet.
 * Insert Picture button. Used to insert a picture.
 * Format Picture button. Used to change the attributes of an inserted picture.

The following example illustrates how to customize the header of an Excel worksheet.


 * 1) Start Microsoft Excel.
 * 2) In cell A1 type 1, and then press ENTER.
 * 3) On the File menu, click Page Setup.
 * 4) In the Page Setup dialog box, on the Header/Footer tab, click Custom Header.
 * 5) In the Header dialog box, click the Insert Picture button.
 * 6) In the Insert Picture dialog box, browse to and select an existing image file, and then click the Insert button.
 * 7) In the Left section list, click &[Picture], and then click the Format Picture button.
 * 8) In the Format Picture dialog box, on the Size tab, in the Height list, select 50%, and then click OK.
 * 9) Place the cursor in the Center section, click the Time button, and then click the Date button.
 * 10) Place the cursor in the Right section, and then type My Header Text.
 * 11) Select My Header Text, and then click the Font button.
 * 12) In the Font dialog box, in the Size list, select 20, and then click OK.
 * 13) Click OK, and then click the Print Preview button.

The custom header appears at the top of the worksheet.