Excel select to end of adjacent column

Question

I'm using Excel 2010 on a Mac. If I hit CMD + shift + down arrow, the current column is selected to the end of the column. Is there a keyboard shortcut that, instead of selecting to the end of the column, select up to the end of the data in an adjacent column?

Hopefully this diagram explains what I mean:

enter image description here

I would be amazed if there is built in. However, a macro could be work, and also be assigned to a short cut! — Dave, Oct 25 '14 at 13:37

score 6 · Answer 1 · edited Sep 30 '15 at 12:58

6

In column V1 use Ctrl + ↓ to reach the bottom of the column.

→ across to column W, then Ctrl + Shift + ↑ to select the column to the top of the cell.

edited Sep 30 '15 at 12:58

Excellll

12,627
11
51
78

answered Sep 30 '15 at 09:59

Greg

61
1
1

LPChip · Answer 2 · 2017-07-27T14:29:53.113

3

This should work:

On the cell containing group1, Press Shift + ← once
While still holding Shift, press the keys to select until the end of the data.
You write ⌘ which is a Mac key and Office 2010 is for Windows. The correct key combination therefore would be Ctrl+Shift+↓. As you are already holding shift, keep it pressed and just additionally press Ctrl+↓.
Now release Ctrl so you are only holding Shift, and press → once to get back to the column you want to select.

This should give you the selection you want to have.

edited Jul 27 '17 at 14:29

answered Oct 25 '14 at 13:40

LPChip

59,229
10
98
140

I just tried that in Excel 2013, and there, Ctrl-Shift-Down selects until row 1048576, not the end of the data. Any ideas? – Tim Pietzcker Jan 02 '15 at 07:27

score -1 · Answer 3 · edited Aug 09 '17 at 16:40

-1

shift+fn+↓

This, for Windows system.

edited Aug 09 '17 at 16:40

phuclv

26,555
15
113
235

answered Jul 27 '17 at 01:29

Gisela

1

2

I don't have an `fn` key on my PC. Can you clarify where this information is from and which keys it refers to? Please see [answer] and take our [tour]. – Burgi Jul 27 '17 at 08:18
CMD is the equivalent of Function on an Apple keyboard. What should be used is Function+Down Arrow this will take the cursor to the last filled cell. – Ramhound Jul 27 '17 at 12:25
This doesn't answer OPs question. Please read questions thoroughly and do your best to understand what is being asked before answering. – music2myear Jul 27 '17 at 16:32

Excel select to end of adjacent column

3 Answers3

Linked