selecting cells short cut

[lezawang]

Hi
I want to select let say 100 cells A1:A100. I can do that using mouse but I wonder of I can select A1 and then go to A100 and they are all selected. I select A1 and I can go to A100 using F5 and type A100 but that would jump to A100 without highlighting the range A1:A100. Thank you.

 

[Kenneth Hobson]

Hold shift key down when you click OK in Goto dialog.