How to Create a Macro in Microsoft Excel

Quick summary

Creating a macro in Microsoft Excel lets you automate repetitive tasks by recording a sequence of actions and replaying them with a shortcut key. Using the Developer tab and the Record Macro feature, you can set up a named, reusable macro in just a few steps.

Steps

1. Open your Microsoft Excel worksheet, go to the top menu bar, and click the Developer tab.
2. Select Record Macro from the available options in the Developer menu.
3. In the dialog box, enter a unique Macro Name and Description, then set your preferred Storage location and Shortcut Key.
4. Click OK to confirm your settings and begin recording.
5. Perform the specific actions you want to record as a macro directly in your worksheet.
6. Return to the top menu bar and click Stop Recording — your macro will be saved instantly and ready to use.