Google updated Google Sheets and since April, 11, is possible to record macros in Sheets. “Let’s say you need to format new data imports or build the same chart across multiple sheets of quarterly data. Repeating the same steps manually can take hours, but the Sheets macro recorder lets you record those actions and play them back on command without having to write any code,” said Ryan Weber, Product Manager at G Suite.
Here how to record macros:
- At the top, click Tools and then Macros and then Record macro.
- At the bottom, choose which type of cell reference you want your macro to use: Use absolute references: The macro will do tasks on the exact cell you record. For example, if you bold cell A1, the macro will only ever bold cell A1 regardless of which cell you clicked. Use relative references: The macro will do tasks on the cell you select and its nearby cells. For example, if you record bolding cells A1 and B1, the macro can later be used to bold cells C1 and D1.
- Complete the task you want to record. When you’re done, click Save.
- Name the macro, create a custom shortcut, and click Save. (Note: When you create a macro in Google Sheets, an Apps Script is created. To edit this Apps Script, at the top, click Tools and then Script editor.)
- To perform a macro, click Tools and then Macros and then the macro you want.
And how to edit macros on Google Docs?
- At the top, click Tools and then Macros and then Manage macros.
- Next to a macro, click More. Rename or remove the macro.
- When you’re done, click Update.