^(Advanced)Isticmaalayaasha sare ee Microsoft Office waxay rabi doonaan in tab horumariyaha^{(Developer tab)} lagu soo bandhigo Ribbon of Word ama Excel mar walba. Si kastaba ha ahaatee, tabkaas laguma tuso default, taas oo macnaheedu yahay in gacanta lagu dari karo. Samaynta tan waa mid aad u fudud, laakiin qof kastaa ma garan karo sida loo sameeyo. Waxaad isticmaali kartaa goobaha barnaamijka, Siyaasadda Kooxda^{(Group Policy)} ama Tifaftiraha Diiwaangelinta^{(Registry Editor)} si aad tan u sameyso.

Anigoo tan maskaxda ku hayna, waxaan go'aansanay inaan sharaxno sida loogu daro Tab^{(Developer Tab)} - sameeyaha aagga Ribbon ee ^(Ribbon)Xafiiska Microsoft^{(Microsoft Office)} .

Maxaa loo istcmaalay Tab-sameeyaha?

• Orod amarrada XML:^{(Run XML commands:)} Mid ka mid ah sifooyinka wanaagsan ee Microsoft Office waa awoodda lagu socodsiiyo amarrada XML . Isticmaalayaasha sare^(Advanced) iyo ganacsiyada ayaa inta badan adeegsada amarradan.
• Samee codsiyo ku shaqeeya Microsoft Office qalabyada:^{(Develop applications to run in Microsoft Office tools:)} Haa, waa suurtogal inaad abuurto codsigaaga si aad ugu shaqeyso Microsoft Office baahiyahaaga.
• Qor oo maamul Macros: ^{(Write and run Macros:)} Microsoft waxa ay u sahashay isticmaalayaasha in ay wax ku qoraan oo ku socodsiiyaan makros-ka suite-keeda xafiiska^(Office) wakhtiga ugu dheer. Macros waa xoog badan yihiin, oo sidaas oo kale, waxay noqon karaan khatar maadaama socodsiinta Macro ay la mid tahay socodsiinta khadka koodka. Waxaad arkaysaa, Macros ayaa loo isticmaalay in lagu rakibo malware iyo fayrasyada kale ee khatarta ah Windows muddo dheer hadda, iyo in kasta oo la hagaajiyay tallaabooyinka amniga ee Microsoft , Macros weli waa khatar haddii loo isticmaalo si qaldan.
• Isticmaal kontaroolada ActiveX: ^{(Use ActiveX controls: )}Internet Explorer waxa uu leeyahay nidaam fur-in u gaar ah oo lagu magacaabo ActiveX Controls , kaas oo sidoo kale loo isticmaali karo Microsoft Office iyada oo loo marayo Tab-Developer^{(Developer Tab)} . Haddii aad ogtahay waxaad samaynayso, ka dib horay u soco oo isticmaal ActiveX dukumeentigaaga Xafiiska^(Office) . Si kastaba ha noqotee, haddii aad ku cusub tahay kan, waxaan kuu soo jeedineynaa inaad ku rakibto kaliya ActiveX aaladaha ilo la aamini karo. Si la mid ah Macros , waxaan fahamsanahay in ActiveX ay noqon karto isha lagu rakibo software xaasidnimo ah kombiyuutarkaaga.

Sida loogu daro tab horumariyaha^(Developer) gudaha barnaamijyada Xafiiska^(Office)

OK, marka marka Tab-sameeyaha^{(Developer Tab)} lagu daro Word ama Excel Ribbon , way sii muuqan doontaa ilaa gacanta laga saaro. Nidaamku waa sahlan yahay:

1. Bilaw Word ama Excel
2. Furo liiska Options
3. Fur Ribbon Customize
4. Daar horumariyaha

Aan uga hadalno arrintan si faahfaahsan.

1] Fur liiska Options

Talaabada ugu horeysa ee lagu daro tababbarka horumarinta ee barnaamijyada ^{(Developer Tab)}Microsoft Office waa inaad gujiso File , ka dibna u gudub Xulashada^(Options) . Waa inaad aragto dhawr doorasho, laakiin mid keliya ayaa liiska lagamamaarmaan u ah arrintan.

