MacOS – How to create custom shortcuts in Excel 2016 for mac

keyboard shortcutsmacosmicrosoft excelmicrosoft-excel-2016

I recently updated to Excel 2016 from Excel 2011 for mac, and I'm missing a very important feature which saved me a lot of time: custom keyboard shortcuts, i.e. being able to create new shortcuts for commands, or edit existing shortcuts.

I have googled for this and searched the support site for this and haven't found anything yet.

What surprises me most is that this feature would exist in Word (see here) and not in Excel.

Has anyone found a solution or workaround?

Best Answer

  • For now, at least, you need to do this with the OS X System Preferences -> Keyboard -> Shortcuts feature. This only works for commands that are available on the application's menus.

    I was able to create shortcuts this way for my two most frequent functions, Insert Rows and Delete Rows. The menu item for Insert Rows is called "Rows". It's on the Insert Menu, but you just enter "Rows" in the shortcut. The menu item for Delete is Delete in the Edit menu, so just enter "Delete". This isn't the same as "Delete Rows", which is not available on the menu so I need to select a row with Shift-Space before deleting it.

    I'm hopeful they will restore this feature in the future.

  • Related Question