Picture in Comments box
Excel Tips and Tricks

Insert a picture in Excel Comments

In this article, you will learn how to insert a picture in comments. Here I have taken the example for my popular Dashboards which are freely available to download. I have created a table of Dashboards, Youtube tutorial link and Free download link as given in the below image.

Excel Table
Excel Table

I have added the comments for each dashboard and inserted the picture of the dashboard in comments. If you will hover the Dashboard title and it will display the Dashboard picture as given in below image-

Hover Dashboard Title to see the Image
Hover Dashboard Title to see the Image

Below are the steps to insert image in Excel Comments-

  • Select any cell, right click and click on Insert Comment or press Shift+F2 Shortcut Key
  • Right click on comment border and click on Format Comments
Format Comments option
Format Comments option

 

  • Format Comment window will be opened.
  • Go to Colors and Lines tab.
  • Go to Color drop-down and click on Fill effects.

 

Color and Lines
Color and Lines

 

  • Fill effects window will be opened.
  • Go to Picture Tab.
  • Click on Select Picture button.
Fill effects window
Fill effects window
  • Insert Pictures window will be opened.
  • Click on Form a file option.

It will ask to select the picture. That is how you can insert a picture in the comment box.

Click here to download the Practice file-

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com