Haddii aad abuurayso xaashi is dhexgal ah, waxa laga yaabaa inaad u baahato liiska hoos u dhaca si isticmaalayaashu ay u kala doortaan ikhtiyaarada. Taas awgeed, waxaad raaci kartaa casharkan si aad u abuurto liiska hoos u dhaca ee Microsoft Excel ama Google Sheets^{(create a drop-down list in Microsoft Excel or Google Sheets)} . Waxaad samayn kartaa hal iyo sidoo kale liiska hoos-hoosaadka ee buul leh iyadoo la kaashanayo hagahan.

Sida luqadaha barnaamijyada kala duwan, waa suurtogal in lagu daro bayaanka haddii kale xaashida Excel sidoo kale. Aynu ka soo qaadno inaad u abuurayso xaashida faafinta dadka ay tahay inay doortaan doorashooyin kala duwan iyadoo loo eegayo shuruudo kala duwan. Xilligan oo kale, waxaa habboon in la isticmaalo liiska hoos-u-dhaca si aad dadka u siiso wax ka badan hal doorasho.

Sida loo sameeyo liiska hoos u dhaca ee Excel

Si aad u abuurto liiska hoos u dhaca ee Excel , raac talaabooyinkan-

1. Dooro unug meesha aad rabto inaad ku muujiso liiska hoos-u-dhaca.
2. Tag Xogta> Xaqiijinta Xogta.
3. Ka dooro Liiska Allow menu.
4. Ku qor^(Write) ikhtiyaarkaaga sanduuqa Source .
5. Badbaadi isbeddelkaaga.

Si aad u bilowdo, waxaad u baahan tahay inaad doorato unug ku jira xaashida faafintaada halkaasoo aad rabto inaad ku muujiso liiska hoos u dhaca. Intaa ka dib, ka beddel tabka Home una beddel ^{(Home )}xogta^{(Data )} . Qaybta Qalabka Xogta^{(Data Tools)} , dhagsii badhanka Xaqiijinta Xogta^{(Data Validation )} , oo dooro isla doorkii mar kale.

Hadda, balaadhi Allow liiska hoos-hoosaadka, oo dooro Liiska^(List) . Kadibna, waxaad u baahan tahay inaad mid ka dib qorto dhammaan xulashooyinka. Haddii aad rabto inaad soo bandhigto AA, BB, iyo CC tusaale ahaan, waxaad u baahan tahay inaad sidan u qorto-

AA,BB,CC

Dhib malahan inta dooro ee aad rabto inaad bixiso, waxaad u baahan tahay inaad ku kala saarto jumlad. Ka dib markii in, dhagsii badhanka OK. Hadda, waa inaad heshaa liiska hoos-u-dhaca ee sidan-

Waxaad sidoo kale ku dari kartaa fariin qalad ah. Waxay u muuqataa marka isticmaalayaashu isku dayaan inay galaan qiime ka duwan oo aan ahayn xulashooyinka la bixiyay. Taas awgeed, u gudub tabka Digniinta^{(Error Alert )} Cilada, oo qor fariintaada. Raac casharkan si aad ugu darto fariimaha khaldan ee Excel^{(add error messages in Excel)} .

Sida loo abuuro liiska hoos-hoosaadka ee Excel

Haddii aad rabto inaad xogta ka hesho qaar ka mid ah menus-hoosaadka ama unugyada oo aad ku muujiso ikhtiyaarrada ku habboon unug kale, halkan waa waxaad samayn karto.

Waxaad u baahan tahay inaad furto isla daaqadda Xaqiijinta Xogta^{(Data Validation )} oo aad doorato Liiska ^(List)Allow menu. Markan, waxaad u baahan tahay inaad geliso safafka sanduuqa Source sida tan-

=$A$1:$A$5

Marka loo eego kala duwanaanshiyahan, liiska hoos-u-dhicida ee cusub waxa uu muujin doonaa isla dookhyada ku qoran unugyada A1 ilaa A5.

Sida loo sameeyo liiska hoos u dhaca ee Google Sheets

Si aad u abuurto liiska hoos-u-dhaca ee Google Sheets , raac tillaabooyinkan-

1. Dooro unug oo tag Data > Data .
2. Dooro Liiska alaabta.
3. Qor alaabtaada ama fursadahaaga.
4. Badbaadi isbeddelkaaga.

Marka hore, dooro unug ku jira xaashida xaashida oo guji Xogta^{(Data )} xagga sare ee navigation-ka. Taas ka dib, ka dooro xulashada ansaxinta xogta^{(Data validation )} liiska.

Hadda, balaadhi liiska hoos-u-dhaca Shuruudaha , oo dooro ^{(Criteria )}Liiska walxaha^{(List of items)} . Marka xigta, waxaad u baahan tahay inaad ku qorto dhammaan xulashooyinka ama alaabta sanduuqa madhan.

Ugu dambeyntii, dhagsii badhanka Save si aad u muujiso liiska hoos-u-dhaca ee unugga.

