- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Going to the Edge

Posted By On April 6, 2009 @ 12:48 PM In MS Excel,MS Office Help | Comments Disabled

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

Going to the Edge

Posted By On November 17, 2006 @ 2:33 PM In MS Excel,MS Office Help | No Comments

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

Going To The Edge

Posted By On November 16, 2004 @ 3:52 PM In MS Excel | No Comments

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


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/going-to-the-edge/