February 5, 2009

Print a graphic in an Excel header — sort of

Date: September 26th, 2008
Author: Susan Harkins

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 cialis c10 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.

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

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.
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.

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.