# How to Create a Macro in Microsoft Excel

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-create-a-macro-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3750ab56e05a00fdca0b/preview?step=1

## Steps

1. Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Developer'.
2. Select 'Record Macro' from the available options.
3. 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.
4. Once done, tap 'OK' to proceed further.
5. Start performing the specific action you wish to record as a macro.
6. Finally, head back to the top menu bar and click 'Stop Recording'. At this point, the macro will be created and saved instantly.