Here's the unoptimized Karabiner json file I have in /Users//.config/karabiner/assets/complex_modifications/excel.json. If you can't find it, then follow the tutorial from the gist/link above. Once installed, add a complex modification. I've written a tutorial on how to deal with this here, but in short: It's been a couple years since this question was asked, but it's still a problem. – this will restrict the remapping to Excel (for a complete list of the keycodes used by KeyRemap4MacBook, see its source code). You can then use one of the other shortcuts on this list to lock or unlock all the selected cells. Ctrl + A: This shortcut selects all the cells in your worksheet. Ctrl + Shift + U: This shortcut quickly unlocks all the cells in your worksheet. KeyToKey- Ke圜ode::RETURN, VK_COMMAND, Ke圜ode::U, ModifierFlag::CONTROL_L Ctrl + Shift + L: This shortcut quickly locks all the cells in your worksheet. For a complete list of Windows and Mac shortcuts, see our side-by-side list. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. You will have to add a private.xml configuration file to KeyRemap4MacBook like documented on the KeyRemap4MacBook site, with its XML content looking like this: Finally, some Excel shortcuts are just plain different on a Mac. You can, however, work around the issue by remapping Cmd+Return to Ctrl+U using Takayama Fumihiko’s KeyRemap4MacBook (which, despite its name, will work on any Mac running OS X 10.4 upwards). 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). Download the Free Excel Shortcuts Cheat Sheet PDF Remove border, ctrl+shift+, ctrl+shift+ Left border, althbl, +option+left Right border, althbr, +.

Shortcut for locking an excel link mac