2] Furo Ribbon Customize

Qaybtan hore ayaan uga hadalnay. Waxaad aragtaa, haddii wax ka maqan yihiin Ribbon ee Microsoft Office , markaa fursadaha waa, tani waa meesha aad ka heli doonto. Si la mid ah waa haddii aad rabto in aad ka saarto sifo ka mid ah Ribbon .

3] Daji horumariyaha

Kadib markaad doorato Customize Ribbon , waa inaad aragto laba qaybood. Mid bidixda ah waxaa loo yaqaan amarrada caanka ah^{(Popular Commands)} , mid kalena midigta waxaa loo yaqaan ' Main Tabs ' . Waxaad u baahan doontaa inaad hoos eegto Tabs Main^{(Main Tabs)} for Developer oo aad hubiso inaad gujiso gudaha sanduuqa madhan.

Ugu dambeyntii, dhagsii badhanka OK , oo isla markaaba, Tab-sameeyaha^{(Developer Tab)} waa inuu ka soo muuqdaa Ribbon -ka .

Sida loogu daro horumariyaha^(Developer) tab gudaha Word iyadoo la adeegsanayo Siyaasadda Kooxda^{(Group Policy)}

Si aad ugu darto tab horumariyaha ^(Developer)Word adigoo isticmaalaya Siyaasadda Kooxda^{(Group Policy)} , raac tillaabooyinkan:

1. Riix  Win+R si aad u furto Run .
2. Ku qor gpedit.msc  oo taabo  badhanka Gelida  .^(Enter )
3. U soco si aad u  habayso Ribbon ^{(Customize Ribbon )} qaabaynta  isticmaale^{(User Configuration)} .
4. Laba jeer ku dhufo  tabka Horumariyaha Bandhiga ee goobta Ribbon ^{(Display Developer tab in the Ribbon )} .
5. Dooro  ikhtiyaarka karti  leh.^(Enabled )
6. Guji  badhanka OK 

Si aad wax badan uga barato tillaabooyinkan, sii wad akhriska.

Si aad u bilawdo, taabo  Win+R  si aad u furto Run Quick, ku qor  gpedit.msc , oo ku dhufo  badhanka Gelida  . ^(Enter )Kadib, u gudub jidkan:

User Configuration > Administrative Templates > Microsoft Word 2016 > Word Options > Customize Ribbon

Halkan waxa aad ku arki kartaa goob loo yaqaan  tab Developer tab ee Ribbon-ka^{(Display Developer tab in the Ribbon)} . Waxaad u baahan tahay inaad laba jeer gujiso oo aad doorato  ikhtiyaarka karti ^(Enabled ) leh.

Kadib, dhagsii  badhanka OK  si aad u badbaadiso isbeddelka.

Sida loogu daro horumariyaha^(Developer) tab gudaha Word adoo isticmaalaya Registry

Si aad ugu darto tab horumariyaha ^(Developer)Word adoo isticmaalaya Registry , raac talaabooyinkan:

1. Riix  Win+R si aad u muujiso Run-gudbinta
2. Ku qor  regedit > taabo  badhanka Gelida ^(Enter ) >guji  badhanka Haa ^(Yes ) .
3. U^(HKCU) gudub  Microsoft  HKCU  .
4. Midig ku dhufo  Microsoft > New > Key oo u  magacow xafiis^(office) ahaan .
5. Midig ku dhufo  office > New > Key oo u  magacow 0⁽⁰⁾ .
6. Midig ku dhufo  0 > New > Key oo magaca  erey^(word) ahaan u dhig .
7. Midig ku dhufo  word > New > Key oo u  magacow ikhtiyaari^(options) ahaan .
8. Xulashada midig-guji  options > New > DWORD (32-bit) Value .
9. U magacaw sida  qalab horumariye^{(developertools)} .
10. Laba jeer ku dhufo si aad u dejiso xogta  Qiimaha sida ^(Value)1 .
11. Guji  badhanka OK  oo dib u bilow kombayutarkaga.

