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.

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.

Rob

wrote in message
ups.com...
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.

Type B3:F1002 in the Name Box....Press [Enter]
or
[F5]...Type B3:F1002....Press [Enter]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)



wrote in message
ups.com...
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.

On Aug 30, 8:19 pm, "Ron Coderre"
wrote:
Type B3:F1002 in the Name Box....Press [Enter]
or
[F5]...Type B3:F1002....Press [Enter]

Does that help?

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
do.)

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?

You could try a small macro:

Sub Test()
with selection
.cells(.cells.count).activate
end with
End Sub

and assign it to a button on your toolbar.

" wrote:

On Aug 30, 8:19 pm, "Ron Coderre"
wrote:
Type B3:F1002 in the Name Box....Press [Enter]
or
[F5]...Type B3:F1002....Press [Enter]

Does that help?

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
do.)

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?

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.



wrote in message
ups.com...
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.

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+Shift+8
or
Ctrl+* <---That's the asterisk on the numeric keypad

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)



wrote in message
oups.com...
On Aug 30, 8:19 pm, "Ron Coderre"
wrote:
Type B3:F1002 in the Name Box....Press [Enter]
or
[F5]...Type B3:F1002....Press [Enter]

Does that help?

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
do.)

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?

On Aug 31, 6:45 am, "Ron Coderre"
wrote:
If you already have a range selected....
Ctrl+. <---That's: Hold down the [Ctrl] key and press the period (.)
[....]
Does that help?

Yes. Very cool! Thanks. I'll have to study the keyboard shortcuts
Help page.