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:
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:
- 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.