What Is a Macro?

A macro is a recorded series of commands you can play back in Excel by selecting the macro's name from a list or by pressing a keystroke or clicking a button that's assigned to the macro. In this chapter, you learn how to record commands with the macro recorder, name and run your macros, and create toolbar buttons and keystrokes for convenient access to your macros.

Note

Before creating your own macro to automate a task you commonly perform, check Excel's help system to determine whether Excel already offers a shortcut for that task. Also, ask yourself whether you can use an easier feature, such as AutoCorrect or AutoText, instead of a macro.