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 the 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
Excel Formulas

Get industry recognized certification – Contact us