26

I'm on a Macbook Pro, working quite a lot in Google Sheets. I've deactivated the F-keys (so it's not an option to use F2). I can't find a shortcut for editing a cell with text in it. If it's an empty cell I can just start typing. But if I want to edit a cell with content in it, I can't seem to find a way to do it. I've tried these:

  • CMD+ENTER
  • CTRL+ENTER
  • CMD+u
  • CTRL+u
  • CMD+e
  • CTRL+e

fn-F2 is not an option.

I don't want to use the mouse (double-click on a cell to edit)...It's so clumsy and slow.

0

4 Answers 4

47

You can just press the Enter key and it should start editing your current cell.

0
7

F2 seemed like a cumbersome keyboard shortcut for such a basic thing as editing a cell, so I was really relieved when I finally realised that just pressing Enter works too.

0
2

In the hope of avoiding disappointment should anyone happen on this expecting a more comprehensive answer, the editing shortcut keys for a Mac are listed at M+ Google/Archive:

WA107404 shortcut keys for Mac editing

Action                  Shortcut
Undo                    ⌘+Z
Insert time             ⌘+Shift+:
Insert date             ⌘+;
Fill range              ⌘+Enter
Fill down               ⌘+D
Fill right              ⌘+R
Insert/edit comment     Shift+F2
Redo                    ⌘+Y
Edit a cell             Fn+F2
Ignore changes          Escape

Details should also be accessible through the Help menu (image from a Windows system):

Help menu

1

Wups... I can see, that when I press the FN, then the F-keys are actually showed in the touch-bar.

So FN+F2 is actually an option. However... I improved it, but mapping CTRL+U to FN+F2 using BetterTouchTool (really easy to setup these shortcuts in there).

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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