Skip to main content

How to show image on mouseover in Excel?

Author: Sun Last Modified: 2014-08-07

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.

Insert a pop-up picture by using comment


arrow blue right bubble Insert a pop-up picture by using comment

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:

doc-pop-up-image-1

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:

doc-pop-up-image-2

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:

doc-pop-up-image-3

4. Click Picture tab and then click Select Picture to select a picture you need, then click Insert. See screenshots:

doc-pop-up-image-4

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:

doc-pop-up-image-5

6. Then you can click the comment, and delete the user name, and then a pop-up picture has made. See screenshot:
doc-pop-up-image-6

Tip: You need to make sure the Show All Comments is not active on the Review tab.

doc-pop-up-image-7

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

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...

Description


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!
Comments (20)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
tại sao khi gửi qua mail thì người nhận không còn tác dụng Hiển Thị Hình Ảnh Khi Di Chuột?
ai biết cách gửi qua mail mà vẫn hoạt động bình thường không?
xin cảm ơn
This comment was minimized by the moderator on the site
Great tip - thanks for this! I was wondering how to place pictures in Excel which only appear when you need them - for instance, in a catalogue of parts.
This comment was minimized by the moderator on the site
I added the comment/picture in a cell above freeze panel. and when I scroll down on the page, the display (the Comment/picture) got covered up, how can I make the comment/picture shows at all times?
This comment was minimized by the moderator on the site
I have tried to right click on the boarder, but the only options that appear are grouping and arrange. Is there another way? I have Excel 2016
This comment was minimized by the moderator on the site
I have the same problem. Can't get the format comments menu. Just get grouping and arrange. Tried click g everywhere. I have a 2017 excel for mac.
This comment was minimized by the moderator on the site
There's a discussion here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/change-excel-cell-comment-line-color/3b3bf219-a778-4d45-a982-34c8fc3eb933 where an MS person replies like so: Unlike Excel 2011 for Mac or Excel 2016 for Windows, there is no option to change the background color of comment box in Excel 2016 for Mac.
This comment was minimized by the moderator on the site
In case you never found a solution, still works in Excel 2016 for windows but you need to right click on the border of the comment, not the interior!
This comment was minimized by the moderator on the site
Worked for me, thanks!
This comment was minimized by the moderator on the site
Can this be done in excel 2010?
This comment was minimized by the moderator on the site
I was successful the first time i tried but then for the cell directly beneath MS Excel would stop working and close automatically. Any ideas what's going on? Thanks!
This comment was minimized by the moderator on the site
Great solution. It would have taken me a month of Sundays to figure that out. It worked perfect for my eBay selling spreadsheet, as I can now see a picture of the sold item when I hover over the name. Thanks!
This comment was minimized by the moderator on the site
Is there a way to do this with less steps, like a Macro? I would like to create a template where it is easy and quick to add photos to a comment like this. Does anyone know if this is possible?
This comment was minimized by the moderator on the site
@JASON:Go fuck Your self
This comment was minimized by the moderator on the site
[quote]@JASON:Go fuck Your selfBy Not A Nice Guy[/quote] I had a wee chuckle, lol :D
This comment was minimized by the moderator on the site
When I click on the format comments - I don't get the same screen shown above. It only gives me a font option - I don't get all of the other options. I am using Excel 2013 is there something you have to do to enable the full options for the format comments?
This comment was minimized by the moderator on the site
This is problem I got as well :(
This comment was minimized by the moderator on the site
@Tonja, have you the comment selected (blinking I inside comment) or the box of the commend? You should not see the blinking I inside the comment box.
This comment was minimized by the moderator on the site
Tonja, you need to select the outside edge of the comment box, if you are in 'text edit mode' then it will show text format options.
This comment was minimized by the moderator on the site
THANK YOU! I was having this same issue and did not realize the difference that this makes. Awesome. Works like a charm now.
This comment was minimized by the moderator on the site
Nice solution! Can I do something similiar in Google Sheets?
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations