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 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.
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!!!
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....
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.
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.
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!
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 👍👍
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
Leila, Great video again.
Tip: on 3:32 you can easily remove te dollarsigns by pressing multiple times the F4 button.
👍
Thanks!
Many thanks Bruce!
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!
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!!!
Thanks
Thank you, Luke!
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.
You're an angel, know your effort is much appreciated.
Everyday I watch your Video, Everytime I learn something new.😊
You are a very good communicator, I really liked how you get to the point. Great video!
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!
Perfect video, clear, concise, easy to understand. Thankyou
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 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....
It is great. I thought it involve VBA, but as usual you are the greatest.
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 !!👏
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’re amazing. Great tutorials.
That was great. Thank you so much Mrs Leila Gharani.
AWESOME CONTENT! Just what I needed!
Excellent Guide and simple to understand & implement!! Thank you and thumbs up!
Very useful tutorial. Thanks for sharing.
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
very useful lecture. the teaching method is really good.
Your videos are really helpful. Keep it up don't stop making useful videos.
Glad to hear that, Abhishek.
Quick and easy. Thank your your time and effort in this video. 👏
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.. !
Thank you, it's really helpful.
this is a great video! will definitely be looking for more!
I was looking for this tick box template; your above lecture 100% satisfied my requirement. Thank you very much.
Excellent tip - thank you.
Didn't know you could use dynamic references in conditional formatting. Thank you! : )
I can't like your videos enough, I always klick like !! thanks
Actually.. She is correct Spoc's for learning Excel tip's 💜
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.
Wow! Thanks Leila. You never disappoint. Kudos.
Glad you like it, Peter!
The solution is as simple as it is ingenious - thx
Very useful, many thanks.
thank you for these playfull visual triks. they make organising needs more enjoyable
Very useful tips and technique especially documention and professional purpose
wow. That was great! I learned a lot in only 8min. Thank you so much!!
Glad it was helpful!
In my listeof subscribers this is a most valuable subscriber.. thank you so much sister may god bless you and your family
You are amazing thanks for sharing awesome knowledge.
Clear, and to the point as always. Thank you
a Great Mentor. thank you Leila
Thanks! Complex but fun
Thank you! great example!
Almost 1 million subscribers.
Congratulations, Leila Gharani
.
Wow, you made using checkboxes easy! I saved this video for future reference.
Glad you liked it, Mark!
Wow Leila! Thank you for uploaded this video 🙂
It's very useful 👍☺️ for my school work 😃
Enjoy your videos so much. Hopefully sometime soon we can link cells in a dynamic way.
Thank you, really amazing to learn from your videos...
That was great and easy! Thank you!
Thank you Leila, very useful tip
Thanks this is great!
Learned a lot Leila from your videos. I just wish I have discovered it earlier. Thank you so much
Happy to hear that!
Thanks for sharing!
You are so amazing! Thank you for another great video!
Thanks So Much!!!!🔥🔥🔥 This will boost my time to make To-Do lists
You are the best!!!👍🏽👍🏽👍🏽🔥🔥🔥👏🏽👏🏽
Happy to help!
Always awesome tips
I love your videos, they are very easy to follow and I learn a lot from you! Thank you for posting!
Nice one.
I am definitely going to try for it.👍
Good explanation with example
Very useful and neat thank you Leila. Take care and be safe.
Thank you so much! This was easy to follow and very helpful
You are awesome, greetings from NYC
Beautiful as usual ❤️
Very handy thanks Leila
Fantastic Leila 👌 Thanks alot
Thanks for this Leila! Useful as always.
My pleasure!
Very good explained, Leila, be sure you get a 👍 All the best! Dirk
Thank you! Cheers!
Helpful video. Thank you for sharing.
Very nice! Tick boxes in google sheets are Dynamic though. Way easier than editing each cell separately! This is 2021 Microsoft!
True!
Excellent. Thank you
Nice information 👍
Excellent video! I worked with checkboxes before but was using VBA to control everything. I like this approach better.
Nicely done
I just noticed that this channel is very near to 1 million subscribers!
Thank you Microsoft Office Teacher 👌🙏
You are welcome!
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 really enjoy your contents.
Thank you so much.
Thanks for your sharing
Thank you, I love it!!!!
My pleasure!
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. 😎😉🌹
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! 🎁
How have I only just now discovered your channel?!
Hello Leila thanks on this video
This was usefull and practival. THANKS
Really wonderful .. Thanks for sharing.
You are too good Leila
Detailed and explicit.
Thank you so much.
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.
Thats very amazing Teacher