How to Use Excel Checkboxes with Strike Through
Вставка
- Опубліковано 14 гру 2024
- #CheckBox #Strikethrough #Excel #GeniusWorld
We can use the check box by using the amazing trick of conditional formating which includes the strike through using the different fonts and colors. We have also used the condition for the task completion.
************** Kindly Like and Subscribe for Support **********************
/ genius-world-ms-excel-...
Excel Tutorial :
/ @geniusworldteam
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: / genius-world. .
Loved it... from all of the other search I did, you are the most clearer. Many thanks for your teaching.
Your Welcome !!!!
Indeed you are a genius mate. Thanks for the help.
Thank you so much !!!
I tried it and it worked!!! THANK YOU!!
Your Welcome !!!!
@@geniusworldteam same. i am really excited to learn something new
Exactly what I needed awsome tut
Thank you !!!
This is exactly what I needed right now, thank you so much for the help
Your Welcome!!!!
*This was extremely useful*
Your welcome
Love this so much thank you. Please is there a way to protect the check box from being unchecked by unauthorised persons?
Thank you so much for your kind words.
We are working on this topic. Hopefully we will upload vedio soon on this topic.
6:11 Hide checkbox output text.
Excellent tutorial. Thank you! I just subscribed. :)
Thank you so much for your support
Completed
🎉well deserved appreciate
Thank you so much !!!!
Hi do you have tutorial if 3 choices are needed? for example, pending, incomplete, complete?
Apologize but we can make multiple scenarios like Pending, Work in process, complete and Cancelled bu using the same technique that has been used for normal scenarios. We will try to make video on multiple scenarios in near future.
Thank you for your feedback!!!
Thank you very much.😊
Your welcome !!!
If I have more than 100 check box whether I need to link each every one one by one?
Thank You for your comment.
You can use Google Excel sheet or Ms Excel 365 to create more than 100 check boxes. It will save time to link it.
Otherwise you will need to link each cell separately.
thank you that was helpful
Your welcome Mr.Ahmed
thanks bro
I am looking for a way to format some dependent tasks if the trigger is checked done. Is there a way to do that in excel?
I have a problem because I have A LOT of cells to check. Is there not a faster way to copy and paste the format control to another cell? Or must I change EVERY SINGLE CELL of the entire document? T_T (sorry for my bad English, I hope my issue is clear)
Thank you for you comment. I hope you are doing well.
We have made simple video on it for many cells. Hopefully it will work.
ua-cam.com/video/h9B5sKnR2x8/v-deo.htmlsi=IzpOhg7Pzjjlamn2
Is it also possible when you check a checkbox that it dissapear to another sheet?
You can link the sheet with formula. Hopefully it will work
Great video! my check boxes are so small (Mac excel) can they be made bigger? thanks!
The size of the check boxes are fixed in excel !!
Thank you for the video.
what is the version of your excel? i'cant find the developer and also the check box. ty
We have used Ms Excel 2007 for this example to make it easier and convenient for everyone.
Hi,, just right click on task bar, one window will be openned, there you will get developer option. Click on to that. Developer option will be shown on task bar....
Great
Thank You!!!
Thanks
Your welcome
It works in my laptop. But if I want to use in my tablet or phone. It seems the checkbox disappeared.
Thank you for your feedback. You can check by installing different versions of Ms Office in order to support your file features.
Hi there, can this be done in Word please? Thank you
Hello, It is quite difficult in word because we have to use Conditional Formatting option in excel.
How to do this when there are many rows, for example over 100+ rows?
We can drop down cells and use formula to save time but we need to link each checkbox separately for big data
@@geniusworldteam Exactly so we'll still need to link each cell individually for all the 100+ cells😫
We are working on it and hopefully provide another way to save time
@@geniusworldteam Ok thank you. I have data with over 100 rows that i would like to add checkmarks to but I can't. It will be nice if there was a short way to do it.
No need to type "B3=TRUE". You can type only B3!!!! Also, no need to type "=$D3= ..." in Conditional Formatting. You can type only B3!!!!
Thank you
Thank you
Your welcome
how to send you a pictures i want to show you a sheet
the code in 4:51 does not work
everything worked for me
i dont have developer option plz help
Please click on File -> Option
Box will appear -> go on Customize Ribbon
Tick Developer Option to appear on tabs
Still face issue. Please let me know
Thank You
how to link the cell in one time?
We have mde the recent video to create linked cells within one step. Hopefully it will benefit
Sorry, das geht heute wirklich besser und einfacher!
Yes, we can make it more easier and simpler or even complex as per requirement!!!
Thanks bro
Your welcome brother !!!