You can automate a host of time-consuming tasks via macros.
Do you find yourself running the same laborious and repetitive commands and tasks in Microsoft Word or Excel? There must be a better way, you say to yourself. And there is: With macros. Through a macro, you can record or create a series of commands and tasks in a Microsoft Office application. Then, whenever you want to run those commands, you just trigger the macro. You can create macros to automate just about anything in a program like Word or Excel — apply special formatting, change the layout, insert objects.
Macros can sound intimidating if you’ve never ventured into their territory. They’re stored as mini programs using the Visual Basic for Applications (VBA) language. But you don’t need to be a programmer to use macros. You can record the macro by performing the various commands step by step. You can then edit the macro to make any changes. Let’s check out how to use macros to save time in Microsoft Office.
Macros are available in Word, Excel, and PowerPoint. The process for creating a macro is the same across all three applications. So once you master macros in one program, you can use the same process in the others. As usual, I’m using Office 2016 here, but the steps for creating, editing, and using macros are the same for the past few versions of Office.
Let’s launch Word to kick things off.