How to Insert Checkbox in Excel

Рет қаралды 625,742

Күн бұрын

🔥 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 KZfaq
kzfaq.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

Пікірлер: 248

@KevinStratvert 11 ай бұрын

Excel has new checkboxes since I published this video! Find out how to use them: kzfaq.info/get/bejne/ptxgeNJmmpO3lX0.htmlsi=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: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 In-depth Pivot Table tutorial: kzfaq.info/get/bejne/hsp6rdxqmpzbn2g.html

@mohammedhajali1290 11 ай бұрын

kevin could you talk about adobe flash please

@MegaKingOfNoob 10 ай бұрын

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 11 ай бұрын

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 9 ай бұрын

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 11 ай бұрын

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

@kirk1968 10 ай бұрын

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 😁

@RankinAuctions 11 ай бұрын

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

@kirkelisa 11 ай бұрын

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.

@the_legend3185 11 ай бұрын

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.

@UmarAlFarooq 11 ай бұрын

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

@johannesmp3 11 ай бұрын

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

@lilylomcari1750 13 күн бұрын

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

@missyqsmith 11 ай бұрын

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

@ahmedelkadi4021 11 ай бұрын

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

@EArockerful 10 ай бұрын

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

@user-wn8cu8wc7p 10 ай бұрын

I watch your videos to learn native English; the very technical words and descriptions. So thank you very much 🎉

@dwaipayansarkar2358 11 ай бұрын

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

@AndreaAlison 11 ай бұрын

Hahaha.

@MoniMeka 3 ай бұрын

Lmaoooooo @ 1863 🤣🤣🤣🤣🤣

@AyaMama532 11 ай бұрын

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

@stereodan7180 9 ай бұрын

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

@ericrichard4940 17 күн бұрын

honestly...same here

@dowhatyouwill 6 күн бұрын

Much easier in Google Sheets tbh

@cynthiarodriguez1334 5 ай бұрын

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!

@mikekasongo8985 9 ай бұрын

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

@rjleddin3048 11 ай бұрын

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 7 ай бұрын

Then you will love the new checkboxes in Excel

@benndii 11 ай бұрын

Simple but powerful. Big thumbs up! 👍

@iz6583 11 ай бұрын

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

@waelalaa2557 11 ай бұрын

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

@amadoutidjanely3588 11 ай бұрын

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

@vvhothehecks 5 ай бұрын

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

@deidrewiza3776 11 ай бұрын

I’ve got “to do” list ideas.

@kaninecalms2785 3 ай бұрын

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

@mmad3130 11 ай бұрын

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!

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

@detectivethinker3637 10 ай бұрын

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.

@ifeyhome 11 ай бұрын

Kevin is the Best Microsoft tutor on KZfaq!🏆

@sdh929 8 ай бұрын

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.

@timparkin9805 11 ай бұрын

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.

@mylenevelez770 Ай бұрын

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

@learningtogetheredu 7 күн бұрын

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

@user-jp8il8dj2w 6 ай бұрын

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

@alyahyai 11 ай бұрын

This has many uses, thank you Kevin

@Henneke1308 11 ай бұрын

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

@billyt7292 11 ай бұрын

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

@lillberrysweet5420 10 ай бұрын

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

@daisuke1320 4 ай бұрын

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

@jeanjacques9462 11 ай бұрын

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

@sarahjanelees6904 11 ай бұрын

That’s extremely useful thank you for sharing!

@user-lo3pv8rk7t 3 ай бұрын

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.

@sg1803 7 ай бұрын

Absolutely brilliant! Thanks so much!

@steverileyretired 11 ай бұрын

Very Good, Thanks Kevin

@tusharjain2811 10 ай бұрын

Best channel in the excel business

@EthanEmc2 3 ай бұрын

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

@somebodyelse7451 9 ай бұрын

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

@HamdanYouTuber 10 ай бұрын

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

@DavidMusson-oe9hc 5 ай бұрын

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.

@yohannaagbanaji8012 10 ай бұрын

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

@lisanewman7641 7 ай бұрын

