Sida aan wada ognahay Microsoft Excel waxaa loo isticmaalaa in lagu ururiyo xogta safafka iyo tiirarka. Mararka qaarkood, waxaan rabnaa in aan xaddidno oo kaliya xogta qaarkood si ay ugu jiraan xaashida. Waxaan rabnaa inaan tuurno qalad, marka qof uu isku dayayo inuu galo xogta ka soo horjeeda ansaxinta. Tusaale ahaan, haddii aad rabto inaad u dejiso xaddidaadda habkaas oo kale, unug gaar ah oo Excel ah waa inuu aqbalo kaliya qoraalka 10 xaraf oo dherer ah, markaa waxaad si fudud u qeexi kartaa ansaxinta unuggaas gudaha Excel .

Ku dar fariimaha khaladka ah gudaha Excel

Mar kasta oo uu qof galo qoraal ka baxsan xaddidaadda, waxaad tusi kartaa farriinta khaladka ah ee sharraxaysa ansixinta. Maqaalkan waxaan ku ogeysiin doonaa sida loo abuuro ama loogu daro farriimaha khaldan ee Excel .

Marka hore, dooro unugga ( E6 tusaale ahaan) oo aad rabto inaad dejiso xaddidaadda. Guji^(Click) tab xogta iyo hoosta qaybta Qalabka Xogta ^{(Data Tools)},^(Data) dhagsii Xaqiijinta Xogta.^{(Data Validation.)}

Sanduuqa wada hadalka Xaqiijinta Xogta^{(Data Validation)} , dhagsii Settings tab. Hoos-u- dhaca Allow , waxaad ku qeexi kartaa xogta laga oggol yahay unugga. Waxay noqon kartaa tiro dhan, Taariikh^(Date) , jajab tobanle^(Decimal) ama xitaa qaacido gaar ah ayaa lagu dari karaa.

Xaaladeena, maadaama aan u baahanahay inaan dejino xaddidaadda in ka badan 10 xaraf, dooro Length Text. ^{(Text Length. )}Haddii aadan rabin inaad qalad u tuurto unug madhan, dabadeed calaamadi Iska daa^{(Ignore blank )} sanduuqa jeeg-bixinta maran.

Hadda, gudaha Xogta^(Data) hoos u dhaca, dooro hawlwadeenka. Arrinkayaga, waxaan kala doortay.^(between.)

Sida aan u dooranay 'inta u dhaxaysa', waxaan u baahanahay inaan qeexno kala duwanaanshaha ugu yar^(Minimum) iyo kan ugu^(Maximum) badan. Waxaan dooran karnaa tirada unugga ama waxaan si toos ah u gelin karnaa qiyamka. Kiiskeena, geli '1' ugu yaraan^(Minimum) iyo '10' ugu badnaan^(Maximum) .

Hadda, dhagsii tabka Fariinta Input . ^{(Input Message)}Tabkan waxa loo isticmaalaa in lagu qeexo fariinta la tusi doono marka unugga la doorto iyo jeeggaasi Tus fariinta gelinta marka unugga la doorto. ^{(Show input message when cell is selected.)}Sheeg Ciwaanka^{(Title )} iyo Fariinta^{(Message )} la tusi doono marka unugga la doorto. Ciwaanka^(Title) waxa lagu muujiyay si geesinimo leh oo fariinta waxa loo muujiyay sida qoraalka caadiga ah ee ka hooseeya ciwaanka.

Hadda, waa waqtigii la abuuri lahaa Fariinta Khaladka^{(Error Message)} ee Excel . Guji^(Click) tab digniinta qaladka^{(Error Alert)} . Hubi ikhtiyaarka "muuji digniinta qaladka ka dib marka xogta aan sax ahayn la geliyo" si aad uga fogaato fariinta qaladka ah in lagu muujiyo xog kasta oo la soo geliyo unugga.

Lagu taliyay: Talooyin  ^{(Recommended: )}Microsoft Excel si aad u badbaadiso wakhtiga oo aad si dhakhso leh u shaqeyso