Aynu si faahfaahsan u eegno tillaabooyinkan.

Marka hore, taabo  Win+R , ku  qor regedit^(regedit) , oo taabo  badhanka Gelida  . ^(Enter )Kadib, dhagsii  ikhtiyaarka Haa ^(Yes ) ee isla markiiba UAC . Marka xigta, u gudub jidka soo socda:

HKEY_CURRENT_USER\Software\Policies\Microsoft

Midig ku dhufo  Microsoft > New > Key , una magacow sidii  xafiis^(office) .

Kadibna, raac habka isku midka ah si aad u abuurto fure-hoosaad hoostiisa furaha  xafiiska ^(office ) oo u  magacow 16.0^(16.0) . Ku celi tillaabooyinka isku midka ah si aad u abuurto fure-hoosaad ka hooseeya furaha  16.0  oo wac  kelmad^(word) .

Midig ku dhufo  word > New > Key  oo u  magacow ikhtiyaari^(options) ahaan . Taas ka dib, midig-guji  options > New > DWORD (32-bit) Value  oo magaca u dhig  qalab horumariye^{(developertools)} .

Marka la sameeyo, laba jeer guji si aad u dejiso xogta  Qiimaha sida ^(Value)1 .

Guji  badhanka OK  oo dib u bilow kombayutarkaga.

Sida loogu daro horumariyaha^(Developer) tab gudaha Excel iyadoo la adeegsanayo Siyaasadda Kooxda^{(Group Policy)}

Si aad ugu darto tab horumariyaha gudaha ^(Developer)Excel adoo isticmaalaya Siyaasadda Kooxda^{(Group Policy)} , raac tillaabooyinkan:

1. Ka raadi gpedit.msc  gudaha sanduuqa raadinta Taskbar.
2. Guji^(Click) natiijada raadinta shakhsi ahaaneed.
3. U soco si aad u  habayso Ribbon ^{(Customize Ribbon )} qaabaynta  isticmaale^{(User Configuration)} .
4. Laba jeer ku dhufo  tabka Horumariyaha Bandhiga ee goobta Ribbon ^{(Display Developer tab in the Ribbon )} .
5. Dooro  ikhtiyaarka karti  leh.^(Enabled )
6. Guji  badhanka OK 

Aynu si faahfaahsan u dul istaagno tillaabooyinkan.

Marka hore, waxaad u baahan tahay inaad furto Tifaftiraha Siyaasadda Kooxda Deegaanka^{(Local Group Policy Editor)} . Taas awgeed, ka raadi  gpedit.msc  sanduuqa raadinta Taskbar oo guji natiijada raadinta shakhsi ahaaneed.

Marka la furo, u gudub jidka soo socda:

User Configuration > Administrative Templates > Microsoft Excel 2016 > Word Options > Customize Ribbon

Laba jeer ku dhufo  tabka Soo-saareyaasha Bandhigga ee ku yaal ^{(Display Developer tab in the Ribbon )} goobta Ribbon oo dooro  ikhtiyaarka karti ^(Enabled ) leh.

Guji  badhamada Codso ^(Apply ) iyo  OK  si aad u badbaadiso isbeddelka oo dib u billow Excel^(Excel) si aad u hesho  tab horumariyaha  .^{(Developer )}

Sida loogu daro horumariyaha^(Developer) tab gudaha Excel iyadoo la isticmaalayo Registry

Si aad ugu darto tab horumariyaha gudaha ^(Developer)Excel adoo isticmaalaya Diiwaanka^(Registry) , raac talaabooyinkan:

1. Ka raadi  regedit  sanduuqa raadinta Taskbar
2. Guji^(Click) natiijada raadinta shakhsi ahaaneed oo guji  badhanka Haa ^(Yes ) .
3. U^(HKCU) gudub  Microsoft  HKCU  .
4. Midig ku dhufo meel banaan>  New > Key oo u dhig magaca  xafiis^(office) ahaan .
5. Ku celi^(Repeat) tillaabooyinkan si aad u abuurto fure-hoosaad oo u  magacow 0⁽⁰⁾ .
6. Midig ku dhufo  0 > New > Key oo magaca u dhig  heer sare^(excel) .
7. Midig ku dhufo  excel > New > Key oo u  magacow xulashooyinka^(options) .
8. Midig ku dhufo  options > New > DWORD (32-bit) Value .
9. U magacaw sida  qalab horumariye^{(developertools)} .
10. Laba jeer guji si aad u dejiso xogta  Qiimaha sida ^(Value)1 oo guji  OK  badhanka.
11. Dib u kici kombayutarkaga

Si aad wax badan oo faahfaahsan uga ogaato tillaabooyinkan kor lagu soo sheegay, sii wad akhriska.

Marka hore, waxaad u baahan tahay inaad furto Tifaftiraha Diiwaanka^{(Registry Editor)} . Taas awgeed, ka raadi  regedit  sanduuqa raadinta Taskbar , guji natiijada raadinta shakhsi ahaaneed oo guji  ikhtiyaarka Haa  .^(Yes )

Kadib, u gudub jidka soo socda:

HKEY_CURRENT_USER\Software\Policies\Microsoft

Haddii aad hore u dejisay goobtan barnaamijyada kale ee Xafiiska^(Office) , waxa aad ka heli kartaa  furaha-hoosaadka  xafiiska  ee furaha ^(office )Microsoft  . Xaaladdaas, waxaad u baahan tahay inaad u gudubto tallaabada 6aad. Haddii kale, waxaad u baahan tahay inaad gacanta ku abuurto dhammaan furayaasha hoose ee Excel . Si taas loo sameeyo, midig-guji  Microsoft > New > Key  oo u  magacow xafiis^(office) ahaan .

Kadibna, ku celi tillaabooyinkan si aad u abuurto fure-hoosaad hoos yimaada  xafiiska^(office)  oo u  magacow 16.0^(16.0) . Mar kale samee taas si aad u abuurto fure-hoosaad ka hooseeya 16.0 oo ugu  magacow excel^(excel) . Marka ugu danbeysa, ku celi tillaabooyinkan si aad u abuurto fure-hoosaad kale oo ugu magacow  xulashooyin^(options) .

Marka la sameeyo, waxaad u baahan tahay inaad abuurto qiime REG_DWORD . Taas awgeed, midig-guji  options > New > DWORD (32-bit) Value  oo u  magacow aaladaha horumariyaha^{(developertools)} .

Laba jeer guji si aad u dejiso xogta  Qiimaha sida ^(Value)1  oo guji  OK  badhanka.

Ugu dambeyntii, dib u kici kombuyutarkaaga si aad u hesho isbeddelka.

Xusuusin: ^(Note: ) Waxaad u baahan tahay inaad  soo dejiso qaab-dhismeedka Siyaasadda Kooxda ee Xafiiska  si aad u isticmaasho habka GPEDIT ee lagu xusay maqaalka. Waxyaabo kale oo muhiim ah ayaa ah in kasta oo ay leedahay  Microsoft Excel16 ama  Microsoft Word 16 , waxaad sidoo kale codsan kartaa isla jaangooyooyinka Microsoft 365 ama Office 2021/19 sidoo kale.

Waxaan rajeynayaa in tani ay ku caawineyso.

How to add Developer tab in Word and Excel Office programs

Advanсed users оf Microsoft Оffice will want to haνe the Developer tab showcased on the Ribbon of Word or Excel programs at all times. However, that tab is not shown by default, which means it can be manually added. Doing this is pretty simple, but not everyone might know how to do it. You can use the Program’s settings, Group Policy or the Registry Editor to do this.

With this in mind, we have decided to explain how to add the Developer Tab to the Ribbon area in Microsoft Office.

What is the Developer Tab used for?

• Run XML commands: One of the cool features of Microsoft Office is the ability to run XML commands. Advanced users and businesses primarily use these commands.
• Develop applications to run in Microsoft Office tools: Yes, it is possible to create your application to run in Microsoft Office for your own needs.
• Write and run Macros: Microsoft has made it possible for users to write and run macros in its Office suite for the longest time. Macros are powerful, and as such, they can be dangerous since running a Macro is similar to running a line of code. You see, Macros have been used to install malware and other dangerous viruses on Windows for a long time now, and despite improved security measures from Microsoft, Macros are still a threat if used in the wrong way.
• Use ActiveX controls: Internet Explorer has its own plug-in system called ActiveX Controls, which can also be used in Microsoft Office via the Developer Tab. If you know what you are doing, then go on ahead and make use of ActiveX in your Office document. However, if you are new to this, we suggest only installing ActiveX tools from a trusted source. Similar to Macros, we understand that ActiveX can be a source for installing malicious software on your computer.

How to add Developer tab in Office programs

OK, so once the Developer Tab is added to the Word or Excel Ribbon, it will stay visible until manually removed. The process is simple:

1. Launch Word or Excel
2. Open the Options menu
3. Open Customize Ribbon
4. Activate Developer

Let us talk about this issue in a more detailed manner.

1] Open the Options menu

The first step into adding the Developer Tab to Microsoft Office programs is to click on File, then navigate to Options. You should see several choices, but only one on the list is essential in this respect.

2] Open Customize Ribbon

We have spoken about this section before. You see, if something is missing from the Ribbon in Microsoft Office, then chances are, this is where you will find it. The same goes if you want to remove a feature from the Ribbon.

3] Activate Developer

After you have selected Customize Ribbon, you should see two sections. One on the left is called Popular Commands, and another on the right is called Main Tabs. You will want to look under Main Tabs for Developer and be sure to click inside of the empty box.

Finally, click the OK button, and right away, the Developer Tab should appear on the Ribbon.

How to add Developer tab in Word using Group Policy

To add Developer tab in Word using Group Policy, follow these steps:

1. Press Win+R to open the Run prompt.
2. Type gpedit.msc and press the Enter button.
3. Navigate to Customize Ribbon in User Configuration.
4. Double-click on the Display Developer tab in the Ribbon setting.
5. Choose the Enabled option.
6. Click the OK button.

To learn more about these steps, continue reading.

To get started, press Win+R to open the Run prompt, type gpedit.msc, and hit the Enter button. Then, navigate to this path:

User Configuration > Administrative Templates > Microsoft Word 2016 > Word Options > Customize Ribbon

Here you can see a setting called the Display Developer tab in the Ribbon. You need to double-click on it and select the Enabled option.

Then, click the OK button to save the change.

How to add Developer tab in Word using Registry

To add Developer tab in Word using Registry, follow these steps:

1. Press Win+R to show the Run prompt.
2. Type regedit > press the Enter button > click the Yes button.
3. Navigate to Microsoft in HKCU.
4. Right-click on Microsoft > New > Key and name it as office.
5. Right-click on office > New > Key and name it as 0.
6. Right-click on 0 > New > Key and set the name as word.
7. Right-click on word > New > Key and name it as options.
8. Right-click options > New > DWORD (32-bit) Value.
9. Name it as developertools.
10. Double-click on it to set the Value data as 1.
11. Click the OK button and restart your computer.

Let’s check out these steps in detail.

First, press Win+R, type regedit, and press the Enter button. Then, click the Yes option in the UAC prompt. Next, navigate to the following path:

HKEY_CURRENT_USER\Software\Policies\Microsoft

Right-click on Microsoft > New > Key, and name it as office.

Then, follow the same method to create a sub-key under the office key and name it as 16.0. Repeat the same steps to create a sub-key under the 16.0 key and call it word.

Right-click on word > New > Key and name it as options. Following that, right-click on options > New > DWORD (32-bit) Value and set the name as developertools.

Once done, double-click on it to set the Value data as 1.

Click the OK button and restart your computer.

