Master Visually®: Excel® 2007

Chapter 29. Working with Macros

Macro Basics

A macro is a small program that carries out the result of a set of keystrokes and mouse clicks. Under ordinary conditions, you could simply perform the keystrokes and mouse clicks and never think about macros. However, macros become useful when the keystrokes and mouse clicks you need to perform are repetitive. When you find yourself repeating a set of keystrokes and mouse clicks in a worksheet or chart, you should consider creating a macro.

Do not let the word "program" intimidate you. You can record a macro very easily. Excel's macro feature captures your keystrokes and mouse clicks as you make them and then enables you to save the results of those keystrokes and mouse clicks. Then, you can run the ...