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

Google Sheets tutorials›Spreadsheet basics›Edit a macro

Google Sheets · Verified tutorial

Edit a macro in Google Sheets

This is a safe macro-editing fixture. Update the Format report entry by changing only C2 to exactly "A1:D1". Do not open, authorize, edit, or run an actual macro. Keep every other cell unchanged.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

This is a safe macro-editing fixture. Update the Format report entry by changing only C2 to exactly "A1:D1". Do not open, authorize, edit, or run an actual macro. Keep every other cell unchanged.

Step-by-step

1

Select the targetThis is a safe macro-editing fixture.

2

Apply the changeUpdate the Format report entry by changing only C2 to exactly "A1:D1".

Shortcut or faster method

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

Expected result

The Format report register entry targets A1:D1 and all other macro details are preserved.

Common mistake

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

Troubleshooting

Re-select C2 and repeat the final action. The Format report register entry targets A1:D1 and all other macro details are preserved.

Example spreadsheet data

This is the clean fixture used for the verified run.

Macro	Action	Range	Shortcut
Format report	Bold header	A1:C1	Ctrl+Alt+1
Monthly close	Apply number format	D2:D20	Ctrl+Alt+2

Video transcript

Open the prepared Edit macro spreadsheet.
Select the target. This is a safe macro-editing fixture.
Apply the change. Update the Format report entry by changing only C2 to exactly "A1:D1".
The Format report register entry targets A1:D1 and all other macro details are preserved.