Move the selected cell in a highlighted range

[lezawang]

Hi

I have a range A1:D10
I highlighted all cells, and now the selected cell is A1.
Which shortcut key I can use to change the selected cell from A1 to A10 ?

I can keep pressing Enter but that does not move me to the A10 right away
I tried Ctrl+ .
but that move the selected cell from A1 to D1 and then to D10 and then to A10

Thank you.

 

[Michael M]

Select A1 then press and hold the SHIFT key and select A10

 

[lezawang]

Select A1 then press and hold the SHIFT key and select A10

Thank you very much. but that would highlight the whole column A1:A10 and still A1 is the selected one.

 

[Michael M]

Sorry, I misunderstood your question
USe CTRL + DOWN ARROW

 

[lezawang]

Sorry, I misunderstood your question
USe CTRL + DOWN ARROW

Thanks again, but that would un highlight all cells .. i want to keep all cells highlight and cell A10 selected.

 

[Michael M]

Press SHIFT + ENTER

 

[lezawang]

Thanks again, Shift+enter will switch selected cell from A1 to D10. I want to switch from A1 to A10. Thank you.

 

[Michael M]

I don't believe you can do it with multiple columns of selected data !
Except with VBA
Is there a reason to do this ??

Sub MM1()
ActiveSheet.Range("A1:D10").Select
Range("A10").Activate
End Sub