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’
2.Delete all the text in comment box.
3.Move the mouse at outer comment box and right click,select ‘Format comment’,
4.Choose ‘colors and lines’ tab,click Fill color to show drop down list -> fill Effects,
5.Click Picture tab -> select Picture option to determine what kind picture showed.
Now a pop up picture showed as mouse move over the item.
Easy ?
WOW!! Thanks for sharing this! ;)
What a nice trick you have found!
Thumbs up!
I never thought of that. Thanks for sharing!
No Thank