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.
Best Answer
Try Shift+Enter. This will keep your selection but move the active cell to the end of the selection.