VBA & Macro Problems

How to Change a Keyboard Shortcut for a Macro in Word or Excel

Olivia MillerOlivia Miller Oct 29, 2026 873 views

Question details

The user needs to know how to change or assign keyboard shortcuts for existing macros in both Excel and Word.

How to Change a Keyboard Shortcut for a Macro in Word or Excel
Product
Microsoft Word and Excel
Device & OS
not provided
Scenario
Organizing and streamlining workflows by assigning custom hotkeys to frequently used macros.
Observed behavior
The user wants to configure macro shortcuts, noting that the management process differs between Excel (using the Macros dialog) and Word (using the Customize Keyboard command).
Before you start

Ensure you have already recorded or created the macros you want to assign shortcuts to, and check that your desired key combination is not already in use by a critical system or default application function.

Solution 1Recommended

Change a Macro Shortcut in Excel

Use the built-in Macros dialog in Excel to quickly assign or modify the Ctrl or Ctrl+Shift shortcut keys for your macros.

Excel handles macro shortcuts directly from the standard Macros dialog, making it straightforward to assign simple key combinations.

1
Open the Macros Dialog

Press Alt+F8 on your keyboard, or go to the View tab and click 'Macros' to open the Macros window.

2
Select the Macro

In the list of available macros, click on the name of the specific macro you want to modify.

3
Access Macro Options

Click the 'Options' button located on the right side of the dialog box.

4
Assign the Shortcut Key

In the 'Shortcut key' box, enter a letter. You can use Ctrl plus a letter (e.g., Ctrl+M) or hold Shift and enter a letter to use Ctrl+Shift (e.g., Ctrl+Shift+M). To remove a shortcut, simply delete the letter from the box.

5
Save Changes

Click 'OK' to apply the new keyboard shortcut, and then close the Macros dialog.

Change a Macro Shortcut in Excel
Shortcut Overrides: Custom macro shortcuts in Excel will override default Excel shortcuts while the workbook containing the macro is open. For example, if you assign Ctrl+C to a macro, you will temporarily lose the default 'Copy' shortcut.

Easily Manage and Run Macros in WPS Office

WPS Office fully supports VBA macros, allowing you to automate repetitive tasks and assign custom keyboard shortcuts in both WPS Spreadsheet and WPS Writer seamlessly.

  1. 1. Enable Developer Tools: Open WPS Office and go to the Developer tab to access the Macros and VBA tools.
  2. 2. Open Macros Dialog: Click on 'Macros' or press Alt+F8 to view your list of available macros in WPS Spreadsheet or Writer.
  3. 3. Configure Shortcuts: Select your target macro, click 'Options', and assign a personalized shortcut key combination for quick execution.
Full compatibility with Microsoft Excel (.xlsm) and Word (.docm) macro-enabled formats.Intuitive Macros dialog for easy VBA script management.Customizable keyboard shortcuts to speed up your daily workflows.Lightweight application that loads macros quickly without lagging.
QA img-9

Frequently Asked Questions

Why is my new macro shortcut not working in Excel?

It may conflict with another active macro or a strict system shortcut. Excel prioritizes custom macro shortcuts over default application ones, so ensure you aren't accidentally overriding a critical shortcut you use often. Adding the 'Shift' key (Ctrl+Shift+Letter) helps avoid conflicts.

Can I use numbers or special characters for macro shortcuts in Excel?

No, Excel's Macro Options dialog only allows you to use alphabetical letters (A-Z or a-z) combined with the Ctrl or Ctrl+Shift keys. If you need a more complex shortcut, you would have to use an Application.OnKey VBA script.

Where are Word macro keyboard shortcuts saved?

In Word, when you assign a macro shortcut via the Customize Keyboard dialog, you can choose to save the changes in the Normal template (Normal.dotm) to make it available for all future documents, or limit it to the current document via the 'Save changes in' dropdown menu.