Tip #3153 - Going to the Edge
Printer Friendly Version | E-Mail This Tip
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
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail
