Collection of macros for Google Sheets.
-
In your Google Sheet, open your script editor: Tools > Script editor
-
Copy and paste the code onto a new line.
-
Import the function into your Macros list. Back in your Google Sheet, go to Tools > Macros > Import and select the function you want to import.
-
Add a shortcut key (optional)
-
Run the macro!
Blog post: a The complete guide to simple automation in Google Sheets, using Macros