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

Google Sheets tutorials›Spreadsheet basics›Record a macro

Google Sheets · Verified tutorial

Record a macro in Google Sheets

This is a safe macro-recording fixture. Record the first planned step by entering exactly "Sort range" in B2, "A2:C8" in C2, and "Yes" in D2. Do not start or save an actual macro recording. Keep step 2 unchanged.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

This is a safe macro-recording fixture. Record the first planned step by entering exactly "Sort range" in B2, "A2:C8" in C2, and "Yes" in D2. Do not start or save an actual macro recording. Keep step 2 unchanged.

Step-by-step

1

Select the targetThis is a safe macro-recording fixture.

2

Apply the changeRecord the first planned step by entering exactly "Sort range" in B2, "A2:C8" in C2, and "Yes" in D2.

Shortcut or faster method

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

Expected result

Both planned macro steps are marked as recorded in the register.

Common mistake

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

Troubleshooting

Re-select B2 and repeat the final action. Both planned macro steps are marked as recorded in the register.

Example spreadsheet data

This is the clean fixture used for the verified run.

Step	Action	Target	Recorded
1
2	Freeze header	Row 1	Yes

Video transcript

Open the prepared Macro recording spreadsheet.
Select the target. This is a safe macro-recording fixture.
Apply the change. Record the first planned step by entering exactly "Sort range" in B2, "A2:C8" in C2, and "Yes" in D2.
Both planned macro steps are marked as recorded in the register.