Xaashiyaha Google^{(Google Sheets)} waa codsi shabakad ku salaysan oo bilaash ah iyo beddelka caanka ah ee Microsoft Excel . Qalabku wuxuu ogolaanayaa in si fudud loo abuuro, loo cusboonaysiiyo, oo wax looga beddelo xaashiyaha. Waxay u adeegtaa sidii qalab iskaashi oo heersare ah oo kuu oggolaanaya inaad ku darto dad badan oo aad rabto oo aad Google Sheets la tafatirto dadka kale isku mar. Qalabka khadka waxa uu awood kuu siinayaa in aad si wada jir ah uga wada shaqayso wakhtiga dhabta ah mashruuca ku jira xaashida faafinta iyada oo aan loo eegin meel kasta oo aad joogto. Si aad isaga kaashato Google Sheets waa in aad si fudud u gujisaa badhanka La wadaag^(Share) oo halkaas waxa aad u ogolaanaysaa saaxiibadaa, asxaabtaada, ama qoyskaa in ay wax ka beddelaan xaashida faafintaada.

Markaad ka shaqaynayso xaashida faafinta Google^{(Google Spreadsheet)} ee la wadaago , waxaa laga yaabaa inaad rabto isticmaalayaasha kale inay galaan xogta xaddidan oo keliya gudaha unugyadeeda. Si aad uga fogaato in kuwa kale soo galaan qiyamka khaldan ee unugyada, waxaa laga yaabaa inaad rabto inaad ku darto curiyaha kontoroolka garaafyada sida liiska hoos u dhaca^{(drop-down menu)} kaas oo la mid ah sanduuqa liiska u oggolaanaya dadka inay galaan kaliya qiimayaasha laga heli karo liiska la bixiyay. Marka laga reebo taas, liiska hoos-u-dhacu wuxuu u adeegaa sidii hab caqli badan oo hufan oo lagu galo xogta.

Taas marka la yiraahdo, liiska hoos-u-dhaca ama liiska hoos-u-dhaca waa hab la hagaajiyay si loo hubiyo in dadku ay u buuxiyaan kaliya qiyamka unugyadaaga si la mid ah sidaad filayso. Sida Excel ,  Google Sheets wuxuu kuu oggolaanayaa inaad si fudud u abuurto liiska hoos-u-dhaca xaashiyahaaga. Intaa waxa dheer, waxa ay awood ku siinaysa in aad qayb ahaan wax ka badasho liiska hoos-hoosaadka haddii aad rabto in aad wax ka beddesho liiska xulashada unugyada. Maqaalkan, waxaan si faahfaahsan u sharaxnay sida loo sameeyo liiska hoos-u-dhaca ee Google Sheets oo wax ka beddelo isla.

Ku samee liiska hoos-u-dhaca ee Google Sheets

Bilaw^(Launch) Google Sheets

Fur xaashi cusub ama fur faylka jira ee xaashida.

Dooro unug meesha aad rabto inaad ka abuurto liiska hoos u dhaca. Waxa kale oo aad dooran kartaa koox unugyo ah, tiir dhan, ama saf ah.

U gudub liiska xaashida oo guji ikhtiyaarka ^(Sheets)Xogta.^(Data.)

Ka dooro Xaqiijinta Xogta^{( Data Validation)} ee liiska hoos-u-hoosaadka ah. Daaqada Xaqiijinta Xogta ayaa^{(Data Validation)} soo baxaysa oo leh dhawr ikhtiyaar oo wax lagu beddeli karo.

Meesha ugu horeysa ee daaqada Xaqiijinta Xogta waa ^{(Data Validation)}kala duwanaanta Unugyada^{(Cell range)} oo si toos ah loo buuxiyo iyadoo lagu salaynayo unugyada la doortay. Waxaad u bedeli kartaa kala duwanaanshaha qiimo cusub adiga oo si fudud u gujinaya astaanta miiska ee garoonka Range Range^{(Cell Range)} .

Goobta labaad ee daaqada Xaqiijinta Xogta waa ^{(Data Validation)}Shuruudaha^{( Criteria )} kaas oo leh liis xulashooyin kala duwan oo ku jira liiska hoos-u-dhaca u gaar ah. Shuruudaha waxaa^(Criteria) ku jira xulashooyin sida Liis laga soo bilaabo kala duwan, Liiska walxaha, Lambarka, Qoraalka,^{(List from a range, List of items, Number, Text, )} iyo Taariikhda. ^{( Date. )}

