4

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.

migrated from superuser.com Jul 1 '17 at 19:58

This question came from our site for computer enthusiasts and power users.

  • Sorry to be obnoxious, but why deactivate the F-keys? It's one of the more annoying things I find in the Apple default setup - I always change the setting to use regular F-keys on all Macs I've regularly used. Plays better with applications expecting a PC-style keyboard that way, and I don't fiddle with the screen brightness that often... ;) – Per Lundberg Nov 23 '18 at 8:37
  • Because I'm on a Macbook Pro 15'', with the touchbar. The touch-bar is good for usual stuff, that the Apple-keys offered you: volume-control, brightness, etc. But to find an F-key, without looking at the keyboard is as easy as finding the G-spot; so it's better to assume that it's simply not there and move along. :-) – Zeth Nov 24 '18 at 3:14
  • Fair enough @Zeth. The Touchbar was one of the horrible things I disliked about my 2017 MBP. ;) But, I've since then switched jobs and am using Linux on the desktop instead... :) – Per Lundberg Nov 25 '18 at 18:55
4

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

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

2

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.

  • This is the answer. How the hell did I never realize this. Thank you! – nicolefurlan Mar 29 at 18:53
0

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).

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.