Rollovers Archives - Excel TV
Excel TV
Share The LOVE

Category Archives for Rollovers

Handling Excel Rollover Popups

Various people have written to me asking what they should do about popups generated by the rollover method that don’t go away on their own. Essentially, the rollover method provides for an “on mouse over” style routine but not for a “on mouse out.” The “moat” method One method to address this is to create […]

Continue reading

Two Great Applications of Rollovers

I want to highlight two applications of the rollover technique that are really quite phenomenal. Square Charts and Treemaps in Excel If you haven’t seen the work of the Frankens Team yet – you’re missing out. They’re a group of…geniuses, really…who investigate and push Excel’s limit. Very recently, they wrote on the development of square […]

Continue reading

CUBE: The Rollover Method Returns! Spin a cube in a 3d environment with your mouse!

Ok, so I know I promised no more updates, but this one is too cool. Basically, I combined Andy Pope’s 3d rotation tutorial with the rollover method. The result is a free-floating cube which you can rotate by passing your mouse over it. Here’s a choppy-ish video of what’s going on. I promise however that it […]

Continue reading

Interactive United States 2012 Presidential Scoreboard in Excel

Alright, here’s another map-based rollover. The instructions are pretty simple: click on a state to toggle through its party selection. Click on one of the three selections above to change scenarios. In the next month or so, I’ll be putting together a tutorial on this. But in the meantime, have some fun. Download. Ask questions […]

Continue reading

Handling Rollover Clicks Without Using the Worksheet_SelectionChange Event

You probably noticed a “bug” while playing around with my Interactive Periodic Table of Elements in Excel. When you click down into the Table of Elements (or really, anywhere on the sheet), one of the chemical classifications will become “selected,” despite your not having clicked on it directly. This happens because I’ve used the ScrollArea […]

Continue reading

Investigations in "Illegal Activities" with User Defined Functions

A group of fellow Excel experts who call themselves the Frankens Team were encouraged by the rollover method to investigate other known instances in which Excel has allowed for the impossible; namely, allowing UDFs to change the value of other cells. I invite everyone to view their terrific analysis: Excel formula to change the value of […]

Continue reading

Investigations in "Illegal Activities" with User Defined Functions

A group of fellow Excel experts who call themselves the Frankens Team were encouraged by the rollover method to investigate other known instances in which Excel has allowed for the impossible; namely, allowing UDFs to change the value of other cells. I invite everyone to view their terrific analysis: Excel formula to change the value of […]

Continue reading

The Excel Rollover Mini FAQ

As more people are use the rollover method (or “Interactive Hyperlinks” as Chandoo calls them), I thought it might be helpful to answer common questions I’ve seen popping up on forums. So, in no particular order, I present the Excel Rollover Mini FAQ! 1. Are there example articles and spreadsheets on how to use Excel […]

Continue reading

Interactive Map in Excel using Rollovers

Alright, so this seemed like the next logical step for the rollover method: This one is kinda complicated, I admit. Unfortunately, I didn’t really take the time to clean up the spreadsheet file for others to follow (I don’t really have the time these days). Sorry. But try to take it apart – and ask […]

Continue reading

Details on Demand: Bring up details on a graph with Excel rollovers

So, as usual, I’ve been experimenting more with the rollover technique. Last night, I started experimenting with adding the capability to rollover a point on a chart (instead of just a worksheet cell) to see if I could have a label appear – or just some event fire – upon the mouse entering a chart’s datapoint’s […]

Continue reading

Guest Post: Rollover for Months and Years

Reader Bert van Zandbergen sent me a cool modification to the instruction file in How to: highlighting cells using the rollover technique in Excel to include years and months – not just rows and columns. He writes: I am an enthousiast reader of the blog ‘Option Explicit’. I changed the formula (see below) and made a version for […]

Continue reading

Needs More Rollover: Quick Tip!

More people are interested in Excel mouse rollovers, which I think is great. I’m especially enthusiastic about Chandoo’s latest dashboard contest where I found out that several contestants used the technique! By the way, there are many great dashboards showcased in the contest. Take a look and make sure to vote! So here’s the tip. If […]

Continue reading

Interactive Periodic Table of Elements in Excel

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, […]

Continue reading

How to: highlighting cells using the rollover technique in Excel

In my last post I used my patented rollover technique to create an effect similar to the one shown below: Neat, huh? When you place your mouse over a cell, it changes color to show that you are selecting it. It’s a true “rollover”: no mouse-clicks required. In my last post, I show how that might […]

Continue reading

Rollovers for Gantt Charts

Before we start, you might have noticed some renovations on this blog. Yeah, it was time for a change. I’m working this template out, so sorry if some of the formats seem off. Also, I have started a new facebook page. I’ll be keeping it updated with stories from my favorite blogs. Also, you can […]

Continue reading
>