• Liis ka kala duwan: Doorashadani waxay kuu ogolaanaysaa inaad samayso liis qiimayaal ah oo laga soo saaray xaashiyo kala duwan ama liiska qiyamka unugyo kala duwan oo isla xaashi ah.
• Liiska walxaha: Tani waxay noo ogolaanaysaa inaan abuurno liiska qiimaha qoraalka. Waxa lagu galaa goobta tafatirka oo ay u kala qaybsan yihiin hakad.
• Number : Xulashadani^(Option) ma abuurto liiska hoos u dhaca taa beddelkeed waxay hubinaysaa in gelitaanka liiska hoos-u-u-dhicistu ku dhaco tiro cayiman.
• Qoraal: Xulashadani^(Option) ma abuurayso liiska hoos u dhaca taa beddelkeed waxay hubinaysaa in gelitaanku u yahay qaab qoraal ah oo habboon.
• Taariikhda: Doorashadani^(Option) ma abuurayso liiska hoos u dhaca taa beddelkeed waxay hubisaa in taariikhda la galiyay ay sax tahay ama ay ku jirto xad gaar ah.
• Qaabka gaarka^{(Custom Formula)} ah waa: Doorashadani ma abuurayso liiska hoos u dhaca taa beddelkeeda waxay hubisaa in unugga la doortay uu isticmaalo qaacido cayiman isticmaale.

Marka xogta lagu darayo liiska la geliyo, dooro ikhtiyaarka Tus liiska hoos^{(Show dropdown list)} u dhaca unugga. Doorashada doorashadan waxay hubinaysaa in qiyamku ay ka muuqdaan unugyada.

Waxa kale oo aad dooran kartaa waxa la samaynayo marka qof galo xog aan sax ahayn oo aan ku jirin liiska adiga oo dooranaya ikhtiyaarka badhanka raadiyaha. Waxaad dooran kartaa inaad muujiso ikhtiyaarka digniinta^{(Show warning)} ama Diid^{(Reject input)} ikhtiyaarka gelinta xogta aan ansax ahayn. Xulashada Diidmada^{(Reject Input)} kuuma ogola inaad geliso qiime kasta oo aan ku jirin liiskaaga hoos-u-dhaca. Dhanka kale,  Muuji^{(Show warning)} ikhtiyaarka digniinta ayaa kuu ogolaanaya inaad geliso xogta aan sax ahayn ee aan ku jirin liiskaaga laakiin soo bandhigaysa fariinta digniinta ee xaashida.

Doorashada ugu dambeysa ee daaqada dejinta waa Muuqaalka. ^{(Appearance.)}Doorashadani waxay siinaysaa tilmaan isticmaalaha qiyamka ama xogta ay geli karaan unugyada. Si aad u hawlgeliso kaaliyahan, dooro ikhtiyaarka Tus qoraalka caawimada ansaxinta ee^{(Show validation help text)} ag yaal goobta Muuqda^(Appearance) . Kadib markaad doorato ikhtiyaarka, ku qor tilmaamaha raba inaad dadka siiso waxa ku saabsan qiyamka ay dooran karaan gudaha xadka unugyada.

Guji Keydi^(Save) si aad u isticmaasho isbedelada

Wax ka beddel liiska hoos-u-dhaca ee Google Sheets

Si aad wax badan ugu darto liiska ama aad alaabta uga saartid liiska hoos-u-hoosaadka raac tillaabooyinka hoose

U gudub Xogta^{( Data)} oo ka dooro ansaxinta xogta^{( Data validation)} liiska hoos-u-hoosaadka ah.

Dooro unugyada oo beddel walxaha gelitaanka.

Guji Keydi^(Save) si aad u isticmaasho isbedelada

Waa intaas.

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

Google Sheets is a free web-based application and a popular alternative to Microsoft Excel. The tool allows to easily create, update, and modify spreadsheets. It serves as an excellent collaborative tool allowing you to add as many people as you want and edit Google Sheets with others at the same time. The online tool enables you to work jointly in real-time on a project in the same spreadsheet irrespective of wherever you are located. To collaborate on Google Sheets one has to simply click a Share button and there you are allowing your friends, colleagues, or family to edit your spreadsheet.

