Google Sheets macros record spreadsheet actions and save them as Apps Script functions. They are useful for repetitive formatting or data-cleanup steps that you perform the same way each time.
- Open the spreadsheet.
- Choose Extensions > Macros > Record macro.
- Choose absolute or relative references based on how you want the recorded actions to behave.
- Perform the actions you want the macro to repeat.
- Choose Save, give the macro a clear name, and assign a shortcut if useful.
- Run the macro on test data before using it across an important sheet.
Absolute versus relative references
Absolute references target the same cells each time. Relative references replay actions based on the currently selected cell, which is more flexible but easier to misuse.
Macros create Apps Script
Recorded macros can be inspected and edited in Apps Script. Changes to the generated function can add logic that the recorder could not capture.
Permissions
Scripts can request authorization depending on what they do. Review permission prompts and code before authorizing scripts copied from other people.
Keep a test copy
A macro can overwrite values or formatting quickly. Duplicate an important sheet or maintain version history before running a new macro across a large range.
Triggers are separate
A recorded macro runs when invoked. Time-based or edit-based automation uses Apps Script triggers and should be configured deliberately.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.