Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros or the Fastest way to Autofill Rows | Excel Discussion (Misc queries) | |||
SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
What is fastest for this? The Small VBA or many Worksheet Functions...? | Excel Worksheet Functions | |||
Select same range from large number of workbooks | Excel Worksheet Functions | |||
Fastest Way to Filter/Delete | Excel Worksheet Functions |