Make your life easier and save time with MACROS in GOOGLE SHEETS!
A macro stays with the Google Sheets file where it was created. It can be used over and over again on any of the Sheets that are included with the Google Sheets file where it was created but it can't be used with another Google Sheets file. However, you can create the same macro in as many other Google Sheets files as you like. You can create up to 10 macros within a Google Sheets file. After you create a macro, you'll see the option to Manage macros and this is where you can delete a macro if you no longer need it.
