How to assign and change a shortcut key to a macro in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide.

Assigning a macro to a shortcut key

When you start recording a macro, the Record Macro dialog box appears shown in the following figure.

How to assign and change a shortcut key to a macro

Record Macro dialog box.

You can provide a shortcut key for your macro in the Shortcut key field.

Read More: How to Assign a Macro to a Button in Excel

Changing the shortcut key assigned to a macro

Here we’re demonstrating what to do if you have decided to change the shortcut key or provide a shortcut key if you didn’t assign before:

  1. Choose Developer ➪ Code ➪ Macros (or press Alt+F8). The Macro dialog box appears.
  2. Select the macro name from the list.
  3. Click the Options button. The Macro Options dialog box shown in the following figure appears.
  4. Specify the shortcut key. Use a single letter (for a Ctrl+letter shortcut), or press Shift and enter an uppercase letter (for a Ctrl+Shift+letter shortcut).
  5. Click OK to return to the Macro dialog box.
  6. Click Cancel to close the Macro dialog box.
How to assign and change a shortcut key to a macro

Use the Macro Options dialog box to add or change a shortcut key for a macro.

Happy Excelling 🙂



Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy:

1 Comment

Leave a reply