How to Insert a Picture in Excel Comment

Watch Video – Insert Picture in Excel Comment

In some cases, you may want to insert a picture in Excel comment boxes.

For example, if you have a list of products, then inserting product images in the comment box could make your Excel sheet easy to use.

As soon as the user would hover the mouse over a cell that has a comment, it would show the comment and the picture within it.

I used this trick when I had a list of countries and I wanted to insert flag image for each country in the cell comment.

Something as shown below:

It’s such a simple trick; yet impresses big time!!

Insert a Picture in Excel Comment

Here are the steps to insert a picture in Excel Comment:

• In the worksheet, select the cell in which you want to insert the comment.
• Right click on the cell and select Insert Comment. This will insert a comment in the cell.
  • You can also use the keyboard shortcut – Shift + F2.
• (Optional Step) Delete the default username from the comment. If you don’t delete the existing text in the comment, it will display the text over the picture.
• Hover the cursor on the edges of the comment. You would notice that the cursor turns into a four arrow icon. Right-click and click on the ‘Format Comment…’ option.
  • This will open the Format Comment dialogue box.
• In the format comment dialogue box, select the ‘Color and Lines’ tab.
• In the Color Drop down menu select ‘Fill Effects’.
• In ‘Fill Effects’ dialogue box, select ‘Picture’ tab and click on ‘Select Picture’ button below the Picture box.
• Browse and select the picture you want in the comment.
• Click OK.

Now when you hover over the cell, the picture would be displayed in your comment.

Amazing, isn’t it!!!

Note: This technique involves a bit of manual work. You need to follow the above steps for each cell where you want to insert a picture in the comment.

You May Also Like the Following Excel Tutorials:

• How to Print Comments in Excel.
• Get a List of All the Comments in a Worksheet in Excel.
• Insert Picture in an Excel cell.
• Insert Watermark in Excel Worksheets.