The Macro Name field says Macro1, and that’s a good name. 5. Enter a shortcut key (if you like) in the Shortcut_key field box (enter the letter M) (you can create a button on the Ribbon menu later).

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.