How to Use Excel Checkboxes | Interactive Checklists & Reports
Вставка
- Опубліковано 4 лип 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Quickly learn how to use checkboxes to create interactive checklists. Ideal for anyone looking to enhance their Excel skills, this video guides you step by step on adding, using, and customizing checkboxes in Excel.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/checkboxes-...
🔑 What You'll Learn:
▪️ Adding Checkboxes: Discover the straightforward process of inserting checkboxes into your Excel sheets.
▪️ Dynamic Checkboxes: Learn how to link checkboxes to cell values for dynamic interaction and control.
▪️ Conditional Formatting: See how you can use the status of checkboxes (TRUE/FALSE) to apply conditional formatting, like the strikethrough effect.
▪️ Formulas with Checkboxes: Explore how to use checkbox results in formulas, such as the FILTER function, to manage tasks and data efficiently.
00:00 How to Use Checkboxes in Excel
00:29 How to Create Checkboxes in Excel
02:10 How to Use the Status of Checkboxes
04:54 Apply Conditional Formatting Based on a Checkbox - Strikethrough effect
06:09 Use Formulas Based on a Checkbox
07:22 Wrap Up
If you'd like to add a radio button instead: • Create INTERACTIVE Exc...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/checkboxes-file
Hi @Leila the checkbox function - is it dependent on Windows 10 vs 11 with the same Office 365?
There's another option to make the "TRUE" or "FALSE" invisible. While the suggestion to make the font color white will work in general, if someone highlights the cells in a color (such as red or gray), then the white font would show up.
Instead, go into "Format Cells..." and change the format from "General" to "Custom" with the custom format being 3 semi-colons ;;;
The cell will still have the TRUE or FALSE value, but the text will be invisible regardless of font color or highlight color.
P.S. I always enjoy Leila's videos on Excel
B Bila Bilabhbb
Thanks, but how do the 3 semi-colons make the text invisible? @Robert Thompson
@@kuntito
Leila discusses this in her video ua-cam.com/video/tGY70sdpaLc/v-deo.html
Quick summary. Custom format for positive, negative, zero numbers and text are separated by semi-colons. If you don't give it a format (before each semi-colon) that means do not display anything. Text is the format after the 3rd semi-colon.
Thank you
@@robertthompson7334 LOVE this tip! Thank you so much!
That is a LOT of work for something so simple as a checkbox. Very surprised MS hasn't added this as a design feature yet.
yes, this a LOT of problem. I want to use table on Onenote, but when is big table it's unusable because you can't copy and paste. At the same time, Excel doesn't allow you to checklist, so it's like: Microsoft are you stupid? You want us to use your tools but you won't let us.... . Google Sheets does have this option but the problem is that it doesn't have the zoom option when clicking, so it's also frustrating. I still wonder how it is possible that Google and Microsoft do not take these things into account. Be patient and we will find it! If someone reads this and finds it, please reply.
There is other videos where people created a Macro to create all the checkboxes for you that are already dynamic! I created 1189 checkboxes in just 10 seconds!! ;)
I'm still wondering how come MS hasn't implemented a feature like this by this time. Checkboxes in MS Excel are not simple to create and handle.
no it isnt and there are many alternatives for faster this is to customize stuff.
@@GeneralTantordo you know where i can get it
Thank you very much Leila, your explanations are very detailed, they helped me to understand the reason behind each step. this enhanced my efficiency.
Glad it was helpful!
Leila, you make people lives easier. Thank you for all you do - making a difference in the quality of our work-lives! So appreciative - so grateful!
Wow, thank you!
You're an angel, know your effort is much appreciated.
Every time I watch your videos. It amazes me! Thank you so much, Ms. Leila!
With you, everything becomes so easy, it's a joy to learn. Thanks.
So nice of you, Claire!
Had a dauting task of updating a conditional formatting heavy checklist created by a former colleague. I've been taking online excel classes thinking it will eventually get to what I need to know to edit the checklist but I lost patience as I really needed a fix sooner than later. By watching this video once, I have a better understanding of the functionality of checkboxes and conditional formatting that I was able to figure out the fixes I needed. Thank you so much for your videos!!!
You are a very good communicator, I really liked how you get to the point. Great video!
Whenever I watch your videos I gained skills and my co-workers thought I am some kind of a genius or something.
Your video is so easy to follow. I am a heavy excel user. You really make my life easier and make my work more fun. BIG THANkS !!👏
Thank you again, Your tone is very relaxing and comforting .Perfect for learning
Can you show how to put a check mark in a cell and it places today's date of action in the very next cell? Where would today's date be placed within the sheet for the dynamic affect? Your videos are awesome, I use them to train my staff all the time. You're a great trainer. Good voice and steady flow of instruction so its not to fast or too slow.
Excellent video! I worked with checkboxes before but was using VBA to control everything. I like this approach better.
Thank you for explaining! I was had been looking for this for a while now. Seeing you work with these non dynamic functies though makes me realise this is way too trivial for larger size documents....
Leila, Great video again.
Tip: on 3:32 you can easily remove te dollarsigns by pressing multiple times the F4 button.
👍
I was looking for this tick box template; your above lecture 100% satisfied my requirement. Thank you very much.
Wow Leila! Thank you for uploaded this video 🙂
It's very useful 👍☺️ for my school work 😃
Excellent Guide and simple to understand & implement!! Thank you and thumbs up!
I am using only check box Formatting . I never used filter option to see the balance tasks. I used to see balance manually. That filter option is saving lot of time to see the balance tasks. Thank you so much for your wonderful and complete automation suggestion. It is saving a lot of time for me.
you've made me super excited today. really loved the checkboxes in excel. thank you so much, Leila really love your videos
they're like presents for me 👍👍
I'm so glad! 🎁
Everyday I watch your Video, Everytime I learn something new.😊
I am a long-time viewer and I always enjoy Leila's videos on Excel!
I learned a lot from her!
Jus could you indicate somewhere on the screen which version of MsOffice you are using, please?.
Sometimes I am confused with your old or new videos.
Thank you for your great job and please do not stop!
I love your videos, they are very easy to follow and I learn a lot from you! Thank you for posting!
Perfect video, clear, concise, easy to understand. Thankyou
Clear, and to the point as always. Thank you
Leila is my favorite Excel instructor. Excellent! Thank you.
Thank you Billy! You're a great instructor yourself!
Didn't know you could use dynamic references in conditional formatting. Thank you! : )
It would be really cool if Excel had in-cell checkboxes like Google Sheets has.
True. Maybe some day :)
Very valid, that will be great indeed.
But Leila trick works well too but will just take time to build
This is a pain compared to Google, I've been using Google for 2 years now back to excel and this checkbox is soooo annoying on excel and its not even dynamic
Wow, this is too time consuming, Google sheets do it quite easier lol
So true!
Thanks So Much!!!!🔥🔥🔥 This will boost my time to make To-Do lists
You are the best!!!👍🏽👍🏽👍🏽🔥🔥🔥👏🏽👏🏽
Happy to help!
Useful information, well-presented. As usual. Many thanks.
Thank you so much! This was easy to follow and very helpful
Quick and easy. Thank your your time and effort in this video. 👏
AWESOME CONTENT! Just what I needed!
In my listeof subscribers this is a most valuable subscriber.. thank you so much sister may god bless you and your family
I really enjoy your contents.
Thank you so much.
You’re amazing. Great tutorials.
Very nice! Tick boxes in google sheets are Dynamic though. Way easier than editing each cell separately! This is 2021 Microsoft!
True!
With you, everything becomes so easy, it's a joy to learn. Thanks.. With you, everything becomes so easy, it's a joy to learn. Thanks..
So nice of you
Great Leila. Love the idea of changing font color. I have added to adjacent column then hide column. Like your idea better.
Wow! Thanks Leila. You never disappoint. Kudos.
Glad you like it, Peter!
Enjoy your videos so much. Hopefully sometime soon we can link cells in a dynamic way.
Actually.. She is correct Spoc's for learning Excel tip's 💜
Thank you so much "TEACHER", greetings from México 🙏👏
You are welcome! Saludos :)
First time watching yr video which I had difficulties with other videos .. Love Love Love your videos! They are so helpful and easy to understand.. !
Very useful and neat thank you Leila. Take care and be safe.
Thank you, it's really helpful.
That was great. Thank you so much Mrs Leila Gharani.
Thanks! I've been wondering how to properly use this. The macro link just didn't work for what I needed. Keep these clear tips coming please.
Wow, you made using checkboxes easy! I saved this video for future reference.
Glad you liked it, Mark!
Very useful tutorial. Thanks for sharing.
this is a great video! will definitely be looking for more!
Thank you, really amazing to learn from your videos...
Helpful video. Thank you for sharing.
Mam change my Excel skill to another level. Thanks ❤️
Very cool, all the right "checkboxes" ticked for this video! Nice work Leila as always! 😊👍
Yay, thank you Vijay!
Excellent tip - thank you.
It is great. I thought it involve VBA, but as usual you are the greatest.
Learned a lot Leila from your videos. I just wish I have discovered it earlier. Thank you so much
Happy to hear that!
Thank you Leila, very useful tip
thank you for these playfull visual triks. they make organising needs more enjoyable
You’re amazing; thank you.
a Great Mentor. thank you Leila
Very very easy explanation and really useful for people like me in my day to day work. Thanks a lot. Sub a must. 👏👏👏
That was great and easy! Thank you!
Thank you! great example!
That is something I don‘t know I needed. Great video, Thank You
Glad it was helpful, Denny!
Thanks for this Leila! Useful as always.
My pleasure!
wow. That was great! I learned a lot in only 8min. Thank you so much!!
Glad it was helpful!
Really wonderful .. Thanks for sharing.
Almost 1 million subscribers.
Congratulations, Leila Gharani
.
I can't like your videos enough, I always klick like !! thanks
Your videos are really helpful. Keep it up don't stop making useful videos.
Glad to hear that, Abhishek.
This is great! i am going to use it all the time now
Very useful tips and technique especially documention and professional purpose
The solution is as simple as it is ingenious - thx
You are so amazing! Thank you for another great video!
Beautiful as usual ❤️
Thank you so much!
very useful lecture. the teaching method is really good.
Thank you Microsoft Office Teacher 👌🙏
You are welcome!
You are amazing thanks for sharing awesome knowledge.
Yes, I found it very useful!! 👍🏽
Best and the most wanted one ❤️
Hi Leila, I really like your videos because it helps me in my daily work. But I have a question regarding this checkboxes feature, is there a function where there is a confirmation box will pop up when you click the checkboxes?
Hi Leila ,
Thank you for videos.
I would appreciate if make videos on VBA excel and SQL Server..
Thanks for sharing!
Genius trick thank you Leila
You are awesome, greetings from NYC
Excellent. Thank you
Always awesome tips
Nice one.
I am definitely going to try for it.👍
Awesome. Already have some candidates for this latest learning. Thanks again. :-)
Excellent!
Nice.... Since I was there I also nested UNIQUE and SORT
Fantastic Leila 👌 Thanks alot
How have I only just now discovered your channel?!
It is very helpful 👍 thanks
Good explanation with example
Wow, your excellent tutorial has helped to make a nuf-nuf like me look like a genius around here. You are a goddess.