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.
#3 right click the border of the comment, and choose Format Comment… from the popup menu list. And the Format Comment dialog will open.
#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.
#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.
#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.