1

I know there is a command to do this but I just can't find it. The answer here should have used this command but did not.

Q: Given an empty column (B) adjacent to a column populated with data (A). There is a way to:

  1. Enter a formula in B#
  2. Use shortcut_1 to select from B# to the last cell in B to have adjacent data in A.
  3. ctrl+enter to propagate the selected formula to the selected cells.

Does anyone know the keystroke for shortcut_1 on OSX? On windows I think the shortcut is ctrl + shift + (noted here). However, ctrl+ brings up the application mode in OSX.

2

It's the same as Windows, but use the Command key instead of Ctrl: +Shift+arrow key

More shortcuts here: Excel keyboard shortcuts for Mac OS

  • I think there is yet another command to do exactly what is wanted. Also, OSX defaults this shortcut to the 'applications' command via Mission Control, so this needs to be disabled. – Toaster Jan 28 '15 at 16:41
  • I thought you just needed one way, not all possible ways to do it. Please update your question if so. Ctrl+↓ is the default shortcut to Application windows via Mission Control. If B is your last column, you can also do Ctrl+Shift+End. Hope it helped either way! – user387876 Jan 28 '15 at 17:46
  • I could swear that I used this shortcut before. It really should be there if it isn't already, would be super useful. – Toaster Jan 28 '15 at 18:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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