Create an Interactive Checklist in Excel
HTML-код
- Опубликовано: 22 авг 2024
- Create an interactive checklist in Excel that automatically marks items when they are completed.
Master Excel today with this comprehensive course - bit.ly/Ultimat...
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.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
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
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.
Thanks Damian, your comments are very much appreciated.
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!
Excellent. Nice work.
THANK YOU.
YOU ARE A FANTASTIC INSTRUCTOR AND IT WAS A GREAT EXPERIENCE.
You're welcome. Thank you very much.
Thanks for this video. Deleting multiple checkboxes however is an incredible pain. Using Google Sheets is far more simpler!!!!
This was helpful and easy to follow, Mac users add developer ribbon by Excell>Preferences>Ribbon& Toolbar
Thank you for the comment and the Mac tip 👍
Thank you sir for the simplicity of your video. Very easy to follow.
Great to hear. Thank you, Olubayo.
Great video! East to understand and follow and I could readily imagine different uses for it.
Thank you.
THANK YOU!
You're very welcome.
Thank you so much. This is useful
Glad it was helpful!
Many many thanks
You're welcome Ahmed.
This video deserves a like! Helped me😊
Great! Thank you very much, Mubeen.
Thank you.. Helped me alot🙌
Awesome! You're welcome.
Great video! Helped me make a great looking checklist, thanks!!
Glad it helped!
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!
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)
Thank you very much, this just made my job easier.
Your welcome Chazmonique.
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!
Cheers Wayne.
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.
Jason Statham gives really clear and concise Excel tutorials
😊
Thank you for wary useful tools and good explanation.
You are welcome, Nino 👍
This is how you can create check boxes and assign them to their respective cells automatically:
Sub AddCheckBoxes()
Dim cb As CheckBox
Dim myRange As Range, cel As Range
Dim wks As Worksheet
Set wks = Sheets("mySheet") 'adjust sheet to your needs
Set myRange = wks.Range("A1:A10") ' adjust range to your needs
For Each cel In myRange
Set cb = wks.CheckBoxes.Add(cel.Left, cel.Top, 30, 6) 'you can adjust left, top, height, width to your needs
With cb
.Caption = ""
.LinkedCell = cel.Address
End With
Next
End Sub
Thanks that helps a lot. Is there a way to do this on the fly? like a shortcut version that will apply to all selected cells?
Very Good Instructions. Straight to the point with no fluff added. Just the way I like it :o)
Thank you.
Love it! Thanks
My pleasure. Thank you.
Wonderful!
Thank you 😊
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?
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 - ruclips.net/video/c69wMu7g1UQ/видео.html
Thanks for the quick answer! I will give it a try for sure!
You're welcome. Thank you.
You are a legend! It works with the macro! Thank you very much, great videos!
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
Thanks.
That was very useful.
Great to hear. Thank you, Sajede.
Thanks a million. Very useful.
My pleasure 👍
Thank you very much - Very easy and informative...
You're welcome. Thank you.
nice video, thanks
Thank you, Ade.
wow, superb! I loved it... Thank you so much for this video.
My pleasure Dev. Thank you.
Thanks, very helpful!
You're welcome Linda, thanks.
Dude... You are Awesome.
Salute...!!!
Thank you Abhi.
Wow I learnt something very useful @work life thanks for the video and simple and explained clearly...
Great to hear. Thank you.
Thanks man, this is very interesting.
Hello Computergaga thank you for producing such a clear and concise tutorial. I look forward to coming back.
You're welcome James, 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 so much!!! It’s like a big accomplishment for me, a huge step to success, I seriously seriously appreciate to it sir!!!!!
You're very welcome. Happy to help.
good work ,thanks
You're very welcome Ahmed.
Thanks for the video. is there anyway to change the size of the actual check boxes?
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.
Good MS tutorial, the only drawback is that is started out fuzzy (but eventually sharpened.)
Thank you sir
You're welcome. Thank you.
Thanks for your information and very nice 😊
Most welcome 😊 Thank you Mohamed.
Can the checkbox be reported to another sheet either a completely different Workbook or a TAB Sheet?
Please can you help to creat data analysis on staff training using excel..?
Thanks, it is a good explanation
Thanks Mazen.
Thank u for sharing something interesting.
Your welcome James
Clearly explained.👍👍👍
Awesome! Thank you Jonathan.
awesome! can you adjust the size of the text box?
Please provide a video on passing cell range in excel
Hi Megha, do you have a specific example?
@@Computergaga
Actually I was trying to make an attendance sheet and trying to pass common data using this range Passi g thing. But failed at certain points, so just need guidance to make corrections and learn it
Very usefull and so smart with this colore
very good explanation
Thank you Devapujala.
thanks
You're welcome Agung.
Thanks man, this solved my problem!!!
If I send this archive to a mobile device or a tablet, will it work?
Once you showed how to add the Developer tab my problems were solved.
Hope this link will help
www.techonthenet.com/excel/questions/developer_tab2013.php
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!
How would you add a Select All check Box so that you can Check and un check all at the same time?
I have a video on how to do that here - ruclips.net/video/WHrlR-fCVzE/видео.html
Thank you for your comment Lor.
Very Important & Usefull
Thank you Syed.
This is an interesting tutorial; it only works when the
sheet is unprotected how can I get it to work when I protect sheet
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
Thank's man I learnt a new thing 😉
Excellent! Happy to help.
Worked awesome, thanks!
My pleasure Michael.
Wonderful. Thanks mate
Your welcome Syed, thank you.
thanks a lot! Awesome. so easy to understand. love it>>>>>
Thank you very much Mehrdad.
very helpful .thanks
You're welcome Bamidele
Nice video
Thank you 😁
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 you so much for this video. It was very helpful.
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.
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 RUclips 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.
You can use the countif function...Countif values in those cells are True. And divide by the total number of cells for your %age
ok so now can I make the check box highlight a cell on another sheet ??
Thanks!
My pleasure.
useful Video
Thank you, Shawon.
Great explanation! Thanks a lot :)
Your welcome Vijay.
Thanks a lot
You're welcome Asaraf.
Thank you mate
Your welcome Simphiwe, thanks.
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 so much
My pleasure.
thanks very useful
No problem. Happy to help Prasanna.
Excellent Sir
Thank you very much.
ty so much sir
You're very welcome Lester.
Thank!!
You're welcome, Fabio.
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?
Thank you
My pleasure Jojo.
great video
Thank you very much Hazem.
Great video in did! Thank you very much for the offer!
You're very welcome.
Hi, I create a long list with the tick. Is there a way to make a rest option
Sure. I have a video here - ruclips.net/video/WHrlR-fCVzE/видео.html
Thank you!!!!!
My pleasure James.
*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?*
Unfortunately not.
Hello I am attempting to due a multi value checkbox but I don't know how. We have equipment that needs to be checked every other day. I would like to have a box that can give four values M for missing, X for in service, 0 for out of service and an unchecked box. Perhaps you know a way and if you do could you please ether write back or make a video I find them very educational. Thank you and good day.
Thank you. A checkbox is either True or False. So for 3 options you would be looking at using 3 option buttons, listbox or a combo box.
Helped me!
Great to hear, thanks.
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?
God.......its so much easy to do in google sheets.......ill never go for excel....
That's a shame
Can you make the names show color when the check box is unchecked and remove the highlight once it is checked?
Sure. Same idea, just changing font colour instead of the cell colour. It will be false if unchecked and true if checked.
@@Computergaga Sorry, I realized I asked that wrong. What I'm looking to do is highlight the cells when the checkbox is unchecked and to remove the highlight when the checkbox is checked.
very well
Hi, how to do check mark in mobile , its not supported, can you help how to resolve.
Nice 😍😍😍😍😍😍
Thanks 🤗
THanks
My pleasure.
HOW DO YOU take a value of true from a check box to add and don't add different rows?
Would this work with touchscreen pc? A simple ONE touch to highlight or check the box?
I believe so. With Excel online or app.