How about some alternatives.

Hit ctrl-end to get to the end and the work your way up.

Click on the top cell and use the scroll bar to get to the bottom and then shift
click on it.

If you know the address to select:
edit|goto
type the address
click ok.

You could hide the rows after the last row you used--but I've found that more
irritating than scrolling past the last cell.

When I have to select (say) A1 to the bottom right corner, I'll hit ctrl-end and
look for the cell that I need--if I've gone past it.

Then Ctrl-Shift-Home to select that cell through A1.

If you deleted the excess rows and columns with
Debra's macro then you can look at the scroller
how big is it, compared to the slot in the scroll bar
that is slides in.   Drag the scroller down until it
reaches the end of the slot it is in.

Shortcut keys     Ctrl+End  will take you the
lastcell as known by Excel.    see
 http://www.mvps.org/dmcritchie/excel/shortx2k.htm
 http://www.mvps.org/dmcritchie/excel/lastcell.htm
for other navigations see
 http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse

If you want to go to a specific address then use
the "name box" to the left of the "formula bar".

If you want to go to the last cell in a column
you could go down to the bottom  say  B65536
into the name box then   End+ArrowUP   but
that is a lot easier done with a macro and a
toolbar button so see
 http;//www.mvps.org/dmcritchie/excel/toolbars.htm#customdn