Did you know Excel can do much more than formulas and tables? In fact, you can also make to-do lists, but it is more complex than making a supermarket list. In Excel, a checkbox can be even more advanced than you can imagine, and you can use it for organizing your data at a higher level. Keep reading because here you'll learn how to use a checkbox in Excel.
After importing a checkbox which is the first step, you must link them to a cell that will track whether the box is checked. Otherwise, they won't work. For that, you need to do the following:
Remember that the cell you will link needs to be different from the cell containing the statement or phrase. Example:
It's essential to choose another location so that each check box's "TRUE/FALSE" result will appear.
So, now in the third column, the linked cells will show you "TRUE" when the checkbox is checked and "False" when you uncheck it.
Another thing you can do when using a checkbox is the number count of completed tasks using the "COUNTIF" formula by typing the following syntaxis:
So, for example, if you have a checklist from cell B1 to B5, the formula will be:
But if you only have three checkboxes of that range of cells with the logical result as "TRUE," which means checked, then the result of that formula will equal three.
Note: You can do this count in any cell you prefer.
Conditional formatting is roughly an aid you can apply to your data depending on a few conditional rules you want to lay out. Hence, when using checkboxes, you can ask Excel to do a particular action like changing the cell color, strikethrough the statement, etc. When the logical result equals "TRUE."
Let's give a simple example of the strikethrough operation:
Note: If we use the first example, then the cell you must choose is the C1 because the A1 corresponds to the statement, B1 to the checkbox, and C1 the linked cell to the formula.
Alright! After this process, you must copy this formatting, but you can't do it with the basic commands (Ctrl + C and Ctrl + V). You must:
There you have it! Now nothing can stop you. Try it yourself and use as many checkboxes as you want. Good Luck!