Did you ever hold the mouse button while dragging the selection from A1 to A3000 and waiting for Excel to scroll down?
Actually, there is no need to do that. You can specify the range you want to select:
- From the Edit menu select Goto (You can also press Ctl+G)
- In the Reference field enter the address of the range you want to select.
- Press OK
Selected. Soo easy !