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
• Enter a Description

• Perform the Macro
• Click Macros
• 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

Macros

Macros are advanced features that can speed up editing or formatting you may perform often in a Word document. 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)
• Click whether you want it assigned to a button (on the Quick Access Toolbar) or the keyboard (a sequence of keys)
• To assign the macro a button on the Quick Access Toolbar:
• Click Button
• Under the Customize Quick Access Toolbar, select the document for which you want the Macro available



• Under Choose Commands:  Click the Macro that you are recording
• Click Add
• Click OK to begin Recording the Macro
• Perform the actions you want recorded in the Macro
• Click on Macros
• Click on Stop Recording Macros

• To assign a macro button to a keyboard shortcut:
• Click Keyboard
• In the Press New Shortcut Key box, type the key sequence that you want and click Assign



• Click Close to begin recording the Macro
• Perform the actions you want recorded in the Macro
• Click on Macros
• Click on Stop Recording Macros

Running a Macro
Running a macro depends on whether it’s been added to the Quick Access Toolbar or if it’s been given a Keyboard Shortcut.

• To run a Macro from the Quick Access Toolbar, simply click the Macro Icon

• To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the Macro.