Going to the Edge
Are you an Excel user who often works with huge ranges of data?
It’s sort of annoying when you’re trying to move from one end of the range to the other, isn’t it?
You can scroll for what feels like an eternity (and then probably pass the end of the data up anyway) or hit the Page Up / Down key about a million times. But no matter what, it’s so frustrating
Want a quicker way to get to the edge?
First of all, the “edge” is the edge of the data range, of course. That is a set of cells that contain continuous data, whether it be an empty row or a column that breaks the data range into a new one.
In a quick click, click, you can get Excel to move the cell selector to any of the four edges of the data range.
To move to an edge, simply move your mouse pointer to the edge of a cell (it will become a four way arrow) in the data range and double click.
If you double click on the right side of a cell, the cell selector will move to the right edge of the data range.
Also, if you double click on the bottom edge of a cell, the cell selector will move to the bottom of the data range.
I’m sure you get the idea. It works for the top and left sides too.
Give it a try. With just a double click, you too can be at the edge!
~ April