Samaynta ficilada isku midka ah ee marar badan soo noqnoqda maaha kaliya caajis, laakiin sidoo kale waxay noqon kartaa wakhti lumis iyo dheecaan ku yimaada wax soo saarkaaga^{(productivity)} . Tani waxay si gaar ah run u tahay isticmaalayaasha Excel ee bilawga ah^{(beginner Excel users)} , kuwaas oo laga yaabo inayan ogaanin inay fududahay in si otomaatig ah loo sameeyo hawlaha caadiga ah iyadoo la duubayo makro. Laakiin waa maxay macro  Excel ?

Macros Excel^(Excel) waxay kuu oggolaanayaan inaad otomaatig u sameyso qaar badan oo ka mid ah hawlaha caadiga ah ee aad qaban doonto, laga bilaabo gelitaanka qaacidooyinka ilaa habaynta xogta. Uma baahnid inaad noqoto programmer si aad u abuurto, maadaama Excel uu duubi karo ficiladaada markaad fulinayso. Haddii aad rabto inaad ogaato sida loo duubo macro gudaha Excel , waxaad u baahan doontaa inaad raacdo tillaabooyinka hoose.

Waa maxay Macro Excel ah?^{(What Is an Excel Macro?)}

Macro - ga Excel waa hagitaan la duubay, ^(Excel)oo gacanta lagu sameeyay VBA^{(created manually in VBA)} (Visual Basic for Applications ) ama si toos ah loo duubo iyadoo la isticmaalayo qalabka wax duubaha ee Excel^{(Macro Recorder )} . Makrogu wuxuu kuu ogolaanayaa inaad kaydiso tiro kasta oo ficilo caadi ah, sida tirtirida tiirarka maran, bedelida qaabaynta qoraalka, ama gelida habab cusub buug-shaqeedka.

Ficiladan la badbaadiyey ayaa markaa lagu socodsiin karaa iyadoo la gujinayo badhanka ama iyadoo la isticmaalayo furaha kiiboodhka gaarka ah. Macro kasta waxa uu leeyahay jid-gaab gaar ah oo aad isticmaali karto si aad dhaqso ugu soo celiso falka.

Haddii aad u isticmaasho Excel si aad u duubto makro, waxaad yarayn doontaa wakhtiga ay ku qaadanayso abuurista ama wax ka beddelka xaashida xisaabaadka, taas oo dedejinaysa socodka shaqadaada habka.

Sida loo duubo Macro gudaha Excel^{(How to Record a Macro in Excel)}

Habka ugu fudud ee macro cusub loogu abuuri karo Microsoft Excel waa in lagu duubo iyada oo la adeegsanayo qalabka wax duubista ee Macro^{(Macro Recorder )} , kaas oo aad ku isticmaali karto Excel ee Windows ama Mac . Nasiib darro, suurtogal maaha in makro lagu duubo Excel Online . 

1. Si aad macro cusub ugu duubto Excel , fur buug shaqo oo cusub ama hadda jira. Developer tab ee ku yaal bar ribbon, dooro badhanka Diiwaanka Macro^{(Record Macro)} . Haddii kale, taabo furayaasha Alt + T + M + R ee kumbuyuutarkaaga.

1. Daaqadda Diiwaanka Macro^{(Record Macro)} , waxaad u dejin kartaa magaca macro-gaaga si aad u aqoonsato ujeeddadeeda sanduuqa magaca Macro^{(Macro name)} , iyo sidoo kale inaad bixiso sharaxaad isticmaalayaasha kale ee sanduuqa Faahfaahinta^{(Description )} . Waxa kale oo aad ku dari kartaa furaha gaaban (sida Ctrl + T ) si aad macro-ga cusub ugu qoondayso furaha gaaban ee kiiboodhka.

1. Makro dukaanka ee^{(Store macro in)} liiska hoos-u-hoosaadka ah, waxaad dejin kartaa meesha aad rabto inaad ku kaydiso makro marka la duubo, sida Buug^{(This Workbook )} -hawleedkan (si aad ugu kaydiso buug-shaqeedka furan), Buug-hawleed cusub^{(New Workbook )} (si aad ugu kaydiso buug-shaqeedka cusub ). ), ama Buug-shaqeedka Macro-shaqsiyeedka^{(Personal Macro Workbook )} (si uu kuugu oggolaado inaad ku isticmaasho buugag shaqo oo badan). Dooro badhanka OK si aad u bilowdo duubista marka aad xaqiijiso doorashooyinkaaga.

1. Marka aad doorato OK , Excel Macro Recorder wuxuu ku jiri doonaa habka duubista. Ficil kasta oo aad sameyso, laga bilaabo dhagsii badhanka ilaa tafatirka unugga, waa la duubi doonaa. Samee ficilada aad rabto inaad u duubto sidii makro ahaan meeshan, ka dibna dooro batoonka Jooji duubista ee tab ^{(Stop Recording )}horumariyaha^(Developer) marka aad dhammayso.

Socodka, Tafatirka ama Tirtirka Macros Microsoft Excel ee jira^{(Running, Editing or Deleting Existing Microsoft Excel Macros)}

Iyada oo ku xidhan goobta kaydinta ee aad dooratay daaqada Diiwaanka Macro , ^{(Record Macro)}Macro -gaaga diiwaangashan waxa uu diyaar u noqon doonaa in uu ku shaqeeyo buugaag shaqo oo furan ama buug shaqo oo dhawaan la furay.

1. Si aad u socodsiiso, wax uga beddesho, ama u tirtirto macro-ga aad abuurtay, ka dooro Developer > Macros -ka ribbon-ka.

1. Daaqadda Macro^{(Macro )} , liis macros ah oo la heli karo si uu ugu dhex shaqeeyo buuggaaga shaqada ee furan ayaa lagu qori doonaa. Si aad u socodsiiso makro, ka dooro liiska, ka dibna dooro badhanka Run . Waxa kale oo aad isticmaali kartaa furaha gaaban ee kiiboodhka ee aad dooratay markii aad abuurtay makro si aad u socodsiiso beddelkeeda.

1. Si aad isbeddel ugu samayso makro-ga la duubay, dooro badhanka Tafatirka^{(Edit )} . Tani waxay furi doontaa tifaftiraha Excel VBA , taasoo u oggolaanaysa isticmaalayaasha horumarsan inay tafatiraan koodhka VBA^{(edit the VBA code)} oo ay beddelaan sida makrodu u shaqeyso. Bilawga VBA-da^{(VBA beginners)} waxaa laga yaabaa inay u fududaato inay si fudud u tirtiraan macro oo ay mar kale duubaan.

1. Si aad u tirtirto makro, ka dooro liiska, ka dibna dooro badhanka Delete .

1. Excel wuxuu ku weydiin doonaa inaad xaqiijiso inaad rabto inaad tirtirto makro. Dooro Haa^(Yes) si loo xaqiijiyo tan. Marka la tirtiro, waxaad u baahan doontaa inaad duubto makro-ga mar labaad adoo isticmaalaya tillaabooyinka kor ku xusan.

Kaydinta faylalka Excel ee la duubay Macros^{(Saving Excel Files with Recorded Macros)}

Buugaagta shaqada ee Excel^(Excel) waxaa sida caadiga ah lagu kaydiyaa qaabka faylka XLSX^{(XLSX file format )} (ama XLS buugaagta shaqada ee lagu abuuray Excel 2007 iyo wixii ka weyn). Nooca faylkani waxa uu taageeraa inta badan xogta Excel , laakiin waxa uu meesha ka saarayaa macros kasta oo kaydsan oo Excel ah.^(Excel)

Si aad u kaydiso faylka Excel oo leh macros la duubay, waxaad u baahan doontaa inaad isticmaasho qaabka faylka XLSM .

1. Si aad u kaydiso faylka Excel sida buug-shaqaale awood leh, dooro File > Save As > Browse . 

1. Daaqadda kaydi sida^{(Save As )} , ka dooro Buug Excel Macro-Enabled Workbook (*.xlsm) ee liiska hoos-u-dhaca ah. Dooro meel aad ku kaydiso faylka, ka bacdi dooro badhanka Keydi^(Save) si aad u kaydiso.

1. Markaad furto feylka Excel -macro-enabled PC kale ama ^(Excel)Mac , waxaa laga yaabaa inaad u baahato inaad u ogolaato Excel inuu marka hore sameeyo macros kasta oo ku jira. Dooro badhanka Enable Macros si aad tan u samayso.^{(Enable Macros)}

Wadaagista faylalka Excel Macros la duubay^{(Sharing Excel Files with Recorded Macros)}

Macros Excel^(Excel) waa faa'iido leh, laakiin sidoo kale waxaa ku jira khataro amni oo suurtagal ah. Haddii aad furto feyl Excel ah oo ay ku jiraan macros-ka ilo aadan aqoonin ama aadan ku kalsoonayn, markaa waxaad u oggolaanaysaa faylkaas inuu kombuyuutarkaaga ku shaqeeyo kood khatar ah.

Sababtaas awgeed, bixiyeyaasha iimaylka khadka tooska ah sida Gmail ayaa si toos ah uga xannibaya isticmaaleyaasha inay u diraan faylasha XLSM (buug-shaqeedka ^(XLSM)Excel -macro-enabled ) isticmaaleyaasha kale. Hadday tani dhacdo, waxaa laga yaabaa inaad isticmaasho adeegyada faylka wadaaga sida Google Drive si aad online ula wadaagto isticmaalayaasha kale.

Haddii aad rabto inaad la wadaagto faylkaaga macro-enabled Excel isticmaale kale oo u dhow, markaa waxaad sidoo kale eegi kartaa hababka wareejinta faylalka maxalliga ah^{(local file transfer methods)} si aad ula wadaagto PC ama Mac kale, ama aaladaha kale sida casriga ah.

Faylasha Excel^(Excel) ee Macro ku shaqeeya waxaa lagu soo xiri karaa fayras ama malware kale, sidaa darteed haddii aad furto feyl Excel ah oo aadan ku kalsoonayn, waxaa laga yaabaa inaad u baahato inaad iska baarto malware-^{(scan for malware)} ka ka dib si aad u hubiso in kombuyutarkaagu aanu waxyeello u geysan. Ama iska sawir faylka laftiisa^{(scan the file itself)} ka hor inta aanad furin.

Talooyin iyo tabaha sare ee Excel^{(Advanced Excel Tips and Tricks)}

Duubista macro waa hal khiyaamo^{(Excel trick)} oo Excel ah oo kaa caawin kara inaad waqti badbaadiso, laakiin waxaa jira astaamo kale oo Excel ah oo kaa dhigi kara mid wax soo saar leh sidoo kale. Isticmaalayaasha awoodda^(Power) ayaa laga yaabaa inay xiiseynayaan isticmaalka Excel si ay u xoqaan xogta internetka^{(using Excel to scrape data online)} , halka falanqeeyayaasha xogta laga yaabo inay xiiseynayaan sida loo isticmaalo COUNTIFS, SUMIFS iyo AVERAGEIFS^{(how to use COUNTIFS, SUMIFS and AVERAGEIFS)} si loo baaro xogta ballaaran.

Haddii aad door bidayso inaad u shaqeyso koox ahaan, ama aad la halgamayso qaab- dhismeedka Excel ee adag, waxaad sidoo kale ku wada shaqayn kartaa xaashida xaashida ee Excel^{(collaborate on Excel spreadsheets)} adoo isticmaalaya buug-hawleed la wadaago. Waxaa laga yaabaa inaad ogaato in Google Sheets uu yahay ikhtiyaarka ugu fiican^{(Google Sheets is a better option)} ee iskaashiga khadka tooska ah, si kastaba ha ahaatee, leh hawlo badan iyo astaamo isku mid ah.

How to Record a Macro in Excel

Performing the same actions over and over again isn’t jυst boring, but it can also be a waste of time and а drain on your productivity. This is especially true for beginner Excel users, who might not realise that it’s easy to automate common tasks by recording a macro. But what is an Excel macro? 

Excel macros allow you to automate many of the common tasks you’ll perform, from inserting formulas to formatting data. You don’t need to be a programmer to create them, as Excel can record your actions as you perform them. If you want to know how to record a macro in Excel, you’ll need to follow the steps below.

What Is an Excel Macro?

An Excel macro is a recorded set of instructions, created manually in VBA (Visual Basic for Applications) or recorded automatically using Excel’s Macro Recorder tool. A macro allows you to save any number of common actions, such as deleting blank columns, changing text formatting, or inserting new formulae into a workbook.

These saved actions can then be run with the click of a button or by using a specific keyboard shortcut. Each macro has a specific shortcut that you can use to quickly repeat the action.

If you use Excel to record a macro, you’ll reduce the time it takes to create or edit a spreadsheet, speeding up your workflow in the process.

How to Record a Macro in Excel

The easiest way to create a new macro in Microsoft Excel is to record it using the Macro Recorder tool, which you can use in Excel on Windows or Mac. Unfortunately, it isn’t possible to record a macro in Excel Online. 

1. To record a new macro in Excel, open a new or existing workbook. In the Developer tab on the ribbon bar, select the Record Macro button. Alternatively, press the Alt + T + M + R keys on your keyboard.

1. In the Record Macro window, you can set a name for your macro to identify its purpose in the Macro name box, as well as provide a description for other users in the Description box. You can also add a shortcut key (such as Ctrl + T) to assign the new macro to a keyboard shortcut.

1. In the Store macro in drop-down menu, you can set where you’d like to save the macro once it’s recorded, such as This Workbook (to save it to the open workbook), New Workbook (to save it to a new workbook), or Personal Macro Workbook (to allow you to use it in multiple workbooks). Select the OK button to begin recording once you’ve confirmed your choices.

1. Once you select OK, the Excel Macro Recorder will be in recording mode. Each action you perform, from clicking a button to editing a cell, will be recorded. Perform the actions you wish to record as a macro at this point, then select the Stop Recording button in the Developer tab once you’re done.

Running, Editing or Deleting Existing Microsoft Excel Macros

Depending on the save location you selected in the Record Macro window, your recorded Macro will be ready to run in your open workbook or in a newly opened workbook.

1. To run, edit, or delete the macro you’ve created, select Developer > Macros from the ribbon bar.

1. In the Macro window, a list of available macros to run in your open workbook will be listed. To run the macro, select it from the list, then select the Run button. You can also use the keyboard shortcut you selected when you created the macro to run it instead.

1. To make changes to the recorded macro instead, select the Edit button. This will open the Excel VBA editor, allowing advanced users to edit the VBA code and change how the macro runs. VBA beginners may find it easier to simply delete the macro and record it again.

1. To delete the macro, select it from the list, then select the Delete button.

1. Excel will ask you to confirm that you want to delete the macro. Select Yes to confirm this. Once deleted, you’ll need to record the macro again using the steps listed above.

Saving Excel Files with Recorded Macros

Excel workbooks are typically saved in the XLSX file format (or XLS for workbooks created in Excel 2007 and older). This file type supports most Excel data, but excludes any saved Excel macros.

To save an Excel file with recorded macros, you’ll need to use the XLSM file format instead.

1. To save an Excel file as a macro-enabled workbook, select File > Save As > Browse. 

1. In the Save As window, select Excel Macro-Enabled Workbook (*.xlsm) from the drop-down menu. Choose a location to save the file, then select the Save button to save it.

1. When you open the macro-enabled Excel file on another PC or Mac, you may need to authorize Excel to run any included macros first. Select the Enable Macros button to do this.

Sharing Excel Files with Recorded Macros

Excel macros are useful, but they also include potential security risks. If you open an Excel file containing macros from a source that you don’t recognize or trust, then you’re allowing that file to run dangerous code on your PC.

Because of this, online email providers like Gmail automatically block users from sending XLSM (macro-enabled Excel workbook) files to other users. If this happens, you may be able to use file sharing services like Google Drive to share it online with other users.

If you want to share your macro-enabled Excel file with another user nearby, then you could also look at local file transfer methods to share it with another PC or Mac, or with other devices like smartphones.

Macro-enabled Excel files can be packaged with viruses or other malware, so if you open an Excel file that you don’t trust, you may need to scan for malware afterwards to ensure that your PC isn’t compromised. Or scan the file itself before opening it.

Advanced Excel Tips and Tricks

Recording a macro is just one Excel trick that can help you save time, but there are other Excel features that can make you more productive as well. Power users might be interested in using Excel to scrape data online, while data analysts might be curious about how to use COUNTIFS, SUMIFS and AVERAGEIFS for extensive data analysis.

If you prefer to work as a team, or you’re struggling with a complicated Excel formula, you can also collaborate on Excel spreadsheets using a shared workbook. You may find that Google Sheets is a better option for online collaboration, however, with many of the same functions and features.

Related posts

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo xafido erayga sirta ah ee Excel File

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida Loo Sameeyo Calaamadaha Erayga laga bilaabo xaashida faafinta ee Excel

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

• Hagaha Dhammaan Kordhinta Faylka Excel & Waxa ay ula jeedaan

• Sida loo Helo Qiimaha Iswaafajinta gudaha Excel

• Sida Loo Sameeyo Liiska Hoos-u-dhaca ee Excel

• Sida Taariikhaha Looga Jaro Excel

• Sida Loogu Beddelayo Inta u dhaxaysa Waraaqaha Shaqada ee Excel

• Sida Loo Sameeyo Kaarka Salaan ee MS Word

• Sida Looga Daro Baararka Cilada ee Excel

• Sida loo Helo loona Xisaabiyo Range gudaha Excel

• Sida loo isticmaalo Sparklines gudaha Excel

• Sida Loo Bedelo Taariikhda Kooxda Microsoft

• Sida Loo Sameeyo Liiska hubinta gudaha Excel

• Sida loo isticmaalo VLOOKUP gudaha Excel

• Sida loo kala saaro Magacyada Hore iyo Dambe ee Excel