Create an Interactive Checklist in Excel

Create an interactive checklist in Excel that automatically marks items when they are completed.

In this video tutorial, you will see how to insert checkboxes in Excel, link them to cells and then automatically format them when completed.

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;

*** Online Excel Courses ***

Connect with us!

[damiandellamico]

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.

[snip-sniptear]

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!

[george]

THANK YOU.
YOU ARE A FANTASTIC INSTRUCTOR AND IT WAS A GREAT EXPERIENCE.

[OOlasokan]

Thank you sir for the simplicity of your video. Very easy to follow.

[samuela.goldstein]

Thanks for this video. Deleting multiple checkboxes however is an incredible pain. Using Google Sheets is far more simpler!!!!

[westsideproduction]

This was helpful and easy to follow, Mac users add developer ribbon by Excell>Preferences>Ribbon& Toolbar

[Teacherman]

Great video! East to understand and follow and I could readily imagine different uses for it.

[chazmonique]

Thank you very much, this just made my job easier.

[kounoupaki]

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!

[ninokiknadze]

Thank you for wary useful tools and good explanation.

[dgh]

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)

[mubeenahmedali]

This video deserves a like! Helped me😊

[prasannankinaruvilayil]

Thank you very much - Very easy and informative...

[wayneedmondson]

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!

[jadeprime]

Great video! Helped me make a great looking checklist, thanks!!

[backendadmin]

Dude... You are Awesome.
Salute...!!!

[liviuc]

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.

[devmalya]

wow, superb! I loved it... Thank you so much for this video.

[santoshbansal]

Thanks man, this is very interesting.

[aalen]

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?