Microsoft Excel 2019 Step by Step, First Edition

12 Automate repetitive tasks by using macros

In this chapter

• Enable and examine macros

• Create and modify macros

• Click a button to run a macro

• Run a macro when you open a workbook

• Insert form controls into a worksheet

Practice files

For this chapter, use the practice files from the Excel2019SBS\Ch12 folder. For practice file download instructions, see the introduction.

Many tasks you perform in Excel 2019, such as entering data or creating formulas, you do only once. However, there are probably one or two tasks you perform frequently that require a lot of steps to accomplish. To save time, you can create a macro, which is a recorded series of actions, to perform the steps for you. After you have created a macro, you can run, edit, or delete ...