7

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
5

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.

3

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.

  • 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 2 '15 at 7:27
-1

shift+fn+

This, for Windows system.

  • 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 How to Answer and take our tour. – Burgi Jul 27 '17 at 8: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

Not the answer you're looking for? Browse other questions tagged or ask your own question.