How to Show Image on Mouseover in Cell

This post will guide you how to add a pop-up picture to a cell when mouse hovers on this cell in Excel 2013/2016. How do I show image on mousehover in one cell in Excel.

Show Image on Mouseover in One Cell


If you want to add a pop-up picture to the cell, and when you hover the mouse over the cell, and the picture will appear. You can try to add a picture into the cell comment to achieve the result. Just do the following steps:

#1 select one cell that you want to insert comment to insert a picture. Such as: B1

#2 right click on it, and select Insert Comment from the popup menu list. And a comment box should be inserted in cell B1.

show image on mouseover in cell1

#3 right click the border of the comment, and choose Format Comment… from the popup menu list. And the Format Comment dialog will open.

show image on mouseover in cell2

#4 switch to the Colors and Lines tab in the Format comment dialog box, and open the Color drop down list and click Fill Effects from the drop down list. And the Fill Effects dialog will open.

show image on mouseover in cell3

#5 click the Picture tab in the Fill Effect dialog box, and click the Select Picture button to select one picture. It will show the picture preview in the comment. Click Ok button.

show image on mouseover in cell4

#6 click Ok button to close dialog.  And the picture has been inserted into the comment. When you hover over the cell, the picture will show up.

show image on mouseover in cell5

 

Comments

So empty here ... leave a comment!

Leave a Reply

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

Sidebar