A macro records your mouse clicks and keystrokes while you work and lets you play them back later. You can use a macro to record the sequence of commands you use to perform a certain task. When you run the macro, it plays those exact commands back in the same order, causing Excel to behave just as if you had entered the commands yourself. Macros are easy to create. You tell Excel to start recording, perform actions as you normally do, and then tell Excel when you're done.
When to Use This
- To automate repetitive document production tasks.
- Automating the creation of documents that you may use regularly.