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
.jpg)
0 comments:
Post a Comment
Enter your comments to JoxTech