When working on a shared Google Spreadsheet, you may want other users to enter only restricted data within its cells. To avoid others entering wrong values within cells, you may want to add a graphical control element like the drop-down menu which is similar to a list box that would allow people to enter only those values available from a given list. Apart from that, the drop-down list serves as a smart and more efficient method to enter data.

That being said, a drop-down list or a pulldown menu is a streamlined way to ensure that people fill only the values into your cells in the exact same manner as your expecting. Like Excel,  Google Sheets allows you to easily create a drop-down menu to your Sheets. Additionally, it enables you to make partial changes to the drop-down list in case you want to modify the selection list in the cells.  In this article, we explain in detail how to create a drop-down menu in Google Sheets and modify the same.

Create a drop-down menu in Google Sheets

Launch Google Sheets

Open a new spreadsheet or open an existing spreadsheet file.

Select a cell where you want to create a drop-down list. You can also select a group of cells, an entire column, or a row.

Navigate to Sheets menu and click on the option Data.

Select Data Validation from the drop-down menu. A Data Validation window pops up with several options to customize.

The first field in the Data Validation window is the Cell range which is automatically filled based on the selected cells. You can change the range to a new value by simply clicking on a table icon in the Cell Range field.

The second field in the Data Validation window is the Criteria which has a list of various options in its own drop-down menu. The Criteria contains options like List from a range, List of items, Number, Text, and Date. 

• List from a range: This option allows you to create a list of values that have been retrieved from different sheets or the list of values from different cells on the same sheet.
• List of items: This allows us to create a  list of text values. They are entered in the edit field separated by commas.
• Number: This Option doesn’t create a drop-down list instead makes sure that the entry to the drop-down menu falls within a specific numeric range.
• Text: This Option doesn’t create a drop-down list instead makes sure that the entry is in a proper textual format.
• Date: This Option doesn’t create a drop-down list instead makes sure if the date entered is valid or comes in a certain range.
• Custom Formula is: This option does not create a drop-down list instead makes sure the selected cell uses a user-specified formula.

Once the data that is to be included in the list is entered, select the option Show dropdown list in cell. Selecting this option ensures that the values appear in the cells.

You can also choose what has to be done when someone enters an invalid data which is not present on the list by selecting the options with a radio button. You can choose to have either Show warning option or Reject input option on invalid data. The Reject Input option doesn’t allow you to enter any value which is not present on your drop-down list. On the other hand,  Show warning option allows you to enter the invalid data which is not on your list but displays the warning message in the sheet.

The last option in the setting window is the Appearance. This option gives a hint to the user on what values or data they can enter in the cells. To activate this assistant, select the option Show validation help text beside the Appearance field.  After you select the option, type the instructions that want to give people about what values they can choose within the cell range.

Click Save to apply the changes.

Edit the drop-down list in Google Sheets

To add more values to the list or remove items from the drop-down menu follow the below steps

Navigate to Data and select Data validation from the drop-down menu.

Select the cells and change the items in the entry.

Click Save to apply changes.

That’s all.

Related posts

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

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

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

• Sida loo geliyo sanduuqa qoraalka gudaha Google Docs

• Sida loo sameeyo Google Slides loop iyada oo aan la daabicin

• Sida lakabka iyo kooxaynta Sawirada Google Docs

• Sida loogu daro Watermark gudaha Google Docs

• Sida loo qoro Screenplay gudaha Google Docs

• Sida looga saaro Gridlines dukumeenti xaashida Google

• Sida loo rakibo oo looga saaro add-ons gudaha Google Docs

• Sideed ugu duubtaa qoraalka sawirka Google Docs

• Sida loo barbar dhigo labada dukumeenti ee Google Docs

• Wax-ku-darka Google Docs-ka ugu fiican ee qorayaasha madax-bannaan

• Sida loogu daro Google Keep Notes Google Docs

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

• Sida loo abuuro Indent Hang ee Microsoft Word iyo Google Docs

• U beddelo Word, PowerPoint, Excel Documents PDF adoo isticmaalaya Google Docs

• Sida loo midoobo oo loo kala saaro unugyada Google Doc Table

• Sida loo labanlaabo booska Google Docs

• Sida loogu daro xuduud Google Docs