How to Insert Checkbox in Excel

[@KevinStratvert]

Excel has new checkboxes since I published this video! Find out how to use them: kzbin.info/www/bejne/pqeTdqJrapKGm6ssi=uSbEfx0SENO4XUsi 🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com ⏭ Watch more free Excel tutorial videos: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 In-depth Pivot Table tutorial: kzbin.info/www/bejne/hpWtq6xvapuqpZY

[@MohAnimator]

kevin could you talk about adobe flash please

[@MegaKingOfNoob]

Hey Kevin I want to ask u can u make a vid how to make ur windows 11 computer connect to iPhone I wanna find it if I lost my computer I can just go on my phone to know where’s it is bc I have a bad memory please and thank you

[@devmaniac.official]

Can you suggest any shortcut way to link all cells with respective check boxes at a time. Because it will be very lengthy process if there is more rows over there .

[@lesvogiatzakis3313]

Brilliant! I’ve been wanting checkboxes for years, but never had the chance to investigate it and for it to work out as I don’t use excel that much. Thanks again Kevin.

[@EArockerful]

Your channel might be one of the most interesting ones in the whole internet

[@stereodan7180]

I never thought that checkbox could be so complicated. Interesting.

[@ericrichard4940]

honestly...same here

[@dowhatyouwill]

Much easier in Google Sheets tbh

[@lmfd7373]

yes this is annoying

[@kirkelisa]

Great tutorial Kevin, you are a great teacher. I had to go on line and find out why my "filter" function would not show up. It was not available on the 2019 version 😞Thank you for that simple but powerful check box teaching.

[@UmarAlFarooq]

Kevin king of content. Your explanations are in depth and thorough. Thank you and God bless.

[@dwaipayansarkar2358]

Kevin being My top Excel Man since 1863😂. Love what you do....

[@AndreaAlison]

Hahaha.

[@MoniMeka]

Lmaoooooo @ 1863 🤣🤣🤣🤣🤣

[@mmad3130]

Dude, if you're not rich you should be. Can't say how many time's I've had crappy looking checkboxes all over my screen. You shaped me up in 11:25! Thank You!

[@johannesmp3]

Awesome, I have seen this done by a few people, but they were too fast. You were nice and slow. You're a legend , dude

[@ifeyhome]

Kevin is the Best Microsoft tutor on KZbin!🏆

[@pjohn1435]

As always Kevin, highly informative, thank you for all that you do to keep us relevant.

[@bobbirowlett6728]

You're amazing. I had no idea a checkbox could be used in this fashion. How fun and useful!!! The way you go through your tutorials makes it very easy to understand. Thank you.

[@iz6583]

Simple, but still very clever. Awesome work @Kevin thank you for making us look smarter :)

[@kaninecalms2785]

You are an excellent trainer! Thank you for all of your teachings and hard work. God Bless

[@rjleddin3048]

Nice! I knew excel had checkboxes, but prefer Google sheet’s version as it can snap/center into a cell. That conditional formatting as a percent of total was cool and I’ve never seen that.

[@joukenienhuis6888]

Then you will love the new checkboxes in Excel

[@EthanEmc2]

Maybe Kevin is just a Excel-lent friend we made along the way

[@AyaMama532]

Perfect for my "to do list". Thank you!

[@RankinAuctions]

Love these videos. Practical, useful and efficient. Thanks!

[@CMED-b2t]

Hi Kevin, you're doing a great job sharing, already I have learned a lot from you. I have a challenge for you, "how to create links to hidden forms, specifically if you need to make sure someone has read the instructions before they proceed to complete a form in a separate worksheet.

[@the_legend3185]

Nice! I knew about these but also knew I’d learn something by watching your video. You should do a series on all of the form controls.

[@daisuke1320]

Having a warehouse inventory project. 6:27 This will be so useful for me.thank you

[@billyt7292]

Very Cool tricks with the checkboxes, very easy to follow.

[@lilylomcari1750]

Omg I was just looking at how to make a checkbox in Excel and got wayyyy more cool functions than I expected from this video. Making a doc for my Director and I think this will really impress! Thank you!! 😊

[@mikekasongo8985]

Thanks Kevin. It's always a pleasure to follow your tutorials

[@steverileyretired]

Very Good, Thanks Kevin

[@learningtogetheredu]

As small KZbinr posting similar content I learn a lot from here. Thanks for good the work

[@charalamposkounes5071]

Excellent video. Google sheets is better in checkboxes though

[@tusharjain2811]

Best channel in the excel business

[@cynthiarodriguez1334]

Very helpful! Simple, and quick steps. I couldnt figure out how to add the developer tab on my ribbon so thank you for including that step!

[@HamdanYouTuber]

You are an expert in computers, I learn a lot from you. thanks. Regards.

[@Henneke1308]

Thank you Kevin. I've learned a lot. 😃

[@somebodyelse7451]

Thank you, lots of great info, for some reason i don't have filter in my Fx

[@DavidMusson-oe9hc]

Great explanation- would like to see extra column of tick boxes for, say, Left bakery - and see how to set that up so that only one checkbox per row could be activated.

[@benndii]

Simple but powerful. Big thumbs up! 👍

[@fredvazquez8939]

I am learning a lot from your posts. I am an Excel enthusiast and l enjoy doing the exercises that you are sharing...Thank you...

[@missyqsmith]

I am impressed! Thank you for these quick PL videos! They are so valuable! 🙂

[@АхмедЭлкади]

👏👏🤙 Wonderful Kevin With each new video, my admiration for your way of thinking grows. I appreciate the approaches you employ in explaining and uncovering inherent Excel properties. However, upon conducting thorough research, you bear a striking resemblance to a dear individual who imparted the principles of Excel professionalism upon me - the Excel Campus.

[@detectivethinker3637]

Trying to follow your method step by step! I never understood how you managed to do the checkboxes without having it in a messed up position. I am trying it multiple times.

[@alyahyai]

This has many uses, thank you Kevin

[@kirk1968]

Hi Kevin, thank you for this terrific tutorial. I've been using Excel since 1993 or so, and your presentation is both easy to understand and very informational. Nice work! I'll be binging the rest of them, there's always something new to learn 😁

[@vvhothehecks]

Brilliant work! This is beyond what I came for and it’s exactly the stuff that I needed the most now to solve my checklist project, thank you so much

[@sdh929]

Hi, Kevin. I want to say 'Thanks a million.' The way you teach is fun and engaging. I've learned a lot by watching your tutorial.

[@GrowthGrounds]

Good video. At the end I was hoping you shared the if function to turn the true false into different words lol

[@jeanjacques9462]

Thanks as always. You're so good at excel. I appreciate your videos..

[@yohannaagbanaji8012]

Wow, this is great. I'm already thinking of what will try this method to do.

[@RRKohutek]

Thank you! This was a good one.

[@sarahjanelees6904]

That’s extremely useful thank you for sharing!

[@waelalaa2557]

Many thanks Kevin, really appreciate your wonderful content and big efforts ❤

[@filovirus1]

holy moly. mind=blown! thanks for this post!

[@shahidulhasansarker]

I 100% Understood 🙂 Thanks so much Kevin my Boss 😀

[@shinichihiroshi5328]

This is PERFECT. Thank you.

[@lillberrysweet5420]

Thank you Kevin! I am learning so much from these videos!

[@mylenevelez770]

Thank you so much, Mr. Kevin.😍 I, too, Love what you do.. 💖💖💖

[@noreenstxs9605]

Thanks, Kevin!

[@UPjovai]

Simple presentation yet very informative. 👌

[@sg1803]

Absolutely brilliant! Thanks so much!

[@titlighosh6733]

Thank you for this amazing video. It's really helpful.😁

[@xdsmastermia]

Subscribed. I need something similar but instead of true false, I need a numeric value per item then to sum up only checked items. I'm certain this can do it in just an excel dummy. Nice video man

[@timparkin9805]

Thank you, this is great, really useful and I have applied everything to a large spreadsheet of a list of materials I am in the process of sourcing.

[@iviaggidiAntony]

Thank you very much ❤

[@TheSmothers71]

Your tutorials are always so easy to understand. I hope to be using the check boxes on a upcoming project. Question is there a way to copy and paste the function or do I have to assign a function to each check box individually?

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@mehdikehtarpour666]

thank for your teaching. I cant find the Filter function in Excel 2023. its possible to add this function on Excel 2023? or I force to use Excel 365?

[@BiancaPries]

Hi Keven, thank you so much for this video! So succinct and easy to follow!

[@mukundkoduganti4708]

Thanks for sharing this video. It was really informative.

[@danieldasilva302]

Cheers from Brazil ❤

[@lisanewman7641]

Genius! Thank you .

[@bhairava812]

Beautiful

[@NoorulainAyub]

Advanced level tutorial.

[@PhilJonesIII]

Nicely explained.

[@niranjeetmandal1195]

Really Helped, thanks Mate.

[@armantaghizadeh5885]

Awesome video man, keep up the good work

[@bigbonejnr1]

Good tutorial well done Kevin ❤

[@tiongah7690]

Love your videos! Are you going to do one for radio buttons?

[@hahuynh9777]

Thanks for this video, it is very useful!

[@robinsondelrosario6123]

Thank you, Kevin! I have been a long-time follower :)

[@Princessherly_]

Youre Amazing! Really appreciated this video

[@VikrantGaikwad-w6c]

👌👌AKSHRIKA channel is also providing good information.

[@paopaoastig]

New subscriber here. Anyone!. I'm not knowledgeable to excel. Even a simple basic. Any recommendations of how to learn excel from basic to advanced. A simplified teaching will be much appreciated. Thank you

[@realestategomez]

Nice video. Learn a lot from your videos. Thanks for sharing, Kevin.

[@Philip_thinkData]

Wow!!! Thank you so much.

[@abdulghanihafizilina6906]

Thank you! Super helpful!

[@DUONGBESTDIYANDTECH]

Brilliant 🎉

[@polynsngirl47]

Awesome! Thank you!

[@lucasseagull8282]

Thank you, it looks great 👍

[@joukenienhuis6888]

Great tutorial as always, but can you tell me why you chose the first checkbox and not the second ?

[@sanjeebrose5085]

Awesome video Kevin. I see a number of requests to learn how to reset a checklist. Is there a quick way to do this?

[@meganlim5398]

Thank you for the helpful instructions. This highlights to me what a terrible program Excel is in compared to Sheets. After watching this entire video and doing other searches for help, I still don't have a check box that lives IN the cell. In Sheets I can add a checkbox in my cell by: Insert --> Checkbox. Done. No other steps. Microsoft has a lot to learn.

[@joukenienhuis6888]

Your wish has been granted. It is now applied in the new version.

[@tapsalrcn3589]

Very helpful🎉

[@laukiamlaisko]

Thank you !

[@liamrhodes9856]

Can you make a video on how to reset a checklist?

[@reychhh]

Helpful. Thanks!

[@madanjha8932]

Thanks

[@amadoutidjanely3588]

What's the other alternative if you don't have the Filter function?

[@suyong5844]

Excellent

[@NigelMayhew1]

Many thanks

[@eednarb]

That's so nifty. I'm almost disappointed that I have no need for checkboxes

[@Melanie-et7dz]

This is great! Is it also possible to copy down the links (true/false)?

[@guizot2010]

Apparently, it isn't possible to copy down the links, which means that if you are linking for conditional formatting with a sheet that has a large number of rows then this is not really feasible. Also, if you want to remove the check boxes--guess what? You can't remove them by deleting the column. They will stay on your spread sheet. You have to delete each one, one-by-one. So if you copied a lot of them, and then realize that you don't want to use check boxes after all, (because, let's say, you find out that you can't copy down the links), then you have to go down the WHOLE list and manually right click to take each one out. Definitely this is a failure so far, because it's only feasible with a short, demonstration list of a few rows, such as here in this video--not a real world example.

[@XMetalChefX]

THANK YOU! Subbed!

[@ilkkaremes]

Can you edit the text on the True/False cell? You showed how to make it invisible but is it possible to make it your text? Thanks alot for all of your videos!

[@LostInRegina]

same question here. Have you found the answer? 😊