Insert a Picture into a Comment

0 Flares 0 Flares ×

Excel was created for the use of calculating and analysing huge amounts of data. Because of this it has never been great for storing large amounts of text or pictures. Inserting images into a cell would make the spreadsheet even larger and more awkward in its daily use.

Comments are fantastic for leaving notes for other users, but they can also be used to store pictures. These pictures can then be made visible when required rather than permanently displayed on screen within a cell.

Inserting a Picture into an Excel Comment

  1. Select the cell that you want to add the comment to.
  2. Click the Review tab on the Ribbon and then click New Comment.
  3. The comment appears with text displaying the username. This text will appear on top of the picture so let’s delete it.

Insert a new comment

  1. Right mouse click on the border of the comment to bring up a menu and select Format Comment.

Colors and Lines tab of the Format Comment dialog box

  1. Select the Colors and Lines tab on the dialog box. Click the Color list arrow and select Fill Effects.
  2. Select the Picture tab and then click the Select Picture button.

Picture tab of the Format Comment dialog box

  1. Locate and select the picture you want to use. Click Ok to both dialog boxes to save your changes and close them.
  2. The picture appears within the comment box. When you click away from the comment it will disappear.

Picture inside the inserted comment

To view your comments you can simply hover your mouse over the cell containing them. You can also use the Next and Previous buttons in the Comments group of the Review tab on the Ribbon to move through your comments, or click the Show All Comments button to display them all.

Watch the Video

9 thoughts on “Insert a Picture into a Comment

  1. I had been referred to your site through a friend, it has come to light that we cannot subscribe to your newsletter because our email address ([email protected]) fails the email validation, after investigating it appears this is caused by the hyphen in our domain name. Just thought you should be made aware.

  2. Very useful tip, thank you. We frequently create picture catalogs in Excel to send out to our buyers and could use this concept as well. Currently we’re using a nice add-in utility which we just recently bought that saves our company enormous amounts of time and helps us concentrate on the business rather than act as da Vinci of 21st century. It’s called Picture Manager for Excel and it automatically inserts product pictures (sized fit to cells). Check it out if you’d like, their site is

  3. It’s was a great help by your continuous info on your great video lesson. Looks like I’ll not miss your class! Easy to follow well presented.

Leave a Reply

Your email address will not be published. Required fields are marked *