Check box

by Easy Excel Tutorials May 31, 2022

Check box in Excel

In this lesson you will learn how to insert check box to the worksheet In Excel. Check box enables or disables a value indicating alternatives with a specific meaning. In the worksheet or in a group box you can tick more than one box at a time. The check box can be used, for example in the order form containing a list of available products or inventory tracking application to indicate whether a particular product has been discontinued. Go to the Ribbon > Developer tab.

Click Insert and select a form control check box and place it on the sheet. insert Check Box

By right-clicking on a control you can edit the name of the button, the assigned macro, and other parameters. Click the Format Control.

Checkbox Format Control

You will see a window object formatting. Go to the tab control fill in the cell link pointing to a cell in the spreadsheet link eg C2 and click OK.

Checkbox Cell Connected

You connected a link to cell C2, which according to click on a checkbox appears logical value “TRUE” or “FALSE”.

False

Checkbox false

True

Checkbox true

To handle such a logical value eg to display text information you can use IF function formula:

=IF(C2=TRUE,”AVAILABLE”,”UNAVAILABLE”)

Template

You can download the Template here – Download

Further reading: 
Basic concepts 
Getting started with Excel
Cell References

Check box

Check box in Excel

Template

Avoid Errors Using IFERROR-Everyone Should Know

Linking Text Box To A Specific Cell

You may also like