How to Use Excel Checkboxes with Strike Through

[@KettyLan26]

Loved it... from all of the other search I did, you are the most clearer. Many thanks for your teaching.

[@geniusworldteam]

Your Welcome !!!!

[@johnpaultuquib8380]

Indeed you are a genius mate. Thanks for the help.

[@geniusworldteam]

Thank you so much !!!

[@mauniep6456]

I tried it and it worked!!! THANK YOU!!

[@geniusworldteam]

Your Welcome !!!!

[@kadzo6614]

@@geniusworldteam same. i am really excited to learn something new

[@tundeodebunmi6333]

Love this so much thank you. Please is there a way to protect the check box from being unchecked by unauthorised persons?

[@geniusworldteam]

Thank you so much for your kind words. We are working on this topic. Hopefully we will upload vedio soon on this topic.

[@wrlomprez3802]

Exactly what I needed awsome tut

[@geniusworldteam]

Thank you !!!

[@kadzo6614]

*This was extremely useful*

[@geniusworldteam]

Your welcome

[@brokemomdiaries]

This is exactly what I needed right now, thank you so much for the help

[@geniusworldteam]

Your Welcome!!!!

[@InHisWord91]

Excellent tutorial. Thank you! I just subscribed. :)

[@geniusworldteam]

Thank you so much for your support

[@lensalvado11681]

Hi do you have tutorial if 3 choices are needed? for example, pending, incomplete, complete?

[@geniusworldteam]

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!!!

[@sairamganapathy557]

If I have more than 100 check box whether I need to link each every one one by one?

[@geniusworldteam]

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.

[@generationsarising]

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?

[@arhamhabib9267]

🎉well deserved appreciate

[@geniusworldteam]

Thank you so much !!!!

[@BarryJHoffman]

Great video! my check boxes are so small (Mac excel) can they be made bigger? thanks!

[@geniusworldteam]

The size of the check boxes are fixed in excel !!

[@SandileMbuli-we1pc]

Completed

[@AhmedMuhammed4320]

thank you that was helpful

[@geniusworldteam]

Your welcome Mr.Ahmed

[@Bobburger82]

Thank you very much.😊

[@geniusworldteam]

Your welcome !!!

[@EleonoraRuggiu-c9g]

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)

[@geniusworldteam]

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. kzbin.info/www/bejne/nmqlZqaBo7dlrposi=IzpOhg7Pzjjlamn2

[@nachoGuitar]

thanks bro

[@TahneeStad]

Is it also possible when you check a checkbox that it dissapear to another sheet?

[@geniusworldteam]

You can link the sheet with formula. Hopefully it will work

[@ahafeezs]

6:11 Hide checkbox output text.

[@qaibnyiajhli6675]

Thanks

[@geniusworldteam]

Your welcome

[@MichelleRoxas-mg4mc]

what is the version of your excel? i'cant find the developer and also the check box. ty

[@geniusworldteam]

We have used Ms Excel 2007 for this example to make it easier and convenient for everyone.

[@subhraguha2443]

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....

[@gemsec]

Hi there, can this be done in Word please? Thank you

[@geniusworldteam]

Hello, It is quite difficult in word because we have to use Conditional Formatting option in excel.

[@ossiespencer4982]

Thank you for the video.

[@kamranahmed2295]

Great

[@geniusworldteam]

Thank You!!!

[@Bobburger82]

It works in my laptop. But if I want to use in my tablet or phone. It seems the checkbox disappeared.

[@geniusworldteam]

Thank you for your feedback. You can check by installing different versions of Ms Office in order to support your file features.

[@theeclairkitchens175]

i dont have developer option plz help

[@geniusworldteam]

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

[@sinnorith3401]

how to send you a pictures i want to show you a sheet

[@bruisedbanana1700]

How to do this when there are many rows, for example over 100+ rows?

[@geniusworldteam]

We can drop down cells and use formula to save time but we need to link each checkbox separately for big data

[@bruisedbanana1700]

@@geniusworldteam Exactly so we'll still need to link each cell individually for all the 100+ cells😫

[@geniusworldteam]

We are working on it and hopefully provide another way to save time

[@bruisedbanana1700]

@@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.

[@docasakamika]

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!!!!

[@geniusworldteam]

Thank you

[@sunitasingh9824]

Thank you

[@geniusworldteam]

Your welcome

[@嶺冬]

how to link the cell in one time?

[@geniusworldteam]

We have mde the recent video to create linked cells within one step. Hopefully it will benefit

[@GilbertvdBroek]

the code in 4:51 does not work

[@kadzo6614]

everything worked for me

[@ProfAdamSelene]

Sorry, das geht heute wirklich besser und einfacher!

[@geniusworldteam]

Yes, we can make it more easier and simpler or even complex as per requirement!!!

[@Kerolos_Shaheedl]

Thanks bro

[@geniusworldteam]

Your welcome brother !!!