Quick Macros

In a previous tip, we shared a macro that will print a file's name in your workbook's footer. To run the macro, we told you to select Tools, Macro, select Macros from the resulting submenu, highlight the macro by name, and click Run. This process takes several steps--but fear not, there's a shorter way.
Instead of selecting Macro from the Tools menu to run a macro, press Alt-F8. Doing so will open the Macro dialog box, where you can highlight the macro by name and then click Run. Using this shortcut, you'll eliminate several unnecessary clicks.