Using Microsoft Excel macros, you can run a prerecorded set of steps to automate many of your repetitive tasks. You’ll have to turn on the feature before you can use it. We’ll show you how to activate macros on a per-spreadsheet basis as well as for all spreadsheets in Excel.