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:

Solution 1

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.

Solution 2

This should work:

1. On the cell containing group1, Press Shift + ← once
2. 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+↓.
3. 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.

Comments

[Dave]

I would be amazed if there is built in. However, a macro could be work, and also be assigned to a short cut!

[Tim Pietzcker]

I just tried that in Excel 2013, and there, Ctrl-Shift-Down selects until row 1048576, not the end of the data. Any ideas?

[Burgi]

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 How to Answer and take our tour.

[Ramhound]

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.

[Ravindra Bawane]

This doesn't answer OPs question. Please read questions thoroughly and do your best to understand what is being asked before answering.