© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_17

17. Automating Task with Macros

David Slager

(1)Fort Wayne, Indiana, USA

Macros can be big timesavers for those tasks you find yourself performing over and over again. Macros enable you to record a series of steps that you normally use to perform a task, store those steps, and then automatically rerun those steps whenever you want. Macros can be quickly activated by assigning shortcut keys to them. If you think you might forget a macro’s associated shortcut key, then you can store it in the Quick Access Toolbar. You can also attach macros to buttons and other objects.

After reading and working through this chapter you should be able to

  • Create a macro that uses an ...

Get Essential Excel 2016: A Step-by-Step Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.