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.
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.
Related Topics:Enterprise Software Developer Open Source Software Mobility Cloud
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.