Excel for Mac - Customize your keyboard shortcuts

Hi Insiders -

There's a feature in the latest Insider Fast update of Excel for Mac that many people have been asking for.  The "Customize Keyboard" feature is now available.  To get the update, go to Help > Check for Updates, and opt into the Insiders program and choose the Fast updates. If you have version 16.17 (180822) or greater, you should see the feature. It should show up for everyone else (in the non-Insider update) sometime next month. If you were waiting for this feature so you could upgrade from Excel 2011, now you can.  Your shortcuts should continue to work.

You can now assign your own key combinations to many commands within Excel. Just go to the Tools menu and choose Customize Keyboard. Pick the category of command you’re trying to find, and then look for the command in the list. Select a command, press a key combination, and see if it’s used already. If it’s already in use, you may want to pick a different combination. Then just click the “Add” button to assign the key combination to the selected command.

We would love to hear your feedback about this feature and of course we want to know if you run into any problems, so please click the Smiley-face button in the top corner of the Excel window to send us feedback.

Thanks - Steve K (Microsoft Excel)

 

Discussion Info

Last updated January 29, 2020 Views 1,565 Applies to:

You can now assign your own key combinations to many commands within Excel. Just go to the Tools menu and choose Customize Keyboard.

Updated to the Insider Fast version referenced above, but I'm not seeing a Customize Keyboard command under the Tools menu — or anywhere else for that matter. Am I doing something wrong?

Try quitting all your Office apps and restarting Excel and make sure you're online when you do so.  There's a service check that happens when you restart, and sometimes it takes more than one try to get the latest Insider Fast settings.  Features can be hidden or shown to you based on the settings.

I'm assuming that you have the version number mentioned earlier.

Mac Version Custom Keyboard Fast Insider 16.18 Office 365 subscription.

__________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.

If my reply has helped, mark accordingly - Helpful or Answer
Phillip M. Jones, C.E.T.
Thanks — it showed up in 16.18.

Thank you for bringing this feature back. However, it still does not address all of the keyboard shortcuts that were available in Excel 2011 for Mac. Specifically, Paste Values, which was CMD+SHIFT+V. 

It would be super-helpful to get this back, please.

Also, I really don't understand why this is so hard - why was this removed? And why can't all possible functions have a keyboard shortcut?

Honestly, if it wasn't for the notification that the 32-bit 2011 version would no longer be supported in future versions of Mac OS, I'd still be using it. I'm sure all the fancy new bells & whistles and collaboration features are great, but all I need at home are the basics.

You can assign CMD+SHIFT+V to Paste "Values and Number Formatting".  There are many commands available to be assigned to a key combination.  Sometimes the command names are not as clear as they could be, but hopefully you can find what you need by searching for commands in the different categories available.

  
Is there an option to customise movement shortcuts? Such as changing sheets?