Excel Guides

Removing a Macro from a Shortcut Key in Excel

If you want to remove a macro from a shortcut key in Excel, follow these steps:

  1. Open the workbook that contains the macro.
  2. Click File, and then click Options.
  3. In the Excel Options dialog box, click Customize Ribbon.
  4. In the Keyboard shortcuts section, click Customize. The Customize Keyboard dialog box appears.
  1. In the Save changes in: list, select the workbook where you want to store the modified shortcut keys. If you want to share your customized keyboard shortcuts with others, save them in your Personal Macro Workbook so that the shortcuts are available whenever you start Excel.

  2. Click (remove). The currently assigned shortcut key is removed from the list of Shortcut keys.

Note:

You can also remove a macro from a shortcut key by using the Keyboard tab in the Macro Options dialog box (Macros command, Options button). For more information about how to display this dialog box, see Assign or remove a shortcut key. You can also use this method to reassign a different shortcut key to a macro.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.