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:
- Enter a formula in B#
- Use shortcut_1 to select from B# to the last cell in B to have adjacent data in A.
- 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.