Software

Print a logo in an Excel header


Excel isn’t a word processor, nor 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.

july20077fig1r.jpg

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. Adjust the picture’s size if necessary.
  4. Choose Page Setup from the File menu and click the Sheet tab.
  5. Select the Rows To Repeat At Top option and select row 1.
  6. Click OK.

About

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.

1 comments
cgruel
cgruel

Is there a way to remove both duplicates from two columns and keep the values that are unique to either column. A B 123 987 1234 123 12345 123456 123456 12345 1234567 1234 Results I am looking for: A B 1234567 987

Editor's Picks