Friday, July 27, 2007

How to print a logo in an Excel header

Excel isn’t a word processor, not does it generate reports the way Access does, but that doesn’t mean you can’t improvise. For instance, you can display a graphic, such as a company logo, at the top of each printed page. This is a task you’d expect Word and Access to handle, but maybe not Excel. The following is an Excel sheet in Print Preview. Excel will print the RabbitTracks logo at the top of each page, as a header. You can do the same thing with a footer.

To add a picture to the header (or footer) in Excel 2002 or later, complete the following steps:

1. Choose Page Setup from the File menu. (In Excel 2007, choose Print Titles from the Page Layout group.)
2. Select the Header/Footer tab.
3. Click Custom Header.
4. Click inside the Left section (or the most appropriate section for your needs).
5. Click the Picture icon (the second icon from the right).
6. Use the Insert Picture dialog box to find the graphic file you want to insert.
7. If necessary, click Format Picture to format the picture.
8. Click OK.

If you’re using version 2000 or earlier, follow these steps:

1. Select cell A1.
2. Choose Picture from the Insert menu and then select From File.
3. Find the graphic file and click Insert.
4. Adjust the picture’s size if necessary.
5. Choose Page Setup from the File menu, and click the Sheet tab.
6. Select the Rows to Repeat At Top option, and select row 1.
7. Click OK.

No comments: