Move to end of selection in MS Excel (2003)

Question

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.}

Solution 1

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

Solution 2

Do this using BOTTOM-UP Approach

Steps to follow:

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

UPDATE:

Use this short-cut key:

CTRL+SHIFT+DOWN ARROW

Solution 3

Jumping corner-to-corner inside the selected range:

Ctrl+.

https://www.excelcampus.com/keyboard-shortcuts/jump-to-last-cell-selected-range/

Comments

[Gaffi]

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)?

[Siva Charan]

@Gaffi: Updated the answer.

[Gaffi]

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.

[Siva Charan]

@Gaffi: with this approach, scroll will move till end of your selection. After that, use mouse to click on the last row.

[Gaffi]

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]

I just want to point out too that, following that logic, <Shift>+<Tab> also works!

[Gaffi]

Very interesting. Not quite as good as the currently selected answer (2x activations vs. 1x), but this still works. Thanks for the new tip!