In Microsoft Excel for Mac 2011 (14.0.0) how can I modify the enter/return key to edit in cell instead of moving the selection down? I know that in Preferences Edit you can uncheck the box that says 'After pressing RETURN, move selection Down/Right/Up/Left' which at least makes it a little less annoying, but this behaviour is still not productive. I'm aware I could emulate the effect using Automator, macros, Butler and whatnot but I prefer not to use a third-party application to do this.
For this shortcut I will stick with Sheet 1, Sheet 2, Sheet 3. Step 2: Execute the shortcut. This shortcut will allow you to move right or left, depending on the arrow keys used.
I'm open to modifying the system preferences and I'm comfortable using the Terminal, though. EDIT: I found out here that CTRL+U is the keyboard shortcut for edit in cell. Now if it were somehow possible to remap that to CMD+Return by editing some plist file or writing some magic formula in the Terminal, it would be perfect! Excel does not offer a direct way to customize this: it is neither a menu command (which would be available to OS X’s system wide shortcuts), nor is it a shortcut configurable via Office’s dedicated Tools → Customize Keyboard (approximate translation, I’m on a German system) dialog – as you can easily test by calling the dialog and pressing Ctrl+U in the Add Shortcut box (no assigned shortcut will be shown). You can, however, work around the issue by remapping Cmd+Return to Ctrl+U using Takayama Fumihiko’s (which, despite its name, will work on any Mac running OS X 10.4 upwards). You will have to add a private.xml configuration file to KeyRemap4MacBook like, with its XML content looking like this: Remap 'Edit in Cell' in Excel Use Command+Return instead of Ctrl+U private.appexcelcommandreturntoctrlu EXCEL -KeyToKey- KeyCode::RETURN, VKCOMMAND, KeyCode::U, ModifierFlag::CONTROLL – this will restrict the remapping to Excel (for a complete list of the, see its source code).