Although Microsoft Excel is a powerful spreadsheet out of the box, macros make it even more useful. You can create and record macros within the app.

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.

Macros are created as relief from doing tasks repeatedly, it helps to automate these tasks. How to create and run a Macro in Excel To create and run a macro in Microsoft Excel follow the steps below.

To jump in and create your own macros, click the red record button on the toolbar, then hit F9 to begin recording keystrokes and mouse actions.

Create and populate the spreadsheet, then enter formulas. Now we can create a Conditional Formatting Rule to identify the bills that are due now. Use Conditional Formatting to create Excel Alerts 1.

For our scenario, we're trying to create a button that moves email messages from the Inbox into an Archive folder like this one—the magic happens behind the scenes with a macro that we'll create.