Add A Background Image or Pictures To An Excel Worksheet.


Adding a background image to a worksheet or workbook can really spice up a presentation where graphs and charts, let face it, can get a little monotonous.  These background images will really set you apart the crowd when giving that presentation!!  Here is nuts and bolts of how to create a snazzy background image.

  1. Open the spreadsheet you want the image to appear in
  2. On the ribbon hit Page Layout
  3. Background
  4. Select background image from the Sheet Background window
  5. Hit Insert Button

You may need to change the colour of your font and any graphics to allow a contrast as in my example, I simply changed the font colour to white.

This background looks great for a powerful presentation, but if you then want to print out the spreadsheet with the background then you will need to insert the image in either the header or footer of you workbook.  This is really simple to do.

  1. Start Excel
  2. Insert Tab
  3. In text Group select Header and Footer
  4. Click the area of the header or footer you want to insert the picture
  5. In the Design Tab, Click Picture, in Header and Footer Tools, under the Header and Footer Elements Group
  6. Locate and select your picture you want to insert
  7. The Text &[Picture] will appear where the picture will be inserted.

That is it.  Go have a coffee while your colleagues swoon at the great professional and interesting presentation you have just created.

What do you think of these two methods?

Have you used them before?

Feel free to share your thoughts.

Other Excel Tip You Might Like

1. Change the colour of your worksheet tabs

2. Text wrapping in Excel

3. Centre a title across a worksheet


Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts