How To Set Macro In Excel

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2022 for Mac Excel 2022 Excel 2022 for Mac Excel 2022 Excel 2022 for Mac Excel 2022 Excel 2010 More...Less

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 want. When you create a macro, you are recording your mouse clicks and keystrokes. Afterward you create a macro, y'all can edit it to make minor changes to the way it works.

Suppose that every month, you create a report for your accounting manager. You want to format the names of the customers with overdue accounts in ruby-red, and too utilize assuming formatting. You can create and and so run a macro that speedily applies these formatting changes to the cells you lot select.

How?

Icon image

Before y'all record a macro

Macros and VBA tools tin can be found on the Developer tab, which is hidden by default, and then the first stride is to enable it. For more than information, see Show the Developer tab.

Icon image

Tape a macro

In the Code grouping on the Developer tab, click Record Macro.
Optionally, enter a name for the macro in the Macro name box, enter a shortcut fundamental in the Shortcut fundamental box, and a description in the Clarification box, and then click OK to kickoff recording.
Perform the actions you desire to automate, such as entering boilerplate text or filling down a column of information.
On the Developer tab, click Terminate Recording.

Icon image

Have a closer look at the macro

You tin can larn a fiddling about the Visual Bones programming language by editing a macro.

To edit a macro, in the Code group on the Programmer tab, click Macros, select the name of the macro, and click Edit. This starts the Visual Basic Editor.

Run across how the actions that y'all recorded appear as code. Some of the code will probably be clear to y'all, and some of information technology may exist a piddling mysterious.

Experiment with the code, close the Visual Bones Editor, and run your macro over again. This time, run across if anything different happens!

Next steps

To learn more about creating macros, see Create or delete a macro.
To acquire about how to run a macro, encounter Run a macro.

How?

Icon image

Earlier you record a macro

Make sure the Developer tab is visible on the ribbon. By default, the Developer tab is not visible, so practise the following:

Go to Excel > Preferences… > Ribbon & Toolbar.
In the Customize the Ribbon category, in the Main Tabs listing, select the Developer check box, and then click Save.

Icon image

Record a macro

On the Developer tab, click Record Macro.
Optionally, enter a proper name for the macro in the Macro name box, enter a shortcut key in the Shortcut central box, and a description in the Clarification box, and then click OK to start recording.
Perform the actions you want to automate, such every bit entering boilerplate text or filling downwardly a column of data.
On the Developer tab, in the Code group, click Stop Recording.

Icon image

Take a closer look at the macro

Yous can learn a piffling well-nigh the Visual Basic programming language by editing a macro.

To edit a macro, in the Developer tab, click Macros, select the proper noun of the macro, and click Edit. This starts the Visual Basic Editor.

See how the deportment that yous recorded announced as code. Some of the code will probably be clear to y'all, and some of it may be a little mysterious.

Experiment with the code, close the Visual Basic Editor, and run your macro again. This time, come across if anything different happens!

Need more assistance?

You can ever ask an expert in the Excel Tech Customs or get support in the Answers customs.

Demand more help?