Sometimes, just when you think there are no more surprises, Excel provides something which you only thought could be done with lots of VBA work. That’s the case with pictures that pop-up when you hover over a cell in your spreadsheet. It isn’t something that you would immediately think Excel could do, but if you know a trick or two, anything is possible. Of course, if you know VBA then anything is possible, plus one but if you don’t have the time or the heart to learn it, this is a quick and dirty way to create pop-up pictures.
This video
provides you with the instructions that you need and is a step-by-step guide to
creating pop-up pictures in a cell. The
scenario here is that you have a list of members of a leisure club. You have their names in a neat spreadsheet
but putting pictures in the cell to the left or right of their name will
probably mean that the data gets overwhelmed by the visuals. The height of the cells increases, and you
can’t see that many of your members on the screen anymore unless you scroll
down. This lets you have the best of
both worlds – your members stay in rows with normal height but when you hover
over the name of a member, you get their picture popping up. The great thing is that it’s easy to accomplish
but looks a lot like magic..!
This video was made with students who are doing the BTEC Level 2 Extended Certificate in ICT in mind, specifically Unit 9 – Spreadsheet Development. Once a spreadsheet is created students have to come up with a number of ways to enhance it – and it can be quite difficult trying to refine a spreadsheet when everything already seems to be working perfectly. That means adding functionality and what better way to impress your tutor by refining your spreadsheet with some pop-up pictures. You wouldn’t have to do every single member in your spreadsheet – just enough to demonstrate that you know how to do it. This feature could cover
Depending
on how you use this feature in your assignment, this could cover part of M3 – refine
the spreadsheet to improve usability or even part of D3 – refine the
spreadsheet using automated tools.
Either way, using pop-up images will improve the usability of your
spreadsheet massively. Take a look at
the video, adapt the method to suit your own spreadsheet assignment – and see
where this takes you!
Of course,
if you are not a student this feature may well just impress your boss at
work!
Give a Gift
If you enjoyed this article, please consider making a gift to help Kuriositas to continue to bring you fascinating features, photographs and videos.
Thank you!