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
add comment

2 Answers

up vote 5 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
add comment

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
add comment

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.