Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Going to the Edge

Monday, April 6th, 2009 by | Filed Under: MS Excel, MS Office Help
 
Loading...


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

Leave a Reply


Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Going to the Edge

Friday, November 17th, 2006 by | Filed Under: MS Excel, MS Office Help
 
Loading...


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

Leave a Reply


Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Going To The Edge

Tuesday, November 16th, 2004 by | Filed Under: MS Excel
 
Loading...


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


Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: