Google Sheets waa aalad faafin caan ah oo beddeshay habka ay dadku maanta u wada shaqeeyaan. Qalabkan xaashida xaashida ku salaysan waxa uu u adeegaa sida ugu fiican oo ah beddelka bilaashka ah ee Microsoft Excel oo u ogolaanaya in la abuuro oo wax ka beddelo xogta xaashiyaha khadka. Excel wuxuu leeyahay sifooyin badan iyo hawlo ka dhex dhisan marka loo eego qalabkan internetka ee bilaashka ah, laakiin waa la door bidaa sababtoo ah waa bilaash iyo iyadoo ay ugu wacan tahay helitaanka internetka ee qalab kasta.

Xaashiyaha Google^{(Google Sheets)} ayaa hadda ku daray sifooyinkan xoogga badan si ay u toosiyaan hawlaha kelida ah. Ka shaqaynta xaashida xaashida waxay ku lug leedahay hawlo soo noqnoqda oo noqon kara caajis iyo daal. Macros waa habka ugu habboon ee wax soo saar leh kaas oo kuu ogolaanaya inaad si toos ah u dhaqaajiso hawlaha caajiska ah. Isticmaalayaasha xaashida faafinta^{(Spreadsheet)} ee wax ka qabta xaashiyo badan oo leh jaantusyo, hawlo iyo xog isku mid ah ayaa ka faa'iidaysan doona macros-yada. Macros waa habka ugu fiican ee lagu badbaadin karo wakhtigaaga kaas oo kuu ogolaanaya inaad diirada saarto hawshaada muhiimka ah halkii aad samayn lahayd wareegyada jilicsan ee hawlaha aan fiicneyn.

Waa maxay Macros?

Macros waa barnaamijyada kuu ogolaanaya inaad si otomaatig ah u sameyso hawsha soo noqnoqota adoon u baahnayn inaad qorto koodka. Macros duub^(Macros) ficilkaaga oo badbaadi si aad dib ugu isticmaali karto marka loo baahdo hal gujis oo badhan ah. Macros waxay ku anfacayaan markaad rabto inaad otomaatig u sameyso shaqada caajiska ah ee xaashida sida ku darista qaabaynta, gelida safaf dheeri ah, gelida tiirar dheeri ah, jaantusyo qaabaynta, jaantusyada abuurista, gelida qaacidooyinka qallafsan, gelista hawlaha iyo in ka badan.

Macros marka la eego erayada fudud waa aalad waqti-badbaadin ah taas oo ah trifecta ee duubista hawsha soo noqnoqota, badbaadinta hawsha iyo socodsiinta hawsha mustaqbalka mar kasta oo aad rabto adiga oo aan qorin wax kood ah.

Abuur Macros^{(Create Macros)} si aad u otomaatig u noqoto hawlaha Google Sheets

Bilaw ^(sheets.new)Google^(URL) Sheets adiga oo Shift + Sxaashida^{(Google Sheet)} cusub _ _^{(Google Drive)} _

Ku qor qaar ka mid ah xogta unug kasta oo xaashida ah. U gudub Tools oo ka dooro Macros ka menu-hoos u dhaca.

Guji Makrooska Diiwaanka^{(Record macro)} ee liiska hoosaadka. Tani waxay furi doontaa sanduuqa Macro-ga cusub ee duubista^{(Recording New Macro)} xagga hoose ee xaashidaada. Waxaa lagu weydiin doonaa inaad kala doorato labada doorasho. Ama isticmaal^(User) tixraacyo dhammaystiran ama isticmaal tixraacyo qaraabo ah.

Dooro tixraacyo dhammaystiran^{( Absolute references)} marka aad rabto inaad ku dabaqdo farsamooyinka qaabaynta goobta saxda ah ee la duubay. Waxaad dhahdaa^(Say) inaad rabto inaad qaabayso tiro unugyo A2: C1 ah. Dooro xogta unugyada kala duwan oo ka dhig fartu mid geesinimo leh. Macros-ku waxa lagu dabaqi doonaa unugyadan oo keliya oo had iyo jeer ka dhigi doona xogta ku jirta unugyadaas inay u muuqdaan kuwo dhiirran iyadoon loo eegin unugga aad gujisay. Dooro tixraacyada qaraabada ah^{(Relative references)} marka aad rabto inaad ku dhejiso qaabaynta unugyada kala duwan, iyadoon loo eegin goobta saxda ah ee la duubay. Waxay khusaysaa macros ku salaysan halka cursorkaagu yahay halkii uu ka ahaan lahaa goobta saxda ah ee makrosyada lagu duubay.

Tani waxay faa'iido leedahay markaad rabto inaad geliso jaantuska, hawlaha, ama qaababka unugyada aad doorato iyo unugyadeeda u dhow. Waxaad dhahdaa haddii aad ku duubto xogta geesinimada leh unugga B1, makro waxaa loo isticmaali karaa hadhow unugyada geesinimada leh ee C1.

Kadib markaad doorato labada doorasho, xaashida google-ka ayaa bilaabi doona duubista. Habayn kasta^(Any) oo aad rabto inaad otomaatig ugu samayso unugga, tiirka, ama safka waa la duubayaa. Hubi inaad qorsheyso waxa aad rabto inaad si fiican u duubto ka hor.

Ku codso qaabaynta unug kasta oo la doonayo oo u eg beddelidda qaabka font, midabka, iwm. Macro -ga la duubay ayaa eegaya mid kasta oo ka mid ah tillaabadaada.

Marka la sameeyo, dhagsii badhanka Save oo ku qor magaca Macro kaaga .

Waxa kale oo aad dejin kartaa furaha gaaban^(Short) ee gaarka ah si aad si dhakhso leh u gasho Macro gaaga .

Guji badhanka Save si aad u abuurto makro-kaaga.

Si aad u gasho Macro, u gudub Tools , oo dooro Macros.

Guji^(Click) galka Macro aad rabto in aad ka socodsiiso liiska hoosaadka.

Wax ka beddel Macro-kaaga

Waxaad bedeli kartaa magaca Macros , aad wax ka beddeli kartaa qoraallada Macro , ka saar macros ama xitaa ku dar furaha kiiboodhka ka dib markii la sameeyay.

U gudub Qalabka^(Tools) oo guji Macros ka menu-hoos u dhaca.

Ka dooro Maamul Macros^{( Manage Macros)} liiska hoosaadka si aad wax uga beddesho makro kaaga.

Si aad u tirtirto macro ama aad wax uga beddesho qoraalladeeda, aad in badan^(More) oo ka ag dhow xulashooyinka Macros oo guji Cusbooneysii.^(Update.)

Soo deji macros kale

Xaashiyahaaga Google, u gudub Qalabka. ^{(Tools. )}Ka dooro xulashooyinka Macros ee ka muuqda liiska. Guji ikhtiyaarka Import ka menu-hoosaadka.

Riix badhanka shaqada ee^{( Add function)} ku xiga shaqada aad rabto inaad soo dejiso.

Waa intaas oo dhan. Waxaan rajeynayaa inaad u aragto qoraalka mid faa'iido leh.^{(That’s all there is to it. I hope you find the post useful.)}

How to automate tasks in Google Sheets with Macros

Google Sheets is a popular spreadsheet tool that has changed the way people collaborate today. This web-based spreadsheet tool serves best as a free alternative to the Microsoft Excel and allows to create and edit spreadsheets data online. Excel has more features and built-in functions than this free online tool, but it is preferred because it is free and due to its online accessibility from any device.

Google Sheets has now added these powerful features to automate monotonous tasks. Working in spreadsheets involves recurrent tasks that can be boring and tiresome. Macros are the apt way of being productive that lets you automate the boringly monotonous tasks. Spreadsheet users who deal with multiple sheets having similar charts, functions, and data would reap benefit from the macros. Macros are the best way to save your time that would allow you to focus on your important task rather than doing the deary round of bland tasks.

What are Macros?

Macros are the programs that will allow you to automate the recurring task without the need of you writing code. Macros record your action and save them so that you can reuse them when needed with a single click of a button. Macros come in handy when you want to automate the tedious work in sheets like add formatting, inserting additional rows, inserting additional columns, formatting tables, creating charts,  inserting tricky formulas, inserting functions and more.

Macros in simple terms is a time-saving tool which is a trifecta of recording a repetitive task, saving the task and running the task in future whenever you want without writing any code.

Create Macros to automate tasks in Google Sheets

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

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

Click on the Record macro from the submenu. This will open a Recording New Macro box at the bottom of your sheets. You will be asked to choose between the two options. Either User absolute references or use relative references.

Select Absolute references when you want to apply formatting techniques to the exact location as recorded. Say you want to format a range of cells A2: C1. Select the data in those range cells and make the font bold.  The macros will be applied to these cells only and will always make the data in those cells range appear bold regardless of which cell you clicked. Select Relative references when you want to apply formatting to the different cells, irrespective the exact location as recorded. It applies macros based on where your cursor is rather than the exact location where the macros were recorded.

This is useful when you want to insert chart, functions, or formulas on the cells you select and its nearby cells. Say if you record bolding data in cell B1, the macro can be later be used to bold cells in C1.

After you select between the two choices, the google sheets will start recording. Any formatting which you want to automate in the cell, column, or row will be recorded. Make sure to plan what you want to record well in advance.

Apply the formatting in any desired cell-like changing the font style, color, etc. The Macro recorded watches each of your step.

Once done, click the Save button and type the name for your Macro.

You can also set a custom Short key to have quick access to your Macro.

Click the Save button to create your macro.

To access the Macro, Navigate to Tools, and select Macros.

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

Edit your Macro

You can change the name of the Macros, edit the Macro scripts, remove macros or even add the keyboard shortcut after its created.

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

Select Manage Macros from the submenu to edit your macro.

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

Import other macros

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

Click Add function button next to the function you want to import.

That’s all there is to it. I hope you find the post useful.

Related posts

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Wax-soo-saarka ugu fiican ee Google Sheets si loo horumariyo wax soo saarka

• Samee qaab-dhismeedka xaashiyaha Google-ka adigoon Google-ka ku biirin goobta shaqada

• Sida loo muujiyo Taariikhda iyo Waqtiga Hadda ee Excel iyo Google Sheets

• Sida loo sameeyo liiska hoos u dhaca ee Excel iyo Google Sheets

• Xaashiyaha Google ee ugu Fiican iyo Hababka Jadwalka Kalandarka ee Excel Online

• 10ka Mawduuc ee ugu Wanaagsan Google Chrome browser

• 14 Habab Google-ku-ool ah oo Wax-ku-ool ah oo Isticmaalka Maalinlaha ah

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Sida loo soo dejiyo ama loo dhoofiyo Google Chrome bookmarks fayl HTML ah

• Sida loo habeeyo oo loo dhexgeliyo Google Calendar bog kasta

• Hagaaji Google Docs Spellcheck oo aan si sax ah u shaqayn

• Sida loogu xidho Google Sheets iyo Excel

• ERR_NAME_NOT_RESOLVED, Khaladaadka Code 105 gudaha Google Chrome

• Sida loogu daro oo loo isticmaalo aagagga wakhtiyada badan ee Google Calendar

• Beddelka Bookmarks Google ee ugu fiican oo aad rabto inaad eegto

• Sida loo sameeyo Koofida Dhibcaha ee Google Docs dhowr daqiiqo gudahood

• Sida loo geliyo WordArt xaashida Google-ka iyadoo la isticmaalayo Google Drawings

• Sida loo geliyo sanduuqa qoraalka gudaha Google Docs

• Ku tiriso qiimayaasha kala go'ay ee hal unug ee Excel iyo Google Sheets