NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Create a macro

Google Sheets · Verified tutorial

Create a macro in Google Sheets

This is a safe macro-planning fixture. Register a new macro by entering exactly "Format report" in A2, "Bold header" in B2, "A1:D1" in C2, and "Ready" in D2. Do not create, authorize, or run an actual macro. Keep the existing Monthly close row unchanged.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

This is a safe macro-planning fixture. Register a new macro by entering exactly "Format report" in A2, "Bold header" in B2, "A1:D1" in C2, and "Ready" in D2. Do not create, authorize, or run an actual macro. Keep the existing Monthly close row unchanged.

Step-by-step

1

Select the targetThis is a safe macro-planning fixture.

2

Apply the changeRegister a new macro by entering exactly "Format report" in A2, "Bold header" in B2, "A1:D1" in C2, and "Ready" in D2.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

The macro register contains the new ready Format report entry and preserves the existing entry.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A2 and repeat the final action. The macro register contains the new ready Format report entry and preserves the existing entry.

Example spreadsheet data

This is the clean fixture used for the verified run.

Macro	Action	Range	Status

Monthly close	Apply number format	D2:D20	Ready

Video transcript

Open the prepared Macro register spreadsheet.
Select the target. This is a safe macro-planning fixture.
Apply the change. Register a new macro by entering exactly "Format report" in A2, "Bold header" in B2, "A1:D1" in C2, and "Ready" in D2.
The macro register contains the new ready Format report entry and preserves the existing entry.