Let's say you want to select A1000:A3000.
In the name box type: A1000:A3000


"brainslick" wrote:

I have a spreadsheet with a list of 40,000 account numbers. I can only handle
them in batches of 1000-3000 so I select cell 4000 and hold the mouse as I
scroll to 7000, then I hit copy. When I copy Excel jumps back to the first
selected cell. It's really tedious having to scroll through 3000 accounts
just to have to scroll through the same 3000 again to get to the next batch.

What can I do to stop the jump?