How to create a pop up image in Excel


If you have a need to create a pop image when ‘mousing’ over a cell in Excel this method should work.

  • Create a comment box by inserting a comment (Review-New Comment)


  • Right Click on the format box border and select Format Comment

Note: you must click on the BORDER not the main box when right clicking


  • Click on Colors & Lines


  • Click on the Fill dropdown and drop down to Fill Effects


  • Click on Picture
  • Click on Select Picture


  • Select your picture and optionally click ‘lock aspect ratio’
  • Click OK


  • Resize your comment box to the required width and height

Voila! You now have a pop up comment box that contains an image





Taff Lovesey

About taffybach

Author of the young adult fantasy novel series, The Portal Chronicles, including The Spider Gem and The Shimmering Gate. When not writing and promoting Taff runs a small IT support company, LITES PC based in Bourne UK.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s