Recording macros in Excel - Step-by-Step Guide

Introduction

Recording macros lets you save a series of actions in Excel so you can repeat them easily. It helps when you do the same steps many times and want to save time.

When you format a report the same way every week and want to do it with one click

When you enter repetitive data and want to automate the process

When you apply the same filters and sorting to a table regularly

When you create charts with the same style and want to repeat the steps quickly

When you want to automate simple tasks without writing code

Steps

Step 1: Click

- View tab on the Ribbon

The View tab options appear

💡 If you don't see the Developer tab, use the View tab to start recording

Step 2: Click

- Macros group, then click Record Macro

A small window opens to name your macro and set options

Step 3: Type

- Macro name box

The macro will be saved with this name

💡 Use a simple name without spaces, like FormatReport

Step 4: Choose

- Store macro in dropdown

You decide where the macro is saved: This Workbook, New Workbook, or Personal Macro Workbook

Step 5: Click

- OK button in the Record Macro window

Excel starts recording all your actions

Step 6: Perform

- Any actions in the worksheet like typing, formatting, or clicking

Excel records these steps to repeat later

Step 7: Click

- View tab, then Macros group, then Stop Recording

Excel stops recording and saves the macro

Before vs After

Before

User manually formats cells, types data, and applies filters step by step

After

User clicks a button or shortcut to run the macro and all formatting and steps happen automatically

Settings Reference

Macro name

📍 Record Macro window

To identify the macro for later use

Default: Macro1

Store macro in

📍 Record Macro window

To choose where the macro is saved

Default: This Workbook

Shortcut key

📍 Record Macro window

To assign a quick keyboard shortcut to run the macro

Default: None

Description

📍 Record Macro window

To add notes about what the macro does

Default: Empty

Common Mistakes

Naming the macro with spaces or special characters

Excel does not accept spaces or special characters in macro names and will show an error

Use simple names with letters and numbers only, like FormatReport

Not stopping the recording after finishing the steps

Excel will keep recording all actions, including mistakes or unrelated steps

Always click Stop Recording when done to save the macro correctly

Running macros from an unsaved workbook

Macros saved in the workbook will be lost if the file is not saved

Save your workbook before recording or running macros to keep them

Summary

Recording macros saves your repeated Excel steps to run them automatically later

You start recording, do your actions, then stop recording to save the macro

Use simple macro names and always stop recording to avoid errors