Waxaa jira sababo badan oo laga yaabo inaad rabto inaad ku isticmaasho calaamadda jeeg ee Excel . Xaaladaha qaarkood, waxa laga yaabaa inaad rabto hab aad ku dhejiso sawirka calaamadaynta unug qoraal kale leh ama unug keligiis ah. 

Siyaabo badan oo is dhexgal ah oo loo isticmaalo calaamadaha hubinta ee Excel waxay noqon karaan in la aqbalo soo-jeedinta xulashada isticmaale ama hab toos ah si loo muujiyo in hawsha ama safka la dhammeeyay ay run tahay.

Iyadoo aan loo eegin sida aad rabto inaad u isticmaasho, waxaa jira siyaabo aad ku dhex dari karto calaamadaynta xaashidaada Excel .

Jid-gaabyada Kiiboodhka ee Calaamadaha Hubinta

Haddii waxa kaliya ee aad u baahan tahay ay tahay inaad geliso calaamadda unugga, iyada oo qayb ka ah qoraal hadda jira ama keligiis, adiga oo isticmaalaya furayaasha furaha kiiboodhka^{(using keyboard shortcuts)} ayaa ah habka ugu fudud ee loo isticmaalo calaamadda jeeg ee Excel .

Waxaa jira laba xaraf oo Wingdings2 ah oo si fiican uga shaqeeya gelinta calaamadaha hubinta ee Excel . Si aad kuwan u isticmaasho, waxaad u baahan doontaa inaad midigta gujiso unugga oo aad qaabka font^{(change the font style)} u beddesho Wingdings2 .

Marka unugga la qaabeeyo, kaliya hoos u qabo Shift furaha oo taabo P. Keyboodhka gaaban ee halkan waa Shift + P.

Tani waxay gelisaa unugga calaamadda calaamadaynta. Waxa kale oo aad tan gelin kartaa dhamaadka sadar kasta oo qoraalka ku jira unugga sidoo kale.

Dabeecad kale waa ka soo horjeedka calaamadda jeegga, “x” halkaas oo aad ku muujin karto jawaab taban. Qabo furaha Shift oo tabo O. Kiiboodhka gaaban ee halkan waa Shift + O.

Tani waxay gelinaysaa unugga xarfo "x". 

Liis degdeg ah oo aad u baahan tahay inaad ku darto jawaab togan ama taban, labadan calaamadood ee Excel waxay sameeyaan khiyaamada.^(Excel)

Koodhadhka kiiboodhka kale ee Wingdings2^{(Wingdings2 keyboard)} waxa ka mid ah kuwan soo socda.

• Shift + R : Calaamadee sanduuqa dhexdiisa
• Shift + Q , Shift + S , Shift + T : Noocyada kala duwan ee "x" gudaha sanduuqa
• Shift + V, Shift + U : Hababka kala duwan ee "x" gudaha goobada

Haddii aad u baahan tahay kala duwanaansho badan, ka dib u qaabee unugyada font Wingdings beddelkeeda.^(Wingdings)

Tani waxay kuu ogolaanaysaa inaad isticmaasho afar furayaasha kiiboodhka jeeg ee suurtogalka ah. 

• ALT 0252 : Calaamadeynta caadiga ah
• ALT 0254 : Calaamadee sanduuqa dhexdiisa
• ALT 0251 : Heerka "x" sumadda
• ALT 0253 : "x" gudaha sanduuqa

Si aad u isticmaasho koodka kiiboodhka, hoos u qabo furaha ALT ka dibna ku qor afarta lambar adigoo isticmaalaya suufka nambarada^{(numeric pad)} .

Sida aad arki karto waxaa jira xulashooyin iyo qaabab badan oo loo isticmaalo isticmaalka calaamadaha hubinta ee Excel .

Bedelkeeda door^(Prefer) bida inaad isticmaasho shaqada CHAR ? Dhib maaha. Kaliya^(Just) dooro unugga aad rabto inaad calaamadda dhigto oo ku qor mid ka mid ah hawlaha soo socda.

• =CHAR(252) : Calaamadda caadiga ah
• =CHAR(254) : Calaamadee sanduuqa dhexdiisa
• =CHAR(251) : Halbeegga “x” sumadda
• =CHAR(253) : "x" gudaha sanduuqa

Riix Gelida^(Enter) oo calaamaddu waxay ka soo muuqan doontaa unuggaas.

Geli Calaamadaha Calaamadaha

Waxaa jira dhowr calaamadood oo calaamado calaamad ah oo aad geli karto adigoo isticmaalaya font-ka Segoe UI^{(Segoe UI Symbol)} . Si tan loo sameeyo, ka dooro Gelida^(Insert) liiska oo ka dooro calaamadda ribbon^(Symbols) . Kadib, ka dooro calaamada^(Symbol) hoos u dhaca.

Tani waxay furi doontaa daaqada Calaamadaha . ^(Symbol)U beddel xarfaha hoos u dhaca una beddel calaamadda Segoe ^(Font)UI^{(Segoe UI Symbol)} .

