Excel

How to Create a Macro in Excel

Create an Excel macro to automate repeated formatting, cleanup, reporting, and data-entry steps without rebuilding the workflow by hand.

Do this with AI

Try Griddy free

Start in your browser. Also works with Excel and Google Sheets.

By Justin Freels/Updated August 20, 2026/5 min read

An Excel macro records or runs a set of actions so you can repeat them with one click. Use macros for recurring cleanup, formatting, report prep, and workbook setup tasks where the steps are predictable.

Macros are powerful, but they should automate a stable workflow. Do not start with VBA if the process still changes every week.

Turn on the Developer tab

Step 1. Go to File -> Options -> Customize Ribbon.

Step 2. Check Developer, then choose OK.

Step 3. Open the Developer tab and choose Record Macro.

Step 4. Give the macro a short name with no spaces, such as FormatWeeklyReport.

Step 5. Choose where to store it. Use This Workbook if the macro only belongs in the current file.

After recording starts, Excel captures many of your actions. Clean, deliberate steps matter.

Example: format a weekly restaurant expense report

Suppose a restaurant manager exports weekly expenses and needs the same setup before review: date formatting, currency formatting, filters, frozen headers, and column widths.

Record a macro that:

Selects the expense table.
Applies filters.
Formats the Date column as a short date.
Formats Amount as currency.
Freezes the header row.
Auto-fits the columns.
Adds a bold title above the table.

The next week, the manager can paste the new export into an expense tracker for restaurants and run the macro instead of repeating the setup by hand.

When recording is enough

Recorded macros are best for visible worksheet actions: formatting, filtering, sorting, inserting columns, clearing old rows, and preparing reports.

They are weaker when the process needs decisions. If the macro needs to detect changing headers, skip bad rows, or combine files, you may need to edit the VBA or use Power Query instead.

Common macro mistakes

Mistake	What happens	Fix
Recording random clicks	Macro becomes fragile	Plan the steps before recording
Using fixed cell references	Macro breaks when data moves	Start from tables or named ranges
Saving as `.xlsx`	Macro is removed	Save as `.xlsm`
Running untrusted macros	Security risk	Only enable macros from trusted files

WATCH OUT

Macros can contain executable code. Do not enable macros in files from unknown senders.

The Griddy way

Macros are useful, but deciding what to automate and what to leave manual is the hard part.

"Look at this weekly expense workbook and suggest a simple macro for formatting the report, freezing headers, adding filters, and preparing it for review"

Griddy can inspect the workflow, propose the repeatable steps, and help turn a messy recurring process into a safer spreadsheet routine.

Review macro safety

Use a copy of the workbook when testing a macro and make the steps reversible where possible. Confirm what workbook, sheets, ranges, and external files the code can access before enabling it. Keep macros disabled for files from untrusted sources, and do not store passwords or API keys in VBA. Add a clear button or instruction for running the macro, log what it changed, and test with an empty range as well as a normal workbook. A macro that saves time is useful only when its scope and failure mode are understandable to the person who inherits it.

Sources

Do this with AI

Turn the instructions into a finished spreadsheet.

Tell Griddy what you need in plain English, then inspect and keep editing the result in the browser, Excel, or Google Sheets.

Try Griddy freeStart in your browser. No download required.

Also works withExcel Google Sheets

Use this on real templates

Automate the recurring spreadsheet steps around templates

Macros are most useful when a team repeats the same cleanup, formatting, and report-prep steps before reviewing operating templates.

Finance

All posts