A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
I’ve been on a real rollover kick lately. I’m really trying to figure out if it can be useful. Earlier today I started making a Periodic Table of Elements using Excel. I employed the rollover technique to allow the user to gain information about an element simply by rolling over a cell. Well, for some reason, I couldn’t stop there. So what was meant to be a small project ballooned into something larger. Unfortunately, my sticking to good coding practice didn’t keep up with craving to do more. So what I present to you below isn’t really a polished product. If you poke through the named ranges and the rollover indexes, you’ll probably see that I add and subtract one to them somewhat randomly (a cheap trick – this is due to my trying to reconcile the table copied from Wikipedia with my indices).
As you can see below (sorry for the graininess of the recorder–be sure to download it to get the full effect), you can not only gain information about an element but you can also toggle on and off different element groupings.
If you want to “crack” the file, the first thing you’ll need to do is reset the ScrollArea (Click on a cell. Go to the Developer tab, click Properties. Delete the reference in the ScrollArea box.). Then just unhide everything.
Reader Dario found an error in the spreadsheet (see the comments) – this is the result of some carelessness and cheap tricks on my part. An updated version will be released tonight. In the meantime however, you can still poke around the file :).
Another Update –
I’ve since fixed the bug described in the reader comments. If you find anything else, let me know!
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide