How to Change a Keyboard Shortcut for a Macro in Word or Excel
Question details
The user needs to know how to change or assign keyboard shortcuts for existing macros in both Excel and Word.

- 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).
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.
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.
Press Alt+F8 on your keyboard, or go to the View tab and click 'Macros' to open the Macros window.
In the list of available macros, click on the name of the specific macro you want to modify.
Click the 'Options' button located on the right side of the dialog box.
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.
Click 'OK' to apply the new keyboard shortcut, and then close the Macros dialog.

Change a Macro Shortcut in Word
Word uses the application-wide 'Customize Keyboard' feature to assign custom hotkeys to macros, rather than managing them inside the Macros dialog.
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. Enable Developer Tools: Open WPS Office and go to the Developer tab to access the Macros and VBA tools.
- 2. Open Macros Dialog: Click on 'Macros' or press Alt+F8 to view your list of available macros in WPS Spreadsheet or Writer.
- 3. Configure Shortcuts: Select your target macro, click 'Options', and assign a personalized shortcut key combination for quick execution.

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.




