How to show image on mouseover in Excel?
In some cases, you may want to insert an image that only shows when the mouse is over it in Excel, and here I will tell you how to make such a pop-up picture in Excel.
In Excel, if you want to insert a pop-up picture, you need the aid of a comment.
1. Select a cell that you want to place the image at, and then right click to select Insert Comment from the context menu. See screenshot:
2. Then a comment is inserted in the cell, and place the pointer at the border of the comment until the pointer change to a cross with arrows. And then right click to select Format Comment from the context menu. See screenshot:
3. In the Format Comment dialog, click Colors and Lines tab, and then click the down-arrow from Color, and select Fill Effects. See screenshot:
4. Click Picture tab and then click Select Picture to select a picture you need, then click Insert. See screenshots:
Note: In Excel 2013, after clicking the SelectPicture button in the Fill effects dialog, specify the From a file option, and then select a picture and click the Insert button.
5. Click OK > OK to close dialogs. Then you will see the picture is inserted in the comment. See screenshot:
6. Then you can click the comment, and delete the user name, and then a pop-up picture has made. See screenshot:
Tip: You need to make sure the Show All Comments is not active on the Review tab.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!