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
@@kuntito Leila discusses this in her video ruclips.net/video/tGY70sdpaLc/видео.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.
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!! ;)
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!!!
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.
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....
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.
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
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!
Probably the best workaround w/out getting into VBA. (Frustrating Excel doesn't offer in cell checkboxes - even Smartsheet has it). With some VBA and using unicode ballot-box characters, there's a way to make in-cell checkboxes that toggle on the double click event. VBA just looks at the left most character of the target cell, and if it is ☐, changes it to ☑. Or vice versa. Only replaces the left character so it leaves the labels unchanged. That way the checkboxes can be copy/pasted and moved around like normal cells. Disadvantage is that users have to change their macro security to allow for running VBA.
Thank You Leila! One suggestion for this lesson. Make a reference back to the formatting cells tutorial. Particularly the custom formatting. Might be better for viewers that have something other than a white background. Keep up the amazing work and best wishes!!
amazing video. Is it possible to create a dynamic drop down multiple selection checkbox based on a filter? for example if I select region as south, I want to display a list of checkboxes consisting of states that are in the south region. the list should change when I select another region
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 feel as if I could have really used this knowledge 4 or 5 years ago, but I found some other way to do what I needed. This would have been the more elegant design, however.
Great video, thank you! Can I ask if checkboxes can be used on Excel app for iOS & Android - or does it only work when the file is open on the desktop version of Excel? If you could provide some clarity on which version of Excel this works that would be great as I cannot get the checkboxes to work once I open the files in iOS Excel app on iPhone or iPad. TIA :)
Great video, exactly what I was looking for. However, is there a way to make what is unchecked not to be in a column view? What do I need to do to appear as a narrative? Can it be done in word?
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 ruclips.net/video/tGY70sdpaLc/видео.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
Leila, Great video again.
Tip: on 3:32 you can easily remove te dollarsigns by pressing multiple times the F4 button.
👍
Not like I'm surprised...this was superbly done. Right words, right order, fit for purpose. BRAVO!
Whenever I watch your videos I gained skills and my co-workers thought I am some kind of a genius or something.
Everyday I watch your Video, Everytime I learn something new.😊
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!!!
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!
With you, everything becomes so easy, it's a joy to learn. Thanks.
So nice of you, Claire!
You're an angel, know your effort is much appreciated.
You are a very good communicator, I really liked how you get to the point. Great video!
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
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!
Thank you again, Your tone is very relaxing and comforting .Perfect for learning
Leila is my favorite Excel instructor. Excellent! Thank you.
Thank you Billy! You're a great instructor yourself!
Every time I watch your videos. It amazes me! Thank you so much, Ms. Leila!
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.
Very nice! Tick boxes in google sheets are Dynamic though. Way easier than editing each cell separately! This is 2021 Microsoft!
True!
Perfect video, clear, concise, easy to understand. Thankyou
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 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....
Thanks
Thank you, Luke!
Thanks!
Many thanks Bruce!
I was looking for this tick box template; your above lecture 100% satisfied my requirement. Thank you very much.
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.
In my listeof subscribers this is a most valuable subscriber.. thank you so much sister may god bless you and your family
I just noticed that this channel is very near to 1 million subscribers!
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.. !
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!
Almost 1 million subscribers.
Congratulations, Leila Gharani
.
very useful lecture. the teaching method is really good.
Didn't know you could use dynamic references in conditional formatting. Thank you! : )
Actually.. She is correct Spoc's for learning Excel tip's 💜
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.
Your videos are really helpful. Keep it up don't stop making useful videos.
Glad to hear that, Abhishek.
That was great. Thank you so much Mrs Leila Gharani.
Mam change my Excel skill to another level. Thanks ❤️
Wow, you made using checkboxes easy! I saved this video for future reference.
Glad you liked it, Mark!
Wow! Thanks Leila. You never disappoint. Kudos.
Glad you like it, Peter!
Excellent Guide and simple to understand & implement!! Thank you and thumbs up!
Quick and easy. Thank your your time and effort in this video. 👏
Very useful tips and technique especially documention and professional purpose
Hi Leila. 😊 i'm a good guy ! I didn't use drag down to copy the cell with checkbox... 😪😅 now i'm ready to work better. 😎😉🌹
Thank you Microsoft Office Teacher 👌🙏
You are welcome!
Learned a lot Leila from your videos. I just wish I have discovered it earlier. Thank you so much
Happy to hear that!
The solution is as simple as it is ingenious - thx
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!
thank you for these playfull visual triks. they make organising needs more enjoyable
Probably the best workaround w/out getting into VBA. (Frustrating Excel doesn't offer in cell checkboxes - even Smartsheet has it). With some VBA and using unicode ballot-box characters, there's a way to make in-cell checkboxes that toggle on the double click event. VBA just looks at the left most character of the target cell, and if it is ☐, changes it to ☑. Or vice versa. Only replaces the left character so it leaves the labels unchanged. That way the checkboxes can be copy/pasted and moved around like normal cells. Disadvantage is that users have to change their macro security to allow for running VBA.
I was looking for just this, thank you.
Excellent video! I worked with checkboxes before but was using VBA to control everything. I like this approach better.
Leila, "Everything is simplified and improved"
It is great. I thought it involve VBA, but as usual you are the greatest.
How have I only just now discovered your channel?!
Thank You Leila! One suggestion for this lesson. Make a reference back to the formatting cells tutorial. Particularly the custom formatting. Might be better for viewers that have something other than a white background. Keep up the amazing work and best wishes!!
You’re amazing. Great tutorials.
a Great Mentor. thank you Leila
I can't like your videos enough, I always klick like !! thanks
wow. That was great! I learned a lot in only 8min. Thank you so much!!
Glad it was helpful!
AWESOME CONTENT! Just what I needed!
Thank you for this video. It's of great help. Can you explain how you added All Done to the equation. I don't understand that part.
Enjoy your videos so much. Hopefully sometime soon we can link cells in a dynamic way.
Very useful tutorial. Thanks for sharing.
Clear, and to the point as always. Thank you
Thank you, it's really helpful.
I love your videos, they are very easy to follow and I learn a lot from you! Thank you for posting!
amazing video. Is it possible to create a dynamic drop down multiple selection checkbox based on a filter? for example if I select region as south, I want to display a list of checkboxes consisting of states that are in the south region. the list should change when I select another region
Wow Leila! Thank you for uploaded this video 🙂
It's very useful 👍☺️ for my school work 😃
Very useful and neat thank you Leila. Take care and be safe.
this is a great video! will definitely be looking for more!
You are amazing thanks for sharing awesome knowledge.
Excellent tip - thank you.
This sounds great apart from having to set the cell link manually. Any ideas to get around that so you can copy the checkboxes down a long list?
I am also interested in how to automate this process.
Thank you, really amazing to learn from your videos...
Very good explained, Leila, be sure you get a 👍 All the best! Dirk
Thank you! Cheers!
I am allergic in excel hahaha!but now I am already interested! because of you mam,tnx a lot
You are welcome 😊
Hi Leila ,
Thank you for videos.
I would appreciate if make videos on VBA excel and SQL Server..
Thank you so much! This was easy to follow and very helpful
Thanks So Much!!!!🔥🔥🔥 This will boost my time to make To-Do lists
You are the best!!!👍🏽👍🏽👍🏽🔥🔥🔥👏🏽👏🏽
Happy to help!
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! 🎁
Good explanation with example
You are awesome, greetings from NYC
Your throwaway comment of "this also works with google sheets" makes me now realise you may have a whole series on sheets that I need to view
Actually a whole online course 😊
@@LeilaGharani Holy moly. Thanks!
Thank you Leila, very useful tip
That is something I don‘t know I needed. Great video, Thank You
Glad it was helpful, Denny!
Awesome. Already have some candidates for this latest learning. Thanks again. :-)
Excellent!
Thank you! great example!
Thank you so much "TEACHER", greetings from México 🙏👏
You are welcome! Saludos :)
TREMENDOUS TRICK...I REALLY APPRECIATE FOR YOUR SMART WORK
Nice one.
I am definitely going to try for it.👍
Detailed and explicit.
Great Leila. Love the idea of changing font color. I have added to adjacent column then hide column. Like your idea better.
This is really Nice! Can’t we just record a macro to do these strikethroughs?
I feel as if I could have really used this knowledge 4 or 5 years ago, but I found some other way to do what I needed. This would have been the more elegant design, however.
You are so amazing! Thank you for another great video!
Thanks for this Leila! Useful as always.
My pleasure!
Nice.... Since I was there I also nested UNIQUE and SORT
Great video, thank you! Can I ask if checkboxes can be used on Excel app for iOS & Android - or does it only work when the file is open on the desktop version of Excel? If you could provide some clarity on which version of Excel this works that would be great as I cannot get the checkboxes to work once I open the files in iOS Excel app on iPhone or iPad. TIA :)
Great video, exactly what I was looking for. However, is there a way to make what is unchecked not to be in a column view? What do I need to do to appear as a narrative? Can it be done in word?
Fantastic Leila 👌 Thanks alot