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.
A data range is a set of cells that contain continuous data. The range is at an end when an empty row or column breaks the current 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 selected cell in the data range (it will become a four way arrow) 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