Sida Excel , Google Sheets waxay tusinaysaa digniin ama fariin khalad ah gelida xogta aan sax ahayn. Sida caadiga ah, waxay muujinaysaa fariin digniin ah waxayna u ogolaataa isticmaalayaasha inay qoraan qoraal caadi ah. Haddii aad rabto inaad ka ilaaliso isticmaalayaasha inay galaan xogta aan sax ahayn, waxaad u baahan tahay inaad doorato ikhtiyaarka diidmada gelinta^{(Reject input )} ee daaqadda xaqiijinta xogta .^{(Data validation)}

Sida loo abuuro liiska hoos-hoosaadka ee Google Sheets

Waxay ku dhowdahay inay la mid tahay Excel , laakiin magaca ikhtiyaarka ayaa ka duwan. Waxaad u baahan tahay inaad liiska ka^{(List from a range )} doorato xulasho kala duwan oo ka mid ah liiska shuruudaha^{(Criteria )} oo aad geliso kala duwan si waafaqsan baahidaada. Waxaad geli kartaa goob sidan oo kale ah-

=$A$1:$A$5

Waxay ku tusi doontaa dhammaan qoraallada A1 ilaa unugyada A5 ee liiskan hoos-u-dhaca ah.

Waa kaas! Waxaan rajeynayaa inay ku caawin doonto.

How to create a drop-down list in Excel and Google Sheets

If you are creating an interactive spreadѕheet, you may need a drop-down list so that users can сhooѕe between optiоns. For thаt, you can follow this tutorіal to create a drop-down list in Microsoft Excel or Google Sheets. You can create a single as well as a nested drop-down menu with the help of this guide.

Like various programming languages, it is possible to include the if-else statement in an Excel spreadsheet as well. Let’s assume that you are creating a spreadsheet for people who should select different options according to various criteria. At such a moment, it is wise to use a drop-down list so that you can provide more than one choice to the people.

How to create a drop-down list in Excel

To create a drop-down list in Excel, follow these steps-

1. Select a cell where you want to show the drop-down menu.
2. Go to Data > Data Validation.
3. Select the List from the Allow menu.
4. Write down your options in the Source box.
5. Save your change.

To get started, you need to select a cell in your spreadsheet where you want to show the drop-down list. After that, switch from the Home tab to the Data tab. In the Data Tools section, click the Data Validation button, and select the same option again.

Now, expand the Allow drop-down list, and select List. Then, you need to write down all the options one after one. If you want to display AA, BB, and CC as the examples, you need to write them like this-

AA,BB,CC

No matter how many options you want to provide, you need to separate them by a comma. After going that, click the OK button. Now, you should find a drop-down list like this-

You can add an error message as well. It appears when users try to enter a different value other than the given options. For that, switch to the Error Alert tab, and write down your message. Follow this tutorial to add error messages in Excel.

How to create a nested drop-down list in Excel

If you want to obtain data from some existing drop-down menus or cells and display options accordingly in a different cell, here is what you can do.

You need to open the same Data Validation window and select List in the Allow menu. This time, you need to enter a range in the Source box like this-

=$A$1:$A$5

According to this range, the new drop-down list will show the same options that are written in the A1 to A5 cells.

How to create a drop-down list in Google Sheets

To create a drop-down list in Google Sheets, follow these steps-

1. Select a cell and go to Data > Data validation.
2. Select the List of items.
3. Write down your items or options.
4. Save your change.

At first, select a cell in a spreadsheet and click the Data from the top navigation bar. After that, select the Data validation option from the list.

Now, expand the Criteria drop-down menu, and select List of items. Next, you need to write down all the options or items in the empty box.

At last, click the Save button to show the drop-down list in a cell.

Like Excel, Google Sheets shows a warning or error message for entering invalid data. By default, it shows a warning message and allows users to write custom text. If you want to prevent users from entering invalid data, you need to choose the Reject input option in the Data validation window.

How to create a nested drop-down list in Google Sheets

It is almost the same as Excel, but the name of the option is different. You need to select the List from a range option from the Criteria list and enter a range according to your needs. You can enter a field like this-

=$A$1:$A$5

It will show all the texts from A1 to A5 cells in this drop-down list.

That’s it! Hope it will help you.

Related posts

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

• Sida loogu xidho Google Sheets iyo Excel

• Sida loo sameeyo garaaf xariiq qaloocan gudaha Excel iyo Google Sheets

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

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

• Isku xidh Unugyada u dhexeeya Xaashiyaha iyo Buugaagta Shaqada ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loogu isticmaalo Habka Madow gudaha Google Docs, Sheets, iyo Slides

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

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

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

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida Zero loogu daro lambarka hortiisa ee Excel iyo Google Sheets

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Sida loo dejiyo xadka Character ee Excel iyo Google Sheets

• Sida loo tiriyo unugyada madhan ama madhan ee Excel iyo Google Sheets

• 5 Shaqooyinka Qoraalka Xaashiyaha Google ee aad u baahan tahay inaad ogaato