In Microsoft Excel 2010, I have a macro assigned to a keyboard shortcut. Strangely, it's not working properly. I want to double-check the keyboard binding.
How can I view and/or change the assignment of keyboard shortcuts to existing macros?
When you initially create a macro, you can assign it to a Ctrl+<key> keyboard shortcut, as in this screenshot:
But I can't find anywhere in the UI to view and/or change the existing bindings.
1 Answer
The way to view and change the mapping of keyboard shortcuts to macros in Excel is completely different than in Word. Maybe that's what's tripping you up.
In Excel:
- In the Ribbon, click View → Macros dropdown → View Macros. That will display the "Macro" dialog.
- In the "Macro" dialog, click on a macro and then click the "Option" button. That will display the "Macro Options" dialog.
The "Macro Options" dialog is where you can change the assigned keyboard shortcut.
You can see an example of that dialog here:
