Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

4 Answers 4

up vote 6 down vote accepted

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

share|improve this answer
    
That's exactly what I was looking for, thanks. –  Gaffi Jul 30 '12 at 18:59
    
beat me to it! I let me answer sit unposted for too long. –  Brad Jul 30 '12 at 19:04
2  
I just want to point out too that, following that logic, <Shift>+<Tab> also works! –  Gaffi Jul 30 '12 at 19:05

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

share|improve this answer
    
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 Jul 30 '12 at 17:11
    
@Gaffi: Updated the answer. –  Siva Charan Jul 30 '12 at 17:20
    
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 Jul 30 '12 at 17:21
    
@Gaffi: with this approach, scroll will move till end of your selection. After that, use mouse to click on the last row. –  Siva Charan Jul 30 '12 at 17:25
    
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 Jul 30 '12 at 17:29

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.

share|improve this answer

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.

share|improve this answer
1  
The OP has stated multiple times that this is not what he wants. –  G-Man Oct 7 at 20:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.