Hoos - u-dhaca Style , dooro nooca khaladka ee la muujinayo. Waxay noqon kartaa Joojin^(Stop) , Digniin^(Warning) ama Xog^{(Information)} . Geli^(Enter) Fariinta Ciwaanka^(Title) iyo Cilada^{(Error Message)} si loogu muujiyo cilada soo baxday. Guji "OK" oo ansaxintaada waxaa loo dejiyay unugga la doortay ee Excel .

Markaad geliso qoraalka ka yar 10 xaraf, markaa fariin qalad ah lama muujinayo. Laakiin, marka aad geliso qoraalka in ka badan 10 xaraf oo ka baxsan xaddidaaddayada, markaa farriinta khaladka ah ayaa lagu muujiyey sida hoose.

Waxaad arki kartay in ciwaanka iyo fariinta aad dejisay ay ku jirto fariinta khaladka ah. Waxaa la soo jeediyay in la yeesho ciwaanka macnaha leh iyo farriinta sharraxaysa ansixinta iyo xaddidaadda.

Tani waa habka ugu fudud ee lagu abuuri karo farriimaha khaldan gudaha Excel.^{(This is the easiest way to create error messages in Excel.)}

How to add Error Messages in Excel

As we all know Microsoft Excеl is used to collect data in rows and columns. Sometimes, we want to restriсt to only cеrtain data to be in the sheet. We want to thrоw an error, when somеone is tryіng tо enter data аgainst the validation. For example, if you want to set the restrіction in such way that, a particular cell in Excеl should only acсept text of 10 characters in length, then you can specify the validation for that cell іn Excel easily.

Add Error Messages in Excel

Whenever anyone enters text beyond the restriction, you can show the error message explaining the validation. In this article I will let you know how to create or add error messages in Excel.

First, select the cell (E6 in our example) which you want to set the restriction. Click on the Data tab and under Data Tools section, click Data Validation.

In Data Validation dialog box, click on Settings tab. In the Allow drop-down, you can specify what data is allowed in the cell. It can be a whole number, Date, Decimal or even custom formula can be added.

In our case, as we need to set the restriction for more than 10 characters, select Text Length. If you do not want to throw an error for empty cell, then check Ignore blank check-box.

Now, in Data drop-down, select the operator. In our case, I selected between.

As we have chosen ‘between’, we need to specify Minimum and Maximum range. We can either select the cell range or enter the values directly. For our case, enter ‘1’ in Minimum and ‘10’ in Maximum.

Now, click on the Input Message tab. This tab is used to specify the message to be shown when the cell is selected and for that check Show input message when cell is selected. Specify the Title and Message to be shown when the cell is selected. Title is shown in bold and the message is shown as normal text below the title.

Now, it is the time to create the Error Message in Excel. Click on Error Alert tab. Check the option “Show error alert after invalid data is entered” to avoid error message being shown for every data entered in the cell.

Recommended: Microsoft Excel Tips to Save Time and Work Faster

In Style dropdown, select the error type to be shown. It can be Stop, Warning or Information. Enter the Title and Error Message to be shown in the error pop up. Click “OK” and your validation has been set for the selected cell in Excel.

When you enter the text which has less than 10 characters, then no error message is shown. But, when you enter the text more than 10 characters beyond our restriction, then error message is shown as below.

You could see that the title and message you set is shown in the error message. It is suggested to have the meaningful title and message which explains the validation and restriction.

This is the easiest way to create error messages in Excel.

Related posts

• Farriimaha Khaladaadka ah ee ugu caansan Windows 10 & sida loo hagaajiyo

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sideen u hagaajin karaa Runtime Error 1004 gudaha Microsoft Excel?

• Sida loo saaro #NAME? Khaladka Excel?

• Sida Looga Daro Baararka Cilada ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Hagaaji Soo Celinta Xogta. Sug dhowr ilbiriqsi oo isku day inaad mar kale gooyso ama nuqul ka sameyso qaladka Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

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

• Hagaaji Farimaha Snapchat Ma soo diri doono Cilad

• Sida loo isticmaalo shaqada ISODD ee Excel

• Hagaaji Koodadka iyo Fariimaha Khaladka Discord

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

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Hagaaji qaladka Excel stdole32.tlb gudaha Windows 10

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?