Excel for Mac - Customize your keyboard shortcuts

Anonymous
2018-08-23T19:38:09+00:00

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)

Microsoft 365 Insider | Excel | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

12 answers

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  2. Anonymous
    2018-08-30T21:40:46+00:00

    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.

    0 comments No comments
  3. Anonymous
    2018-08-31T20:44:14+00:00

    Thanks — it showed up in 16.18.

    0 comments No comments
  4. Anonymous
    2018-10-16T13:58:06+00:00

    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.

    9 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2018-10-16T18:07:54+00:00

    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.

    0 comments No comments