Recording a Macro

Recording a macro is almost as easy as recording your favorite CD or TV show. Once you turn on the macro recorder, Excel records every mouse click and keystroke action you execute until you turn off the recorder. Then you can "play," or run, the macro whenever you want to repeat that series of actions ”but Excel will execute them at a much faster rate. You don't even need to press a rewind button when you want to run it again!

Record a Macro

Click the Tools menu, point to Macro, and then click Record New Macro.

Type a name for the macro.

Assign a shortcut key to use a keystroke combination instead of a menu selection to run the macro.

Click the Store Macro In list arrow, and then select a location.

Type a description, if you want. The description appears at the bottom of the Macro dialog box.

Click OK.

Execute each command or action you need to complete the macro's task. Take the time to complete each action correctly, since the macro will repeat all moves you make.

Click the Stop Recording button.