Pop Up Picture In Microsoft Excel,How To ?

Recently i try to make a product selling price list in Microsoft Excel format for my company.Due to many item at there and also most of the item name look like same,thinking that insert a picture as a reference for that product.

I don’t want make it in normal way by attached a picture below a item name,this will make so many Excel page and caused the file size bigger.I ever came across as mouse move over the item name,then it will pop up a picture,i want these kind of feature but i also known that Microsoft Excel don’t allow pop up picture feature.We only can use Insert Comment option to pop up text only.


But now we can hack this Insert comment option to have pop up picture feature in Excel as mouse move over the name.

 

Enable Pop Up Picture In Microsoft Excel

1.Click on item name and right click -> ‘Insert comment’

pop up picture in excel

 

2.Delete all the text in comment box.

pop up picture in excel

 

3.Move the mouse at outer comment box and right click,select ‘Format comment’,

pop up picture in excel

 

4.Choose ‘colors and lines’ tab,click Fill color to show drop down list -> fill Effects,

pop up picture in excel

 

5.Click Picture tab -> select Picture option to determine what kind picture showed.

pop up picture in excel

 

Now a pop up picture showed as mouse move over the item.

pop up picture in excel

Easy ?

Latest Comments
  1. Caroline September 16, 2011
  2. mrsgil September 17, 2011
  3. ahsiang September 18, 2011
    • TechGravy September 21, 2011