2

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.

Robotnik
  • 2,645
Toaster
  • 290

1 Answers1

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