Chapter 14. AUTOMATING WITH MACROS
Introducing Macros
You can use macros to automate many of the tasks you perform in Excel. For example, if you frequently format your data in a particular way, you can use Excel's macro recorder to record the steps you use to format your data. You can then play back the recorded steps whenever you want to apply your format. Most of the commands you can execute in Excel, you can also record and play back.
The commands you use to create and execute macros are located on the Developer tab. By default, the Developer tab does not display in Excel. To display it, you must choose Developer in the Customize the Ribbon pane in the Excel Options dialog box.
You begin recording macros by clicking Record Macro on the Developer ...
Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition 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.
