Hey there, besties! Today I’m super excited to share with you an essential tip for Google Workspace Apps Script users: searching for codes, repositories, users, issues, and pull requests on Google Sheets. It’s a convenient and efficient way to quickly find what you need. So grab a coffee, relax, and let me spill the beans!
Manual Installation of a Google Sheets Macro
If you prefer to manually install a macro, here’s how you can do it:
- Open a new Google Sheet from sheets.google.com.
- Go to the script editor by selecting “Tools” > “Script Editor” from the menu.
- Copy and paste the desired macro code at the end of the “Code.gs” file (open in the script editor).
- Click the “Save” icon or select “File” > “Save” to save the macro.
- Close the script editor window.
Importing a Google Sheets Macro
If you’d rather import an existing macro into Google Sheets, follow these steps:
- Select “Tools” > “Macros” > “Import” on Google Sheets.
- Identify the macro you want to import and click the associated “Add Function” option.
Running a Google Sheets Macro
Once you’ve installed or imported a macro, here’s how you can run it:
- Select “Tools” > “Macros” > “Macro Name” on Google Sheets.
Now, let me introduce you to some of the fascinating macros you can find:
- Benford’s Law: Macro code and a blog article are available.
- Dates: Adds a calendar dropdown and date validation for the active range.
- Freeze: Freezes specified rows and columns on the active sheet or all sheets.
- TSCreateUrlCheatsheet: Creates a list of Google Workspace resource URLs. The author also invites you to share any other Google Workspace resource URLs you may know.
Let’s not forget about recent updates, like the addition of a new Jamboard shortcut (jam.new) to TSCreateUrlCheatsheet on March 20, 2021.
Last but not least, the google-sheets-macros project is licensed under MIT and was created by Laura Taylor. You’re free to copy, modify, merge, publish, distribute, sell, and use the software as long as you retain the copyright notice and accept the license conditions.
So there you have it, all the necessary information to explore this incredible functionality in Google Sheets. I hope it proves useful in your projects and daily tasks. If you want to learn more, check out Crawlan.com for other tips, tricks, news about Google Sheets, and much more!
Now, sit back, relax, and enjoy the efficiency of Google Sheets with these impressive macros. Happy exploring, and see you soon!
