Excel select to end of adjacent column

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


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.


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.