Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

12. Automate tasks and input

In this chapter

• Enable and examine macros

• Create and modify macros

• Run macros

• Present information and options as form controls

Many tasks you perform in Excel, 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. You can create various shortcuts for running the macro, including buttons on the Quick Access Toolbar or on a worksheet.

If you create workbooks for other people to use, you can provide macros that perform specific tasks for the workbook users, and form fields that guide the data-entry ...