Productivity & Extras · ~2 min read

Excel Macros for Beginners (Record Your First Macro)

Record, run and save a simple macro.

Video link coming soon
What you will learn

Step by step

1. Record once

Every Monday you format the same report: bold headers, money in the last column. A macro records those clicks once and replays them in a second.

You will record a macro, run it with a shortcut, and see why most first macros only ever work in one place.

Excel Macros for Beginners (Record Your First Macro): Record once
Record once

2. Record a macro

Click A1. Open View, Macros, Record Macro: Alt, W, M, R. Name it FormatReport, set the shortcut to Control Shift Q, and press Enter.

Excel is recording. Select A1 to C1 and press Control B. Then select C2 to C6 and press Control Shift 4.

Stop the recording with the same keys: Alt, W, M, R.

Excel Macros for Beginners (Record Your First Macro): Record a macro
Record a macro

3. The same-cells trap

Now the second team's report in E to G. Click E1 and press Control Shift Q.

Nothing changed in E. The selection jumped back to column C. The macro recorded the exact cells, A1 to C1 and C2 to C6, so it formats those every time.

Quick pause: if you have ever recorded a macro that only worked once, a like really helps the channel. Here is the fix.

Excel Macros for Beginners (Record Your First Macro): The same-cells trap
The same-cells trap

4. Relative references

Click E1. Turn on Use Relative References: Alt, W, M, U. Now the macro remembers moves, not addresses.

Record again: Alt, W, M, R, name it FormatBlock, give it Control Shift W, and Enter.

Press Shift and Right twice to select three headers, Control B. Then Down, Right twice, Shift and Down four times, Control Shift 4. Stop recording.

Now the third report in I to K. Click I1 and press Control Shift W. Bold headers, money format, right where you started.

Excel Macros for Beginners (Record Your First Macro): Relative references
Relative references

5. Save as .xlsm

To keep macros, save the file as an Excel Macro-Enabled Workbook, dot x l s m. A normal dot x l s x file drops every macro when it closes.

Excel Macros for Beginners (Record Your First Macro): Save as .xlsm
Save as .xlsm

6. Recap

Recap: Alt W M R records and stops, a shortcut runs it, Use Relative References makes it work anywhere, and dot x l s m keeps it.

In the next lesson, you will ask Copilot questions about your data.

Which boring task would you hand to a macro first? Tell me in the comments.

Excel Macros for Beginners (Record Your First Macro): Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Power Query Intro in Excel (Clean and Combine Data)
Next tutorial: Where to Go Next: VBA, Power BI and DAX →