How to Add a Check Mark or Tick Mark Symbol in Excel

Learn several different methods of adding a checkmark or tick mark symbol into your Excel spreadsheets. ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: bit.ly/excelch... #excel #exceltutorials #microsoft365

[@teacheme]

A very simple way to add ticks etc would be to change the column to wingdings 2 font then use the formula =IF(A1=>5, "P","O") finally change the heading font back to its original one.

[@lizastufflococucs6200]

It types in Wingdings so can't confirm it's typed correctly. Should it be type formula then format column to wingdings?

[@sherylchapman4168]

Thanks! I’ve always wondered how to do it. Microsoft took something simple and made it hard. I use checklists all the time, but could not do them in Excel.

[@shrutiganpati3913]

Best to make tickmark it's so simple and easier thanks

[@soniadeakin9133]

So helpful - thank you!

[@zhenxinsu]

that is the most wonderful video i have seen, thank you very much.

[@ouahibabela8986]

I can’t express my joy thanks thanks thanks thanks

[@ginaestrosos652]

very helpful

[@debzydeb3530]

I am so happy I found this Chanel. Very informative and explanation is clear. Love it!!!

[@sjallmyfandoms9044]

I use Wingdings 2’s capital P for my monthly checklists in Excel. To create a new checklist/month, copy the worksheet and rename the tab, then select the entire column of checks and hit delete = new month ready to go! I also use capital X when a check list item is not applicable that month = looks like a O with a slash through it.

[@cmyers7807]

Great information!! Wish you could have talked a little slower and slower on where to click at. I am pleased to have found this video. Thank you, for sharing your knowledge.

[@AtMyHappyPlace]

You can change the speed to go slower in KZbin.

[@rides1230]

@Harry Moorehouse Go to the Settings icon (wheel like icon on the lower left of the video), a pop up menu will show. Click on Playback and click on .75 or .5, whichever suits you.

[@BIBLICAL640]

Im totally excited! May God bless you sir!

[@Ro-bx6ss]

Awesome teaching.

[@imarithkongtho]

This is an amazing video for me to learn the Excel tools. Many thanks.

[@HamdanYouTuber]

Thanks for sharing. Grretings form Indonesia

[@dekebell3307]

Thanks so much for sharing this!

[@MjMojo]

Excellent training

[@pompadutta15]

Thank you so much for your guidance...Grateful ever..🙏

[@mjmann2402]

This is great! Thank you.

[@favoritestanley5732]

Very good and helping

[@catatoa]

Thanks

[@som5718]

Best video

[@MM-lq2dr]

Your video was very helpful, thank you!

[@mohamedibrahimkala4797]

Very helpful

[@FaizanReacts]

This video very help fully,,

[@user-of5et4yj9k]

Perfect! Thank you !! Very very useful

[@lawrencekazibwe9751]

Thanks alot Boss, it has been very informative

[@ibrahimabdeltawab6418]

Amazing! Thanks so much

[@Jarbeeable]

Very helpful! Thank you! How can I tie the Developer Control Checkbox to the row? In your example, let’s say I want to sort the data by the Sales column. But in sorting, I want the Checkboxes to remain with the sorted Sales. So far, I’ve discovered the Checkboxes are figures rather than cell entries, so I haven’t been able to sort and have the Checkboxes remain connected with the rows in which they are placed. I hope you can share a solution. I want the Control Checkbox so any user of the spreadsheet just has to click in the box, rather than know how to input Wingdings etc.

[@juliesmith1937]

So helpful! Thank you :)

[@cicciogrecia]

That's good. But, let's say I want to filter only the rows where it has been ticked. How do you do that?

[@bandaid7808]

There's a way you can sort the columns on the left along the checkboxes?

[@lizastufflococucs6200]

Maybe sort by P or O so reverse alphabetical. I tried it and yes it worked.

[@susuvekerekere563]

Very cool 😎.😉👍. Always wondered.

[@ancientruinsofazerbaijan932]

I have added the checkboxes as shown, but the formula does not work, what can be an issue please?I used not ActiveX but form checkboxes, the formula exactly as shown with $ signs etc. i also tried with ActiveX just now, also not adding, but when I deleted the boxes and instead changed the formula to "=X", instead of "=TRUE" it of course worked. I think something i am doing in the checkbox is not correct but what?

[@nandanbm892]

GREAT ❤️

[@salmaalaa6158]

very good

[@wuhank]

for some reason i am not able to drag down the check box it won't work for me

[@mohamedaslammansoor1784]

How to get (show) the total number of check / Tick marks pls?

[@janettajohnson858]

I need help with my business in excell

[@loragokiel4368]

Yes this tutor simpel

[@lizastufflococucs6200]

What is the difference between the the check box for Forms Control vs Active X?

[@blessatron225]

If it’s “greater than 6”, but then you say “seven or higher” right after, what if the number is 6 and a half? I’m pretty sure 6.5 is greater than 6. 4:11

[@rudrakshrajpoot2712]

IS EXCEL SHEET NUMBER PAR TICK KAR DIYE LEKIN JAS KISKA NAME HAI TO US PAR TICK KAISE HOGA TICK KAISE HO GYE

[@raccoon874]

a simpler way is to not give bonuses to the minions

[@imkemmy7860]

B.z

[@realkiki132]

쿵쿵짝