Haddii aad dhex-gudbiso liiska calaamadaha fartan, waxaad arki doontaa dhawr nooc oo calaamado calaamad ah oo ku kala firirsan. Qayb ka mid ah waxay leedahay labada calaamadood ee jeegga iyo qaabka "x" ee hal aag.

Si kastaba ha noqotee, xor u noqo inaad rogto haddii aad rabto inaad isticmaasho qaab ka duwan.

Markaad hesho calaamadda jeegga ee aad rabto, kaliya dooro Geli^(Insert) oo calaamadda waxaa si toos ah loo gelin doonaa unugga Excel ee aad dhigtay cursorka.

Tani waa hab sahlan oo lagu isticmaalo calaamadda jeegga ee Excel haddii aadan xasuusan karin mid ka mid ah koodka oo aad jeclaan lahayd inaad ka baadho noocyo badan oo kala duwan.

Ku dheji calaamadda jeegga ee Excel

Haddii aadan rabin dhibka koodka ama font-ka, sida ugu dhaqsaha badan oo fudud ee loo isticmaalo calaamadda jeegga ee Excel waa in la koobiyeeyo oo dhajiyo^{(copy and paste it)} .

Haddii aad ka raadiso "check mark" gudaha Google , waxaad arki doontaa calaamad calaamad ah oo marka hore ku taxan natiijooyinka raadinta^{(in search results)} .

Waxaad calaamaddan si sax ah u koobi kartaa natiijada adiga oo iftiiminaya oo riixaya Ctrl + C. Kadib, ku soo celi xaashidaada Excel , dooro unugga meesha aad rabto inaad calaamadda jeeg dhigto, oo ku dheji adigoo riixaya Ctrl + V.

Si toos ah u sax ereyga muhiimka^(Keyword) ah oo leh calaamad sax ah^{(Check Mark)}

Waxaad illoobi kartaa dhammaan calaamadaha ama menu-yada lagu sharraxay kor oo kaliya isticmaal kelmadaada gaarka ah meel kasta oo aad rabto inaad dhigato calaamad.

Tusaale ahaan, waxaad ku abuuri kartaa jawaabta saxda ah ee adiga kuu gaar ah gudaha Excel kaasoo bedelaya eraygaaga muhiimka ah (wax sida "CMARK") oo leh calaamadda calaamadda.

Si tan loo sameeyo, dhig warqad jeeg ah xaashida adiga oo isticmaalaya mid ka mid ah hababka kore. Marka aad hal kaliya ku haysato xaashida, waxaad u isticmaali kartaa qayb ka mid ah sixitaanka tooska ah.

1. Dooro unugga oo koobiy calaamadda jeegga ee ku taal baarka caanaha.

2. Midig ku dhufo unugga oo hubi qoraalka unugga. U fiirso tan dambe.

3. Dooro File , ka dibna Options , ka dibna caddaynta , iyo ugu dambeyntii AutoCorrect ^(Proofing)Options^{(AutoCorrect Options)} .

4. Daaqada AutoCorrect^{(AutoCorrect)} , geli kelmada (sida "CMARK") gudaha goobta Bedelka^(Replace) . Kadib, dooro goobta leh^(With) oo Ctrl + V si aad ugu dhejiso calaamadda calaamadaynta ee aad hore uga soo guurisay baarka caanaha ee Excel .

Dooro Ku dar^(Add) ka dibna OK si aad u dhammayso. 

Hadda, mar kasta oo aad ku qorto "CMARK" oo aad taabo Gelida^(Enter) , qoraalku wuxuu si toos ah u beddeli doonaa calaamad.

Tani waa mid ka mid ah siyaabaha ugu fudud ee loo isticmaalo calaamadda jeeg ee Excel , gaar ahaan haddii aad marar badan isticmaasho oo aadan rabin inaad xasuusato furayaasha kumbuyuutarka, codes, ama wax kale. 

Waa maxay sababta loo isticmaalo Check Marks gudaha Excel?

Waxaa jira sababo badan oo aad u rabto inaad u isticmaasho calaamadda hubinta ee excel. Haddi aad isku dayayso in aad raadraacdo hawlaha mashruuca ama aad dadka ka hesho in ay kuu buuxiyaan sahan-waxaa jira doorashooyin badan.

Dooro habka aad ugu darto calamadaha jeeg ee xaashida adiga kugu haboon.

4 Ways to Use a Check Mark in Excel

There are many reasons you may want to use a check mark in Excel. In some cases, you may just want a way to place a check mаrk image eіther in a cell with other text or in a cell by itself. 

More interactive ways to use check marks in Excel may be to accept selection input from a user or as an automatic way to indicate that a completed task or a row is true.

Regardless of how you intend to use it, there are ways you can integrate check marks into your Excel spreadsheet.

Keyboard Shortcuts for Check Marks

If all you need is to insert a checkmark into a cell, either as part of an existing text or by itself, using keyboard shortcuts is the easiest way to use a check mark in Excel.

