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

Answer 1

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

Answer 2

Jumping corner-to-corner inside the selected range:

Ctrl+.

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

Answer 3

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

Answer 4

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.

Answer 5

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.