© Ugur Akinci
To record a macro, click the Record Macro button on the Developer Tab to display the Record Macro dialog box:
As you can see, you can assign a shortcut key to this macro by entering a letter into the shortcut key field.
WARNING: But don’t act in haste by immediately entering a letter and then pressing OK.
Because the letter you enter will be appended to the CTRL button and saved as Ctrl + [Letter] combination.
Most such combos already have an assigned meaning.
For example, Ctrl+C is used for copying and Ctrl+V is using for pasting.
If you enter C or V into that field, the new shortcut will ride over and replace the old one. You will not be able to use some of the most traditional Excel shortcuts if you do that.
While your cursor is still blinking in the letter field, press the SHIFT key first and then enter a letter of your choice. That will record a Ctrl+Shift+LETTER shortcut instead of just the Ctrl+Letter alternative:
Most Ctrl+Shift+LETTER combinations are not taken. When you press that shortcut, it will activate only your macro, without overriding any popular shortcuts.
Once you give your macro a name and fill out the other fields and click OK, the macro will be saved.
TIP: To display the list of recorded macros, press Alt + F8 to display the Macro dialog box:
To run a macro:
(1) Select it from the Macro Name list (above) and click Run.
(2) Press the shortcut keys you’ve assigned earlier (e.g., “Ctrl+Shift+M”).