How to automate tasks in Google Sheets with Macros

Google Sheets is a well-liked spreadsheet software that has modified the way in which folks collaborate at the moment. This web-based spreadsheet software serves greatest as a free various to the Microsoft Excel and permits to create and edit spreadsheets knowledge on-line. Excel has extra options and built-in features than this free on-line software, however it’s most popular as a result of it’s free and due to its on-line accessibility from any system.

Google Sheets has now added these highly effective options to automate monotonous tasks. Working in spreadsheets includes recurrent tasks that may be boring and tiresome. Macros are the apt approach of being productive that allows you to automate the boringly monotonous tasks. Spreadsheet customers who deal with a number of sheets having comparable charts, features, and knowledge would reap profit from the macros. Macros are one of the best ways to save your time that might enable you to focus in your necessary activity slightly than doing the deary spherical of bland tasks.

What are Macros?

Macros are the packages that may enable you to automate the recurring activity with out the necessity of you writing code. Macros file your motion and save them so as to reuse them when wanted with a single click on of a button. Macros come in useful once you need to automate the tedious work in sheets like add formatting, inserting further rows, inserting further columns, formatting tables, creating charts,  inserting difficult formulation, inserting features and extra.

Macros in easy phrases is a time-saving software which is a trifecta of recording a repetitive activity, saving the duty and working the duty in future everytime you need with out writing any code.

Create Macros to automate tasks in Google Sheets

Launch Google Sheets by getting into sheets.new in your browser URL or just open Google Drive folder and press Shift + S to create a brand new Google Sheet in that folder.

Type some knowledge in any cell of the sheet. Navigate to Tools and choose Macros from the drop-down menu.

svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3 - How to automate tasks in Google Sheets with Macros

 

Click on the Record macro from the submenu. This will open a Recording New Macro field on the backside of your sheets. You can be requested to select between the 2 choices. Either User absolute references or use relative references.

svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3 - How to automate tasks in Google Sheets with Macros

 

Select Absolute references once you need to apply formatting methods to the precise location as recorded. Say you need to format a spread of cells A2: C1. Select the info in these vary cells and make the font daring.  The macros can be utilized to these cells solely and can at all times make the info in these cells vary seem daring no matter which cell you clicked. Select Relative references once you need to apply formatting to the completely different cells, irrespective the precise location as recorded. It applies macros primarily based on the place your cursor is slightly than the precise location the place the macros have been recorded.

This is helpful once you need to insert chart, features, or formulation on the cells you choose and its close by cells. Say if you happen to file bolding knowledge in cell B1, the macro may be later be used to daring cells in C1.

After you choose between the 2 selections, the google sheets will begin recording. Any formatting which you need to automate in the cell, column, or row can be recorded. Make positive to plan what you need to file nicely in advance.

Apply the formatting in any desired cell-like altering the font type, shade, and so forth. The Macro recorded watches every of your step.

Once carried out, click on the Save button and sort the title in your Macro.

svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3 - How to automate tasks in Google Sheets with Macros

 

You may set a customized Short key to have fast entry to your Macro.

Click the Save button to create your macro.

To entry the Macro, Navigate to Tools, and choose Macros.

svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3 - How to automate tasks in Google Sheets with Macros

 

Click on the Macro folder you need to run from the submenu.

Edit your Macro

You can change the title of the Macros, edit the Macro scripts, take away macros and even add the keyboard shortcut after its created.

Navigate to Tools and click on Macros from the drop-down menu.

svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3 - How to automate tasks in Google Sheets with Macros

 

Select Manage Macros from the submenu to edit your macro.

To delete a macro or edit its scripts, go to More beside the choices Macros and click on Update.

Import different macros

svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3 - How to automate tasks in Google Sheets with MacrosGoogle Sheets enable you to import any customized features created utilizing Google Apps script file to the Macro menu.

On your Google Sheets, navigate to Tools. Select the choices Macros from the drop the menu. Click the choice Import from the submenu.

Click Add operate button subsequent to the operate you need to import.

That’s all there may be to it. I hope you discover the put up helpful.

Leave a Comment