How to create custom shortcuts in Excel 2016 for mac

Solution 1:

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.

Solution 2:

Step-by-step instructions on how to do this on this page:

https://support.office.com/en-nz/article/Create-a-custom-keyboard-shortcut-for-Office-2016-for-Mac-6bbeb90e-96d9-4e03-b199-fc026ebdc321

I followed these instructions to get FIND back (Cmd-F instead of Shift-Ctrl-F) and it worked perfect. I did have to quit and restart Excel.

Key steps from the link:

1. From the Apple menu, click System Preferences > Keyboard > Shortcuts > App Shortcuts.

2. Click the + sign to add a keyboard shortcut.

3. In the Application menu, click the Office for Mac app (Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft OneNote, Microsoft Outlook) you want to create keyboard a shortcut for.

4. Enter a Menu Title and the Keyboard Shortcut and click Add.