How to Create a Macro in Microsoft Excel
- George Apostolov
How to Create a Macro in Microsoft Excel: step-by-step guide
Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Developer'.
Select 'Record Macro' from the available options.
After that, provide all the required information based on your preferences. Add a unique Macro Name and Description. At the same time, specify the Storage and Shortcut Key you wish to use.
Once done, tap 'OK' to proceed further.
Start performing the specific action you wish to record as a macro.
Finally, head back to the top menu bar and click 'Stop Recording'. At this point, the macro will be created and saved instantly.
Quick answer: To create a macro in Microsoft Excel, click Developer in the top menu bar, select Record Macro, and enter your preferences including name and description, storage, and shortcut key. Tap OK, perform the action you wish to record, and click Stop Recording in the top menu bar to instantly save it.
About this Microsoft tutorial
Record and save custom macros quickly in Microsoft Excel by following these simple steps to automate your everyday spreadsheet tasks. This guide shows how to create a Macro in Microsoft Excel in 6 steps, starting with "Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Developer'" and finishing with "Finally, head back to the top menu bar and click 'Stop Recording'. At this point, the m...". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create a Macro in Microsoft Excel?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Create a Microsoft Form in SharePoint, How to Create a New Worksheet in Microsoft Excel and How to Create a Pie Chart in Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
