Software

Print a graphic in an Excel header - sort of

Excel doesn't support graphics in the header/footer section, but don't let that stop you. Use Excel's Print Titles feature to create a pseudo header.

Word lets you insert a graphic into a document's header or footer. Excel's not so flexible, but you can cheat. Insert the graphic and specify it using the Print Titles feature. Excel will print the graphic at the top of each printed page, which is really what you want — header or not.

The first step is to get the graphic into the workbook. Try to insert it into cell A1 and then adjust the cell's height to accommodate it, but that might not work. Depending on the size of the graphic, Excel might insert it as is, usurping several rows and columns. To insert a graphic, choose Picture from the Insert menu, select From File, locate the file, and then click Insert. In Excel 2007, click Picture in the Illustrations group on the Insert tab.

september2008blog9fig1r.jpg

The next step is to identify the graphic using the Titles feature as follows:

  1. Choose Page Setup from the File menu and click the Sheet tab. In Excel 2007, the Page Setup group is on the Page Layout tab.
  2. Click the row or drag across the rows that contain the graphic. Or enter the rows in the Rows To Repeat At Top control. For instance, the RabbitTracks graphic (above) covers rows 1, 2, and 3. Therefore, you'd enter $1:$3. When you finish, click OK.

september2008blog9fig2r.jpg

    Click Print Preview to view the graphic on all pages of the worksheet. You can't really tell, but the following picture shows the second page of a long sheet, and each page displays the same graphic at the top.

    september2008blog9fig3r.jpg

    About Susan Harkins

    Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

    Editor's Picks

    Free Newsletters, In your Inbox