How to add Developer tab in Excel using Group Policy

To add Developer tab in Excel using Group Policy, follow these steps:

1. Search for gpedit.msc in the Taskbar search box.
2. Click on the individual search result.
3. Navigate to Customize Ribbon in User Configuration.
4. Double-click on the Display Developer tab in the Ribbon setting.
5. Choose the Enabled option.
6. Click the OK button.

Let’s delve into these steps in detail.

First, you need to open the Local Group Policy Editor. For that, search for gpedit.msc in the Taskbar search box and click on the individual search result.

Once it is opened, navigate to the following path:

User Configuration > Administrative Templates > Microsoft Excel 2016 > Word Options > Customize Ribbon

Double-click on the Display Developer tab in the Ribbon setting and choose the Enabled option.

Click the Apply and OK buttons to save the change and restart Excel to find the Developer tab.

How to add Developer tab in Excel using Registry

To add Developer tab in Excel using Registry, follow these steps:

1. Search for regedit in the Taskbar search box.
2. Click on the individual search result and click the Yes button.
3. Navigate to Microsoft in HKCU.
4. Right-click on empty space > New > Key and set the name as office.
5. Repeat these steps to create a sub-key and name it 0.
6. Right-click on 0 > New > Key and set the name as excel.
7. Right-click on excel > New > Key and name it as options.
8. Right-click on options > New > DWORD (32-bit) Value.
9. Name it as developertools.
10. Double-click on it to set the Value data as 1 and click the OK button.
11. Reboot your PC.

To know more about these above-mentioned steps in detail, continue reading.

First, you need to open the Registry Editor. For that, search for regedit in the Taskbar search box, click on the individual search result and click the Yes option.

Then, navigate to the following path:

HKEY_CURRENT_USER\Software\Policies\Microsoft

If you have already set this setting for other Office programs, you may find the office sub-key under the Microsoft key. In that case, you need to skip to the 6th step. Otherwise, you need to create all the sub-keys manually for Excel. To do that, right-click on Microsoft > New > Key and name it as office.

Then, repeat these steps to create a sub-key under office and name it as 16.0. Do that again to create a sub-key under 16.0 and name it as excel. One last time, repeat these steps to create another sub-key and name it as options.

Once done, you need to create a REG_DWORD value. For that, right-click on options > New > DWORD (32-bit) Value and name it as developertools.

Double-click on it to set the Value data as 1 and click the OK button.

Finally, reboot your computer to get the change.

Note: You need to download the Group Policy template for Office in order to use the GPEDIT method mentioned in the article. Another important thing is that although it says Microsoft Excel16 or Microsoft Word 16, you can apply the same settings on Microsoft 365 or Office 2021/19 programs as well.

Hope this helps.

Related posts

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

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

• Geli xaashida shaqada ee Excel Word Doc

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Si degdeg ah ugu qor nambarada Word iyo Excel

• Sida loo Kooxeeyo Waraaqaha Shaqada ee Excel

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Fix Excel wuxuu sugayaa codsi kale si loo dhamaystiro ficil OLE

• Si degdeg ah ugu beddelo Xaashiyaha shaqada ee Excel

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

• Sida Loo Sameeyo Liiska hubinta gudaha Excel

• Sida loo rakibo oo loo isticmaalo add-ins gudaha Microsoft Word iyo Excel ee iPadka

• Sidee Loo Xidhaa Ama Loo Furaa Unugyada Excel? (2022)

• Sida loo nadiifiyo kiliboodhka Excel, Word ama PowerPoint

• Sida loo duubo Macro gudaha Excel

• 3 siyood oo erayga sirta ah loo ilaaliyo File Excel

• Sida Loo Abuuro Oo Loo Badbaadiyo Xaashiyaha Faafinta Excel ee Microsoft Office ee Android

• Sida looga saaro erayga sirta ah ee Excel File

• Sida loo shaandheeyo xogta gudaha Excel

• U qaabee qoraalka sidii Superscript ama Subscript ahaan Word, Excel, PowerPoint