Excel - Fastest way to select large range (e.g. B3:F1002)?

Asked By nomail198 on 30-Aug-07 11:01 PM
What's the fastest way to select very large ranges, for example the 5-
by-1000 range B3:F1002?

I know I can select B3, scroll or page down to row 1002, and shift-
left-click on F1002.

Can I avoid moving the cursor to row 1002 by scrolling or paging down?

Although that might not be so bad for 1000 rows, it can be tedious
for, say, 60,000 rows.

If I try to "go to" (ctrl-G) F1002, it undoes the selection of A1.  So
shift-left-click on F1002 does not have the desired effectx.

Similarly if I enter F1002 in the name box in the upper-left corner of
the toolbar.

RobN replied on 30-Aug-07 11:19 PM
If you type the range B3:F1002 into the name box left of the Formula bar and
press enter, that range should then be highlighted.

Ron Coderre replied on 30-Aug-07 11:19 PM
Type B3:F1002 in the Name Box....Press [Enter]
[F5]...Type B3:F1002....Press [Enter]

Does that help?


Microsoft MVP (Excel)
nomail198 replied on 31-Aug-07 12:10 AM
On Aug 30, 8:19 pm, "Ron Coderre" <ronREMOVETHIScode...@bigfoot.com>

Yup!  Thanks RobN and Ron.  I discovered that myself; but verifying it
was tricky because paging down seems to deselect the range.  The way I
could get to the end (lower-right) of the selected range was to scroll
down and right.

(Of course, I might have selected a smaller range; less scrolling to

That's okay.  But I'm curious:  is there any way to get to the lower-
right corner of the selected range without deselecting the range?
JM replied on 31-Aug-07 12:44 AM
You could try a small macro:

Sub Test()
with selection
end with
End Sub

and assign it to a button on your toolbar.
<-> replied on 31-Aug-07 02:01 AM
If the range has data, Shift + Ctrl + Down Arrow and then Shift + Ctrl +
Right Arrow.
Or, select B3 and Shift + Ctrl + End.

or Shift + Pg Down and Shift + Right Arrow for a data-less range.
Ron Coderre replied on 31-Aug-07 09:45 AM
If you already have a range selected....

Ctrl+. <---That's: Hold down the [Ctrl] key and press the period (.)

Each time you do that the active cell will move to the next corner of the
range, moving clockwise.
From upper left
to upper right
to lower right
to lower left
to upper left, again

Also, in case you didn't already know....
Both of these combinations select the current region
Ctrl+* <---That's the asterisk on the numeric keypad

Does that help?


Microsoft MVP (Excel)
nomail198 replied on 31-Aug-07 11:36 AM
Yes.  Very cool!  Thanks.  I will have to study the keyboard shortcuts
Help page.