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)

image

  • 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

image

  • Click on Colors & Lines

image

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

image

  • Click on Picture
  • Click on Select Picture

image

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

image

  • Resize your comment box to the required width and height

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

 

image

 

Rgds

Taff Lovesey
www.litespc.co.uk
www.weblites.co.uk
www.lovesey.net

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s