Get familiar with the "Name Box" (left of formula bar).

Click in starting cell (A1),
Click in name box,
Enter ending cell address (Z1000),
Hold down <Shift and hit <Enter

OR

Click in name box,
Enter range (A1:Z1000)
Hit <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Katherine" wrote in message
...
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