LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros or the Fastest way to Autofill Rows klafert Excel Discussion (Misc queries) 1 September 30th 06 09:04 PM
SELECT large amount of data in a worksheet OTS Excel Discussion (Misc queries) 3 August 13th 05 04:43 PM
What is fastest for this? The Small VBA or many Worksheet Functions...? Maria J-son Excel Worksheet Functions 0 August 10th 05 08:24 AM
Select same range from large number of workbooks BillC Excel Worksheet Functions 2 February 18th 05 08:59 PM
Fastest Way to Filter/Delete SyrHoop Excel Worksheet Functions 6 November 10th 04 06:33 PM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"