Macros
Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet.They record sequences of menu selections that you choose so that a series of actions can be completed in one step.
Recording a Macro
To record a Macro:
§ Click the View tab on the Ribbon
§ Click Macros
§ Click Record Macro
§ Enter a name (without spaces)
§ Enter a Shortcut Key
§ Perform the Macro
§ Click Marcos
§ Click Stop Recording
Running a Macro
To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the Macro. Or you can view all macros and run by:
§ Click Macros
§ Click View Macros
§ Choose the Macro and click Run
Post a Comment