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
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 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.
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....
@@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.
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
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 !!!
This is exactly what I needed right now, thank you so much for the help
Your Welcome!!!!
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 !!!
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.
Excellent tutorial. Thank you! I just subscribed. :)
Thank you so much for your support
*This was extremely useful*
Your welcome
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
🎉well deserved appreciate
Thank you so much !!!!
Thank you very much.😊
Your welcome !!!
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!!!
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
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 !!
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?
Completed
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
Thank you for the video.
thanks bro
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.
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....
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.
Great
Thank You!!!
Thanks
Your welcome
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
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
6:11 Hide checkbox output text.
how to send you a pictures i want to show you a sheet
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!!!
the code in 4:51 does not work
everything worked for me
Thanks bro
Your welcome brother !!!