Genius! Thank you .

@joukenienhuis6888 11 ай бұрын

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

@filovirus1 11 ай бұрын

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

@shahidulhasansarker 3 ай бұрын

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

@iviaggidiAntony 11 ай бұрын

Thank you very much ❤

@abdulghanihafizilina6906 4 ай бұрын

Thank you! Super helpful!

@danieldasilva302 11 ай бұрын

Cheers from Brazil ❤

@charalamposkounes5071 11 ай бұрын

Excellent video. Google sheets is better in checkboxes though

@bigbonejnr1 11 ай бұрын

Good tutorial well done Kevin ❤

@polynsngirl47 9 ай бұрын

Awesome! Thank you!

@robinsondelrosario6123 29 күн бұрын

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

@RRKohutek 11 ай бұрын

Thank you! This was a good one.

@Princessherly_ 9 ай бұрын

Youre Amazing! Really appreciated this video

@lucasseagull8282 3 ай бұрын

Thank you, it looks great 👍

@suyong5844 10 күн бұрын

Excellent

@armantaghizadeh5885 3 ай бұрын

Awesome video man, keep up the good work

@reychhh 5 ай бұрын

Helpful. Thanks!

@noreenstxs9605 11 ай бұрын

Thanks, Kevin!

@Philip_thinkData 11 ай бұрын

Wow!!! Thank you so much.

@hahuynh9777 10 ай бұрын

Thanks for this video, it is very useful!

@laukiamlaisko 4 ай бұрын

Thank you !

@SyedMuzammilMahasanShahi 11 ай бұрын

Thanks for the share.

@bhairava812 11 ай бұрын

Beautiful

@tiongah7690 11 ай бұрын

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

@UPjovai 5 ай бұрын

Simple presentation yet very informative. 👌

@niranjeetmandal1195 9 ай бұрын

Really Helped, thanks Mate.

@realestategomez 10 ай бұрын

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

@mukundkoduganti4708 9 ай бұрын

Thanks for sharing this video. It was really informative.

@XMetalChefX 5 ай бұрын

THANK YOU! Subbed!

@kerenschneider1387 10 ай бұрын

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.

@joedrenik7760 10 ай бұрын

Hi Kevin. I'm looking for a way to add an xlookup from multiple documents, but do this in a power query so it is repeatable. It's an analysis I have to do each week. Each week the set of data is formatted the same, but the data is different. I do not want to accumulate the data from week to week. Have you done any tutorials like this?

@dukenallow2673 10 ай бұрын

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?

@DUONGBESTDIYANDTECH 11 ай бұрын

Brilliant 🎉

@ExcelWithChris 6 ай бұрын

Love it!!

@PhilJonesIII 11 ай бұрын

Nicely explained.

@NigelMayhew1 4 ай бұрын

Many thanks

@mehdikehtarpour666 8 ай бұрын

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?

10 ай бұрын

Thanks for sharing amazing video !

@pmcclure1959 10 ай бұрын

Great, informative video, but if you have 900+ rows to do is there a faster way to link all the cells?

@webryse 9 ай бұрын

I have the same question

@pmcclure1959 9 ай бұрын

@@webryse I went down the Google sheets route. The spreadsheet I was given was already in Google sheets and I asked the same question in a Facebook page and a few people said if you use excel with a lot of cells it slows down a lot.

@webryse 9 ай бұрын

@@pmcclure1959 i´ve already figured how to do link all the cells, apparently you have to paste a code in visual basic and then run at least it worked out for me but I agree with you that it´s slows a lot

@sanjeebrose5085 11 ай бұрын

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

@usamaradwan 9 ай бұрын

thank you so much

@vincebaker3384 11 ай бұрын

could you show how to do this in libre office calc & writer? Thanks

@Melanie-et7dz 11 ай бұрын

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

@guizot2010 6 ай бұрын

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.

@jehadyamin6002 5 ай бұрын

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?

@melkitson 11 ай бұрын

Very useful.

@ilkkaremes 11 ай бұрын

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 8 ай бұрын

same question here. Have you found the answer? 😊