LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Katherine
 
Posts: n/a
Default Selecting a large number of rows, but not all

Hi,

I have a spreadsheet with almost 10,000 rows that I am going to do a lot of
sorts and subtotals on. I want to be able to start near the bottom row but
not the absolute bottom one and and select up to almost the top row but not
the absolute top. Aside from holding down the left mouse button and waiting
for it to scroll up all of the rows, is there a shortcut other than "select
all" to start at one row and have it select everything between that and
another row in one quick step?

Thank you,
Katherine
 
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
Data from a number of rows and columns to one column mark_h82 Excel Discussion (Misc queries) 2 January 15th 05 03:02 AM
How can I open a large Excel file with more than 65536 rows? Ted Excel Discussion (Misc queries) 1 January 13th 05 07:47 PM
How do I change a large number of cells from a postive to a neget. bmordy Excel Discussion (Misc queries) 6 January 5th 05 09:42 PM
sorting rows wich can vary in number Bart Excel Discussion (Misc queries) 4 December 14th 04 06:59 AM
increasing the number of rows of a worksheet beyond 65536? ibu Excel Discussion (Misc queries) 2 November 26th 04 08:56 AM


All times are GMT +1. The time now is 03:15 PM.

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

About Us

"It's about Microsoft Excel"