Excel – Select next row in Excel

microsoft excelmicrosoft-excel-2010

I've searched everywhere but can't seem to find a proper answer to this. Maybe I'm not using the right terms or something? Or maybe there is no answer…

So as an example, if you select the cell A1 and press enter, it moves the selection to B1. What I want to do is have row 1 highlighted, and then move the selection to row 2. I don't want to move the data from row 1 to row 2, I just want to change what I have selected/highlighted.

Is there some sort of key combination that does this? The best I can find so far would be to press the down key, and then shift + spacebar to select the row, but at that point I might as well just click every row like I was already doing.

Edit: Thanks for the downvote it really helps!

Best Answer

Place this tiny macro in a standard module:

Sub MoveSelectionDownOneRow()
    Selection.Offset(1, 0).Select
End Sub

Then assign a shortcut key to it.

enter image description here

Related Question