Using Check boxes in Excel

Using Check boxes in Excel

The following tutorial will show you how to use Check boxes in Excel. You can use check boxes are ways of displaying text or figures that can be used in multiple formulas. In the example below, I have created a simple Shipping Log which indicates with a particular part number has been “Loaded” or still remains “Unloaded.”

Download Sample File

First, please refer to the previous tutorial on creating Check boxes in Excel.

check boxes in excel

Next, Right click on the Check Box and select “Format Control”

check boxes in excel

In the Format Control window, you need to assign which cell will be selected for both the unchecked and checked status. In my example, I selected $D$4.

Now, if you select the checkbox, it will display “True” in cell D4. If unchecked, it will display “False”

To use the inputs in a formulation, you have to use the “True” result as the input. In my example, I used a simple “IF Statement” to demonstrate how to indicate whether a particular part has been loaded to a truck.

check boxes in excel

Was this article helpful?

Related Articles

Leave a Reply