There are two Wingdings2 characters that work well for inserting check marks into Excel. To use these, you’ll need to right-click the cell and change the font style to Wingdings2.

Once the cell is formatted, just hold down the Shift key and press P. The keyboard shortcut here is Shift + P.

This will insert a checkmark character into the cell. You can also insert this at the end of any line of text in the cell as well.

Another character is the opposite of a check mark, an “x” where you can symbolize a negative response. Hold down the Shift key and press O. The keyboard shortcut here is Shift + O.

This will insert an “x” character into the cell. 

For a quick list where you need to add a positive or negative answer, these two Excel check marks do the trick.

Other Wingdings2 keyboard codes include the following.

• Shift + R: Check mark in a box
• Shift + Q, Shift + S, Shift + T: Various styles of “x” inside a box
• Shift + V, Shift + U: Various styles of “x” inside a circle

If you need more variety, then format the cells in the Wingdings font instead.

This lets you use four potential check mark keyboard shortcuts. 

• ALT 0252: Standard check mark
• ALT 0254: Check mark inside a box
• ALT 0251: Standard “x” mark
• ALT 0253: “x” inside a box

To use these keyboard codes, hold down the ALT key and then type the four digit number using the numeric pad.

As you can see there are plenty of options and styles to use for using check marks in Excel.

Prefer using the CHAR function instead? Not a problem. Just choose the cell where you’d like to place the symbol and type one of the following functions.

• =CHAR(252): Standard check mark
• =CHAR(254): Check mark inside a box
• =CHAR(251): Standard “x” mark
• =CHAR(253): “x” inside a box

Press Enter and the check mark will appear in that cell.

Insert Check Mark Symbols

There are several check mark symbols you can insert using the Segoe UI Symbol font. To do this, select Insert from the menu and choose the Symbols icon from the ribbon. Then, select Symbol from the dropdown.

This will open the Symbol window. Change the Font dropdown to Segoe UI Symbol.

If you scroll through the list of symbols for this font, you’ll see several check mark styles scattered throughout. One section has both check marks and the “x” style marks in one area.

However, feel free to scroll if you want to use a different style.

When you find the check mark you want, just select Insert and that symbol will be inserted directly into the Excel cell where you placed the cursor.

This is an easy way to use a check mark in Excel if you can’t remember any of the codes and would like to browse from a larger variety of styles.

Paste a Check Mark into Excel

If you don’t want the hassle of codes or fonts, a quick and easy way to use a check mark in Excel is to copy and paste it.

If you search for “check mark” in Google, you’ll see a check mark symbol listed first in search results.

You can copy this symbol right in the results by highlighting it and pressing Ctrl + C. Then, return to your Excel spreadsheet, select the cell where you want to place the check mark, and paste it by pressing Ctrl + V.

Autocorrect a Keyword with a Check Mark

You could forget about all of the symbols or menus explained above and just use your own special phrase wherever you want to place a checkmark.

For example, you can create your own autocorrect response in Excel that replaces your keyword (something like “CMARK”) with the check mark symbol.

To do this, place a checkmark in your sheet using any one of the methods above. Once you have just one in the sheet, you can use it as part of an autocorrect.

1. Select the cell and copy the check mark in the formula bar.

2. Right-click the cell and check the font of the cell. Note this for later.

3. Select File, then Options, then Proofing, and finally AutoCorrect Options.

4. In the AutoCorrect window, enter the word (like “CMARK”) into the Replace field. Then, select the With field and press Ctrl + V to paste the check mark symbol you copied from the Excel formula bar earlier.

Select Add and then OK to finish. 

Now, whenever you type “CMARK” and press Enter, the text will automatically change to a check mark.

This is one of the easiest ways to use a check mark in Excel, especially if you use them often and don’t want to remember keyboard shortcuts, codes, or anything else. 

Why Use Check Marks in Excel?

There are plenty of reasons why you may want to use check marks in excel. Whether you are trying to track project tasks or getting people to fill out a survey for you—there are plenty of options.

Choose the method for adding check marks to your spreadsheet that’s the most convenient for you.

Related posts

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo isticmaalo Excel's What-If Analysis

• Sida Loo Hagaajiyo Safka gudaha Excel

• Isticmaal kiiboodhka si aad u bedesho dhererka safka iyo ballaca tiirka gudaha Excel

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• Sida Loo Geliyo CSV ama TSV Xaashida Shaqada ee Excel

• Sida loo Isticmaalo Tixraacyada Absolute ee Excel

• 4 siyaabood oo Excel loogu badalo Google Sheets

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• Sida loo Furo Word iyo Excel si Badbaado ah

• Sida Looga Saaro Safka Kooban Ee Excel

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

• Sida loo qoro IF Formula/Bayaanka gudaha Excel

• Sida looga saaro Gridlines gudaha Excel

• Goorta la Isticmaalayo Tusaha-Match Bedelkii VLOOKUP ee Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Sida Loo Dhaqaajiyo Columns gudaha Excel

• Sida loo xarfo xarfaha Excel