How to Insert Checkbox in Excel

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to add a checkbox to your worksheet in Microsoft Excel. Checkboxes are a great way to add interactivity and functionality to your Excel worksheets. In this video, I’ll show you how to insert checkboxes and how to link them to cells. By linking a checkbox to a cell, you can use the state of the checkbox (checked or unchecked) in functions, formulas, and conditional formatting. For example, you can create a dynamic to-do list that shows the progress of your tasks based on the checkboxes. Checkboxes are easy to use and can make your Excel work more fun and efficient.
📚 RESOURCES
- CTRL + D to fill checkbox down to multiple cells
- CTRL + 1 to launch format control
⌚ TIMESTAMPS
00:00 Introduction
00:17 Insert a checkbox
02:18 Insert multiple checkboxes
02:51 Link checkbox to cell
05:24 Use checkbox with countif function
07:09 Use checkbox with conditional formatting
08:02 Use checkbox with filter function
10:52 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZbin
kzbin.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #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

[@mohammedhajali1290]

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

[@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.

[@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.

[@pjohn1435]

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

[@RankinAuctions]

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

[@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 😁

[@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.

[@missyqsmith]

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

[@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.

[@AyaMama532]

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

[@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!

[@UmarAlFarooq]

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

[@ahmedelkadi4021]

👏👏🤙 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.

[@mikekasongo8985]

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

[@waelalaa2557]

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

[@benndii]

Simple but powerful. Big thumbs up! 👍

[@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

[@kaninecalms2785]

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

[@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!! 😊

[@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

[@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.

[@user-wn8cu8wc7p]

I watch your videos to learn native English; the very technical words and descriptions. So thank you very 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.

[@user-jp8il8dj2w]

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

[@iz6583]

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

[@billyt7292]

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

[@mylenevelez770]

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

[@alyahyai]

This has many uses, thank you Kevin

[@sarahjanelees6904]

That’s extremely useful thank you for sharing!

[@Henneke1308]

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

[@lillberrysweet5420]

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

[@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...

[@jeanjacques9462]

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

[@sg1803]

Absolutely brilliant! Thanks so much!

[@steverileyretired]

Very Good, Thanks Kevin

[@dwaipayansarkar2358]

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

[@AndreaAlison]

Hahaha.

[@MoniMeka]

Lmaoooooo @ 1863 🤣🤣🤣🤣🤣

[@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

[@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!

[@yohannaagbanaji8012]

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

[@somebodyelse7451]

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

[@learningtogetheredu]

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

[@HamdanYouTuber]

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

[@iviaggidiAntony]

Thank you very much ❤

[@RRKohutek]

Thank you! This was a good one.

[@ifeyhome]

Kevin is the Best Microsoft tutor on KZbin!🏆

[@filovirus1]

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

[@lucasseagull8282]

Thank you, it looks great 👍

[@abdulghanihafizilina6906]

Thank you! Super helpful!

[@polynsngirl47]

Awesome! Thank you!

[@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.

[@daisuke1320]

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

[@deidrewiza3776]

I’ve got “to do” list ideas.

[@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

[@lisanewman7641]

Genius! Thank you .

[@hahuynh9777]

Thanks for this video, it is very useful!

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@reychhh]

Helpful. Thanks!

[@mukundkoduganti4708]

Thanks for sharing this video. It was really informative.

[@Princessherly_]

Youre Amazing! Really appreciated this video

[@danieldasilva302]

Cheers from Brazil ❤

[@armantaghizadeh5885]

Awesome video man, keep up the good work

[@Philip_thinkData]

Wow!!! Thank you so much.

[@shahidulhasansarker]

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

[@amadoutidjanely3588]

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

[@niranjeetmandal1195]

Really Helped, thanks Mate.

[@bigbonejnr1]

Good tutorial well done Kevin ❤

Thanks for sharing amazing video !

[@PhilJonesIII]

Nicely explained.

[@realestategomez]

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

[@robinsondelrosario6123]

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

[@tiongah7690]

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

[@XMetalChefX]

THANK YOU! Subbed!

[@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.

[@UPjovai]

Simple presentation yet very informative. 👌

[@user-lo3pv8rk7t]

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.

[@bhairava812]

Beautiful

[@noreenstxs9605]

Thanks, Kevin!

[@charalamposkounes5071]

Excellent video. Google sheets is better in checkboxes though

[@tusharjain2811]

Best channel in the excel business

[@laukiamlaisko]

Thank you !

[@EthanEmc2]

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

[@DUONGBESTDIYANDTECH]

Brilliant 🎉

[@suyong5844]

Excellent

[@melkitson]

Very useful.

[@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?

[@NigelMayhew1]

Many thanks

[@joukenienhuis6888]

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

[@ExcelWithChris]

Love it!!

[@usamaradwan]

thank you so much

[@kerenschneider1387]

Great Video, Thank you :) Is there a way to limit the number of selections? I have 50 checkboxes and I want to limit the selection to 16 max.

[@mail2kapali]

Very useful video

[@user-tc5pl3zw3h]

Kevin, I also need to know about ActiveX check boxes, and how I can automatically position and size them in a cell. Do you have a video for that? And, is there a way to get the new, nifty Excel 365 check boxes in Excel for Windows?

[@jehadyamin6002]

Kevi, thanks for the great and interesting videos. The newly added check box under the insert icon is not installed in my office 365. Any clues?

[@dukenallow2673]

Your videos are great. Thank you. Question: When I hover over the sheet scrolling arrows in the lower left, there is a pop up that interferes with the scrolling arrows. This is driving me crazy. The "See all sheets" option is right over the scroll arrows and I am constantly jumping to other workbooks I have open. How can I disable this pop up?

[@4lokita]

Thanks.

[@xlwatcher8885]

Is is possible to highlight all the checkboxes at one time to set their format or link to a cell? (150 in a column) thank you for the excellent vid

[@tenamsb686]

Nice!

[@kamarasiakarifa6359]

Amazing 😍

[@liamrhodes9856]

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