Going To The Edge

Going To The Edge

Are you an Excel user who often works with huge ranges of data?

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 just annoying.

Want a quicker way to get to the edge?

(The “edge” being the edge of the data range of course. That is a set of cells that contain continuous data—an empty row or column 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 in the data range and double click.

If you double click on the right side of a cell then the cell selector will move to the right edge of the data range.

And, if you double click on the bottom edge of a cell then 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 side too!

Now I would like to add that this one does take some practice, after all, think about it—the right side of one cell is the left side of the one next to it!

I found that Excel tended to move in the direction my mouse pointer came from.

For example, if I moved the mouse from left to right towards the right border then it took the double click as being on a right border and moved to the right edge of the data.

The same was true if I moved the mouse pointer downward and then double clicked on a bottom cell border—the cell selector immediately jumped to the bottom of the data range.

Give it a try—with just a double click you too can be at the edge.

~ April

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.