If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fastest way to select large range (e.g. B3:F1002)?
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. |
#2
|
|||
|
|||
Fastest way to select large range (e.g. B3:F1002)?
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. |
#3
|
|||
|
|||
Fastest way to select large range (e.g. B3:F1002)?
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. |
#4
|
|||
|
|||
Fastest way to select large range (e.g. B3:F1002)?
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? |
#5
|
|||
|
|||
Fastest way to select large range (e.g. B3:F1002)?
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? |
#6
|
|||
|
|||
Fastest way to select large range (e.g. B3:F1002)?
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. |
#7
|
|||
|
|||
Fastest way to select large range (e.g. B3:F1002)?
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? |
#8
|
|||
|
|||
Fastest way to select large range (e.g. B3:F1002)?
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. |
Thread Tools | |
Display Modes | |
|
|