Move to end of selection in MS Excel (2003)

I have a large set of data that I update regularly by copy/pasting and overwriting old data. I do this for 10k-15k records at a time. Once I have pasted, I manually scroll down to the last line of data that was just pasted in order to mark/highlight that part of the file so it is easier to pick up there on the next import.

i.e. I have 20k total rows, I have pasted (and thus have an active selection of) 10k rows, starting at 5k, and ending at 15k (in VBA: Range(A5000:F15000)).

I know that if I use CTRL+DOWN, I can move to the last row of ALL the data (up to any spaces that may be present in the selected column), and I use these kinds of shortcuts regularly.

Is there a keyboard shortcut or other simple method I can use to jump to the last row of the CURRENT SELECTION (as opposed to the last row of all data)?

_{*I am very familiar with VBA and how to program this kind of process (which is probably ultimately easier), but at this point I just haven't gotten around to creating a macro to do this.}

Gaffi

Posted 2012-07-30T16:55:19.350

Reputation: 418

Answers

Try Shift+Enter. This will keep your selection but move the active cell to the end of the selection.

Excellll

Posted 2012-07-30T16:55:19.350

Reputation: 11 857

That's exactly what I was looking for, thanks. – Gaffi – 2012-07-30T18:59:53.087

beat me to it! I let me answer sit unposted for too long. – Brad – 2012-07-30T19:04:12.637

2I just want to point out too that, following that logic, <Shift>+<Tab> also works! – Gaffi – 2012-07-30T19:05:33.190

Do this using BOTTOM-UP Approach

Steps to follow:

Press CTRL+DOWN ARROW continueously
Now you have reached to the last row of the excel sheet
Press CTRL+UP ARROW to reach to the last row of the record

UPDATE:

Use this short-cut key:

CTRL+SHIFT+DOWN ARROW

Siva Charan

Posted 2012-07-30T16:55:19.350

Reputation: 4 026

But I don't want the last row of all the data, I want the last row of the selection, which ends somewhere in the middle of the whole block. i.e. I have 20k total rows, I have pasted (and thus have a selection of) 10k rows, starting at 5k, and ending at 15k. How can I jump to line 15k (the last of the selection)? – Gaffi – 2012-07-30T17:11:59.907

@Gaffi: Updated the answer. – Siva Charan – 2012-07-30T17:20:05.327

Thanks for you assistance, however this is still not what I am looking for. <CTRL>+<SHIFT>+<DOWN ARROW> will select that range, but I already have my selection. I want to move the cursor/screen to the last line of the current selection. – Gaffi – 2012-07-30T17:21:50.503

@Gaffi: with this approach, scroll will move till end of your selection. After that, use mouse to click on the last row. – Siva Charan – 2012-07-30T17:25:08.380

I just tried this. What happens is all the remaining rows of data are simply added to my current selection, and the screen moves down past the end of the current selection. – Gaffi – 2012-07-30T17:29:07.000

Shift+downarrow gets you to the bottom of your selection set AND adds the next cell also. So if you are in Column A you highlight row 1 thru 1000, apply the method stated to jump to cell A1001. So go back up 1 cell for your actual end point of the original selection set.

Mitch

Posted 2012-07-30T16:55:19.350

Reputation: 1

-2

Shift+CTRL+downarrow works if you would like to select last last row with records. But it does not work if there are spaces in the rows.

sal

Posted 2012-07-30T16:55:19.350

Reputation: 1

2The OP has stated multiple times that this is not what he wants. – G-Man Says 'Reinstate Monica' – 2014-10-07T20:42:22.493