Recording a Macro

If you find yourself repeating the same set of steps over and over, you can record a macro. Macros can run several tasks for you at the click of a button. When you turn on the macro recorder, Excel records every mouse click and keystroke action you execute until you turn off the recorder. You can even record formatting changes to charts and other objects. 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. The macro recorder doesn’t record in real time, so you can take your time to correctly complete each action.

Record a Macro

Image Click the ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.