Chapter 92 Recording macros
Questions to be answered in this chapter:
What is a macro?
What role does the Developer tab play in recording and running macros?
How do I record a macro?
How can I record a macro that applies a desired format to any range of cells?
How can I run a macro?
How do I use relative references to record macros?
How can I record a macro that filters a PivotTable to show only data from my top-20 customers?
Answers to this chapter’s questions
What is a macro?
Macros enable you to easily automate many repetitive Excel tasks. For example, if you often apply a particular format to a range of cells, you can create a macro that performs this formatting task with the click of a button. Perhaps there is a set of headings you often ...
Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th 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.
