Create an Interactive Checklist in Excel
Тәжірибелік нұсқаулар және стиль
Create an interactive checklist in Excel that automatically marks items when they are completed.
Master Excel today with this comprehensive course - bit.ly/UltimateExcel
In this video tutorial, you will see how to insert checkboxes in Excel, link them to cells and then automatically format them when completed.
Watch this video to learn how to create a macro that will set the link cell for all of the checkboxes on a worksheet - • Excel Macro to Link al...
The video will make you understand how checkboxes in Excel work. And how Conditional Formatting can be applied to the value of a checked box.
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
Пікірлер: 263
Hi Computergaga, congratulations on this very instructive video. You explain very well, and you show how skilled you are. Thank you very much for these very useful tips, they come in handy for everyday work. Please carry on! Have you a very nice day.
@Computergaga
7 жыл бұрын
Thanks Damian, your comments are very much appreciated.
Thanks man, this is very interesting.
I learned something cool to do for future Excel DIYs. Thanks! Very simple tutorial and effective. I used to use Word and just print sheets with check boxes and names. It is a waste. Now, I can do all my checklists on Excel without wasting printer ink and paper!
@Computergaga
5 жыл бұрын
Excellent. Nice work.
Thanks man, this solved my problem!!!
Great video! East to understand and follow and I could readily imagine different uses for it.
@Computergaga
4 жыл бұрын
Thank you.
wow, superb! I loved it... Thank you so much for this video.
@Computergaga
5 жыл бұрын
My pleasure Dev. Thank you.
Nice one Alan.. great tip which will be useful for many purposes. Also like your other video on how to enhance with the ability to check all or check none simultaneously with a single click. Thumbs up!
@Computergaga
5 жыл бұрын
Cheers Wayne.
Wonderful. Thanks mate
@Computergaga
6 жыл бұрын
Your welcome Syed, thank you.
Thank you very much, this just made my job easier.
@Computergaga
7 жыл бұрын
Your welcome Chazmonique.
Thank you very much - Very easy and informative...
@Computergaga
6 жыл бұрын
You're welcome. Thank you.
Great video in did! Thank you very much for the offer!
@Computergaga
5 жыл бұрын
You're very welcome.
Thank you so much for this video. It was very helpful.
Thanks, very helpful!
@Computergaga
6 жыл бұрын
You're welcome Linda, thanks.
Thank you so much. Very helpful.
@Computergaga
5 жыл бұрын
My pleasure. Bogdan.
THANK YOU. YOU ARE A FANTASTIC INSTRUCTOR AND IT WAS A GREAT EXPERIENCE.
@Computergaga
4 жыл бұрын
You're welcome. Thank you very much.
Muito bom! Excelente didática! Obrigado por compartilhar! :)
@Computergaga
5 жыл бұрын
Seja bem-vindo. Obrigado por suas palavras.
@gregflippo8739
5 жыл бұрын
@@Computergaga where is the developer tab in the new excel
@gregflippo8739
5 жыл бұрын
thx man.. u helped me by even typing that out.. i was like.. oh let me google THAT haha
Very Important & Usefull
@Computergaga
6 жыл бұрын
Thank you Syed.
thanks
Thank u for sharing something interesting.
@Computergaga
7 жыл бұрын
Your welcome James
This is an interesting use of conditional formatting; it only works when the sheet is unprotected how can I get it to work when I protect sheet. Please send link on this topic if there are any Thanks, keep these tutorials going
You could put the value of the checkbox under it, in the B column, still it would need to be white and might confuse some users.
Thank you sir for the simplicity of your video. Very easy to follow.
@Computergaga
4 жыл бұрын
Great to hear. Thank you, Olubayo.
Hello! Is there a way to move the ticked rows on top automatically? so you can have a separation of trues and falses? thank you!
Thanks so much for this video! Could you please explain what I do when my checkboxes are lined horizontally? I currently have checkboxes in cells E4 till O4, all the way down to E40 and O40. I've been trying your thing for over an hour now, but no succes...thanks!
Thank you mate
@Computergaga
7 жыл бұрын
Your welcome Simphiwe, thanks.
Hello Computergaga thank you for producing such a clear and concise tutorial. I look forward to coming back.
@Computergaga
6 жыл бұрын
You're welcome James, thank you.
Dude... You are Awesome. Salute...!!!
@Computergaga
5 жыл бұрын
Thank you Abhi.
very helpful .thanks
@Computergaga
6 жыл бұрын
You're welcome Bamidele
Thank you so much!!! It’s like a big accomplishment for me, a huge step to success, I seriously seriously appreciate to it sir!!!!!
@Computergaga
4 жыл бұрын
You're very welcome. Happy to help.
awesome! can you adjust the size of the text box?
Worked awesome, thanks!
@Computergaga
4 жыл бұрын
My pleasure Michael.
Love it! Thanks
@Computergaga
4 жыл бұрын
My pleasure. Thank you.
Thanks, it is a good explanation
@Computergaga
7 жыл бұрын
Thanks Mazen.
very well
Thanks for this video. Deleting multiple checkboxes however is an incredible pain. Using Google Sheets is far more simpler!!!!
Very Good Instructions. Straight to the point with no fluff added. Just the way I like it :o)
@Computergaga
6 жыл бұрын
Thank you.
Thanks a lot
@Computergaga
6 жыл бұрын
You're welcome Asaraf.
Wow I learnt something very useful @work life thanks for the video and simple and explained clearly...
@Computergaga
4 жыл бұрын
Great to hear. Thank you.
How would you add a Select All check Box so that you can Check and un check all at the same time?
@Computergaga
6 жыл бұрын
I have a video on how to do that here - kzread.info/dash/bejne/iXymzrRmlqa8qqg.html Thank you for your comment Lor.
Thank you for wary useful tools and good explanation.
@Computergaga
3 жыл бұрын
You are welcome, Nino 👍
thanks a lot! Awesome. so easy to understand. love it>>>>>
@Computergaga
4 жыл бұрын
Thank you very much Mehrdad.
Thanks for the video. is there anyway to change the size of the actual check boxes?
@Computergaga
7 жыл бұрын
Absolutely they can be resized however you want. Probably a good idea to resize the cells too so that they fit neatly inside and the formulas align.
Hello! Thanks for an excellent video. I have already seen the one about the macro to establish the links. Would it be possible a macho to create automatically a lot of checkboxes? I need around 400, let's say 4 columns x 100 rows... If not, is there any tool to align or distribute equally the checkboxes as can be done with objects in an image? That would help... All the best
@Computergaga
5 жыл бұрын
Thank you Juan. You can definitely create the check boxes with a macro, although I do not have the code to hand right now.
Great video! Helped me make a great looking checklist, thanks!!
@Computergaga
Жыл бұрын
Glad it helped!
Helped me!
@Computergaga
6 жыл бұрын
Great to hear, thanks.
Very usefull and so smart with this colore
thank you:D
@Computergaga
5 жыл бұрын
You're welcome Melat.
Great explanation! Thanks a lot :)
@Computergaga
7 жыл бұрын
Your welcome Vijay.
HOW DO YOU take a value of true from a check box to add and don't add different rows?
DAMN. You good. Thank you thank you boo boo!
@Computergaga
4 жыл бұрын
My pleasure Faith.
Thanks!
@Computergaga
5 жыл бұрын
My pleasure.
Many many thanks
@Computergaga
5 жыл бұрын
You're welcome Ahmed.
Great video!! How do you copy a check box, that has a formula and a rule? Say in this video if wanted to copy a row with the checkbox and all?
@Computergaga
6 жыл бұрын
You cannot really copy them all without a macro. I don't have one to copy them all. But you could copy the checkboxes like in the video, copy the formula and then use the macro in this video to link all the cells automatically - kzread.info/dash/bejne/lWpt2a-uZ8qXhbQ.html
@aalen88
6 жыл бұрын
Thanks for the quick answer! I will give it a try for sure!
@Computergaga
6 жыл бұрын
You're welcome. Thank you.
@aalen88
6 жыл бұрын
You are a legend! It works with the macro! Thank you very much, great videos!
Thanks for your information and very nice 😊
@Computergaga
4 жыл бұрын
Most welcome 😊 Thank you Mohamed.
Thank you.. Helped me alot🙌
@Computergaga
Жыл бұрын
Awesome! You're welcome.
Please can you help to creat data analysis on staff training using excel..?
THANK YOU!
@Computergaga
3 жыл бұрын
You're very welcome.
Thanks a million. Very useful.
@Computergaga
3 жыл бұрын
My pleasure 👍
Thank you!!!!!
@Computergaga
4 жыл бұрын
My pleasure James.
Thank you so much
@Computergaga
4 жыл бұрын
My pleasure.
Clearly explained.👍👍👍
@Computergaga
4 жыл бұрын
Awesome! Thank you Jonathan.
The checkboxes created in this tutorial can't be validated by Microsoft onedrive, because of errors and missing alt text to make the form "more accessible". Are you able to provide a workaround to these problems here in 2018? Thanks in advance for any current updates.
Thanx! But I have a question. I have several columns, and each column is a checklist of it's own. But then if I check the boxes in the second column, all the cells on the same row color at the same time. But I make each list as in the video.. Can you help me with this? I hope to hear from you!
good work ,thanks
@Computergaga
5 жыл бұрын
You're very welcome Ahmed.
nice video, thanks
@Computergaga
3 жыл бұрын
Thank you, Ade.
This was helpful and easy to follow, Mac users add developer ribbon by Excell>Preferences>Ribbon& Toolbar
@Computergaga
3 жыл бұрын
Thank you for the comment and the Mac tip 👍
Thanks. That was very useful.
@Computergaga
3 жыл бұрын
Great to hear. Thank you, Sajede.
Thank you
@Computergaga
5 жыл бұрын
My pleasure Jojo.
This video deserves a like! Helped me😊
@Computergaga
3 жыл бұрын
Great! Thank you very much, Mubeen.
Hello thank you for a very informative video. I did all as you instructed and it all works great. However, now I need to be able to have a function telling me a percentage of how many boxes I have checked vs not. I have spent two days looking all over KZread but to no avail I have not been able to find anything that can help. I seen on one of the comments here that you suggested using the SUMMIF value, can you expand on that. That might be what I'm looking for. thank you.
@tiger131071
3 жыл бұрын
You can use the countif function...Countif values in those cells are True. And divide by the total number of cells for your %age
Excellent Sir
@Computergaga
5 жыл бұрын
Thank you very much.
Wonderful!
@Computergaga
Жыл бұрын
Thank you 😊
ty so much sir
@Computergaga
5 жыл бұрын
You're very welcome Lester.
When i insert the check box i then cant adjust the size of the box or text by dragging the corner as expected, even when i adjust the cell size the check box and text remain very small. Can you advise?
thanks very useful
@Computergaga
5 жыл бұрын
No problem. Happy to help Prasanna.
I'm excel online 360 but when I try editing my document on one drive all of the check marks vanish. Can you help me out with how to make them appear and work on one drive? Thanks in advance for your help on this matter.
Thank you sir
@Computergaga
4 жыл бұрын
You're welcome. Thank you.
very good explanation
@Computergaga
4 жыл бұрын
Thank you Devapujala.
Can the checkbox be reported to another sheet either a completely different Workbook or a TAB Sheet?
My version of Excel (2011 I believe) will let me create check boxes but they're TINY AS ALL GET-GO. I've tried to change the size of the box, all I can do is change the size of the zone the box is in; however, I can not change the size of the box at all.
Thank's man I learnt a new thing 😉
@Computergaga
3 жыл бұрын
Excellent! Happy to help.
I have added checkboxes to my table but am continually adding new rows for new people, I would like the boxes to stay linked to the people so that when I order them based on Last name or first name they stay linked to their owner. Right now they kind of just go all over the place. How could I do that?
If I send this archive to a mobile device or a tablet, will it work?
Would this work with touchscreen pc? A simple ONE touch to highlight or check the box?
@Computergaga
6 жыл бұрын
I believe so. With Excel online or app.
Thank you for uploading the videos but I did not understand clearly so could you make videos more clearly
Thank!!
@Computergaga
4 жыл бұрын
You're welcome, Fabio.
*Hello:If I put an = sign in the cell link field in the format control dialogue box and then click on the little blue button( right of cell link), wouldn't I be able to pick up the whole range A4:A8, rather than having to input these values one-by-one in the f(x) bar?*
@Computergaga
6 жыл бұрын
Unfortunately not.
Once you showed how to add the Developer tab my problems were solved.
@ameerasyafa
6 жыл бұрын
Hope this link will help www.techonthenet.com/excel/questions/developer_tab2013.php
ok so now can I make the check box highlight a cell on another sheet ??
This is an interesting tutorial; it only works when the sheet is unprotected how can I get it to work when I protect sheet
@tryazeve9420
4 жыл бұрын
Only lock the individual cells that you want protected. Then when you protect the sheet only those cells will be protected. By default all cells are locked
Hi, how to do check mark in mobile , its not supported, can you help how to resolve.
great video
@Computergaga
5 жыл бұрын
Thank you very much Hazem.
Dont set font color to white !!!! Use custom number format code ;;; to create a blank format :-) (Format cells...->Number tab->Custom menu-> type ;;; in the box called Type)
useful Video
@Computergaga
2 жыл бұрын
Thank you, Shawon.
THanks
@Computergaga
4 жыл бұрын
My pleasure.
I was able to set up a check list but now I want to have a single check box to clear all the checked boxes . . . but how do you set up a "select all" button to clear all the boxes at the same time? I cannot find anything on youtube. It would be nice to be able to clear all the check boxes and use the list again and again. How do you do that?
@Computergaga
6 жыл бұрын
Hi Lor, thanks for your comment. I have created a video to show you how here - kzread.info/dash/bejne/iXymzrRmlqa8qqg.html
Good MS tutorial, the only drawback is that is started out fuzzy (but eventually sharpened.)
Hi, I create a long list with the tick. Is there a way to make a rest option
@Computergaga
4 жыл бұрын
Sure. I have a video here - kzread.info/dash/bejne/iXymzrRmlqa8qqg.html
is their a way to have the check mark checked then copy the name to another cell in the worksheet
@Computergaga
7 жыл бұрын
This could be achieved with a PivotTable using the column with the True values and filter it to only show trues, and the name in the rows area. Alternatively a macro could be set up to do this.
Nice video
@Computergaga
2 жыл бұрын
Thank you 😁