Marka doorsoomayaal xogeedyo badan lagu habeeyo mashruuca, wakhtiga iyo xadhkaha boosaska doorsoomayaashaas waa inay isku mid ahaadaan. Sidan oo kale, waa inaad xakameysaa xogta dadka kale soo galaan. Taasi waa marka aad u baahan tahay Xaqiijinta Xogta^{(Data Validation)} . Microsoft Excel ayaa shaqadan ka dhigaysa mid fudud.

Sida loogu isticmaalo Xaqiijinta Xogta ^{(Data Validation)}Unugyada Excel^{(Excel Cells)}

Sifada ansaxinta xogta ee Excel waxay u ogolaataa isticmaaluhu inuu xakameeyo waxa la geli karo unug ama uu bixiyo liis horay loo sii qeexay oo ah galitaanka la aqbali karo si meesha looga saaro khaladaadka ama khaladaadka suurtagalka ah. Waxaa lagu dabaqaa xeerar lagu qeexay tabka ' Data ' ee Excel, oo hoos yimaada liiska ribbon. Nidaamku wuxuu ku lug leeyahay:

1. Geli Faahfaahinta Xaqiijinta
2. Habee Fariinta Gelitaanka
3. Habee digniinta Khaladka

Mid ka mid ah isticmaalka ansaxinta xogta ugu caansan waa in la sameeyo liiska hoos u dhaca.

1] Geli Faahfaahinta Xaqiijinta

Fur faylka Microsoft Excel , dooro unugyada aad rabto inaad xaddido.

Tag tab ' Data ' ee ku yaal liiska Ribbon.

Hoosta ' Qalabka Xogta^{(Data Tools)} ' dooro ' Xaqiijinta Xogta^{(Data Validation)} 'doorashada.

Marka uu furmo daaqada Xaqiijinta Xogta^{(Data Validation)} , waxaad arki doontaa dhawr kontaroolo. Waxaad hubin kartaa in nambarada lagu daray kaliya ama dherer qoraal gaar ah, sida lambarka taleefanka.

Tusaale ahaan, aan dooranno ' Waqtiga^(Time) ' si aan u kala dooranno waqtiyada aan furnayn.

Sheeg wakhtiga Bilawga iyo ^{(Start Time)}wakhtiga^(Time) dhamaadka .

2] Habee Fariinta Gelitaanka

Hadda, u beddel ' Fariinta Input^{(Input Message)} ' tab.

Habbee fariinta gelinta ah ee aad rabto inay muuqato marka wax ka duwan la geliyo waxa la cayimay.

3] Habee digniinta Khaladka

U beddel tabka ' Digniinta Qaladka '^{(Error Alert)}

Geli^(Enter) fariinta aad rabto inaad soo muuqato ama si fudud u dooro inaad ilaaliso khaladaadka.

Dhamaadka, ku dhufo badhanka 'OK'.

Hadda, marka mid ka mid ah unugyada la doorto, qof kastaa wuxuu arki doonaa xasuusinta fariinta gelinta halka waqtiyada la geli karo.

Si kastaba ha ahaatee, marka wakhtiga la galiyay uu ka baxsan yahay xadka, fariin qalad ah ayaa la soo bandhigi doonaa.

Marka la soo koobo, ansaxinta xogta^(Data) waxay soo bandhigi kartaa fariinta isticmaalaha u sheegaya waxa la ogol yahay iyo waxa aan ahayn!

Akhri soo socda^{(Read next)} : Sida loo duubo Macro si loo sameeyo badhanka Shortcut ee qaabab badan oo Word iyo Excel ah.

How to apply Data Validation to Cells in Microsoft Excel

When multiple data variables аre accommodated in a proјect, the timе and spatial grids of thoѕe vаriables must be identical. As such, you must cоntrol the data other people enter. That’s when yoυ need Data Validation. Microsoft Excel makes this job simple.

How to use Data Validation for Excel Cells

Data validation feature in Excel lets a user control what can be entered into a cell or provide a predefined list of acceptable entries to eliminate possible mistakes or errors. It is applied via rules defined in Excel’s ‘Data’ tab, under the ribbon menu. The process involves:

1. Enter Data Validation Details
2. Customize Input Message
3. Customize Error Alert

One of the most common data validation uses is to create a drop-down list.

1] Enter Data Validation Details

Open the Microsoft Excel file, select the cells you would like to limit.

Go to the ‘Data’ tab located on the Ribbon menu.

Under the ‘Data Tools’ select ‘Data Validation’ option.

When the Data Validation window opens, you’ll see several controls. You can make sure that only numbers are added or a particular text length, like a phone number.

In the case of our example, let us select ‘Time’ to choose between the times we are open.

Specify the Start Time and the End Time.

2] Customize Input Message

Now, switch to ‘Input Message’ tab.

Customize the input message that you would like to appear when something different is entered against what has been specified.

3] Customize Error Alert

Switch to the ‘Error Alert’ tab.

Enter the message you would like to appear or simply choose to keep the defaults.

In the end, hit the ‘OK’ button.

Now, when one of the cells is selected, everyone will see the input message reminder where timings can be entered.

However, when the timing entered is outside the range, an error message will be displayed.

In short, Data validation can display a message to a user telling them what is allowed and what is not!

Read next: How to record a Macro to create Shortcut Button for Multiple Formats in Word and Excel.

Related posts

• Sida loo Quful Unugyada Microsoft Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Microsoft Excel waxay fureysaa xaashi maran halkii faylka

• Sida foormulada loogu qariyo xaashiyaha Microsoft Excel

• Hagaaji Microsoft Excel furitaanka daaqad banaan

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel

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

• Sida loo isticmaalo Nooca Xogta Juquraafiga ee Excel

• Sida loo sameeyo sanduuqa sanduuqa Microsoft Excel

• Sida loo qariyo xaashiyaha, unugyada, tiirarka, iyo qaaciidooyinka gudaha Excel

• Sida loo isticmaalo Gelida Xogta laga soo qaatay muuqaalka sawirka ee Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Jadwalka xogtaada Excel

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

• Casharka Microsoft Excel, ee Bilowga ah

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

• Sida loo tirtiro qiyamka unugyada laakiin ku ilaali qaacidooyinkaaga, gudaha Microsoft Excel