In Excel, you run a macro manually or automatically. A macro is an action or a set of actions that you can use to automate tasks. This topic shows you several ways to run macros manually or …

If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you …

To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all …

To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then, you can run the macro by clicking a button on the Quick Access Toolbar or pressing a …

Use the Visual Basic Editor on the Developer tab to edit macros, or learn how to change macro security settings.

After you create a macro, you can assign it to a button you click to run the macro. You can assign a macro to a button on the Quick Access Toolbar or to a button in your own personal group on …

Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.

Learn how to change the settings that enable or disable macros in Excel, and more. Change the macro security settings to control which macros run when you open a workbook.

By single stepping through a macro, you can observe the flow of the macro and the results of each action, and isolate any action that causes an error or produces unwanted results.

You create a macro in Excel by running the macro recorder or by using the Visual Basic for Applications (VBA) editor. After you've created your macro, you'll want to save it so you can …