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.