Using Macros

A macro is a collection of commands that you can apply with a single click. They can automate almost anything you can do in the program you’re using and even enable you to do things you might not have known were possible.

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.

Additional Help

• For general information about Macros visit Microsoft Office
• Contact Academic Computing if you need additional help.