Neha is a software professional with 13+ years of experience in the IT Industry. She enjoys writing technical tutorials.
How Do I Add a Checkbox Linked to a True or False Value in Excel? (3 Easy Steps)
Are you looking for a way to add a checkbox in a Microsoft Excel Worksheet and link it to a cell and automatically generate a true or false value based on the checkbox selection?
Here's a quick and easy article to help you learn how to do that, explained with easy steps to follow.
1. Enable the Developer Tab
The developer tab is a feature that comes with the Microsoft Excel Workbooks, and it is typically inactive by default. This feature allows the Microsoft Excel users to perform various complex activities including designing forms, creating macros, etc.
The developer tab in Microsoft Excel is not active by default. But you can easily enable it yourself.
How to Enable the Developer Tab in Microsoft Excel
- In your Microsoft Excel Workbook, look for the File menu in the menu bar and go to Options.
- Click on Options and a new window with Excel Options opens up.
- Go to Customize Ribbons > Main Tabs > and check the checkbox for Developer.
- This enables the developer tab in the Microsoft Excel Workbook.
Please note that this option will now stay enabled as long as you do not remove it manually or install any Excel updates. If either of those things happens, there is a chance that this tab will disappear and you may have to add it back should you need it.
2. Insert the Checkbox
It is very easy to insert a checkbox in excel using the Developer tab. On the developer tab,
- Click on Insert.
- Select Check Box (Form Control).
- Click on the cell where you would like to add the checkbox. In our case, let's add it to C2.
- This adds the checkbox to the selected cell. Repeat the above steps (1 to 3) wherever you would like to add a checkbox. In our case, repeat the steps for C3, C4, C5, and C6.
- This comes in very handy when you are creating forms, checklists, project plans, tasks lists, to-do lists, etc. in Excel.
- You can either keep the default label or choose to change the label of the checkbox or entirely remove it. This can be achieved using the Edit Text option. Right-click on the checkbox and select Edit Text to change or remove the label.
3. Link the Checkbox to the True or False Value
Linking the checkbox to a true or false value in Excel creates an automatic correlation between the check box and the value.
Meaning, when the checkbox is checked, the linked cell value is true. When the checkbox is unchecked, the linked cell value is false.
How to Link the Checkbox to a Cell to Generate an Automatic True/False Value:
- Right-click on the checkbox
- Click on Format Control
- This opens up a Format Object window
- Click on Cell Link and select the cell you would like to link with the checkbox. In our case, select D2 and we would like to link C2 with D2.
Repeat the above steps for the remaining checkboxes and link C3 with D3, C4 with D4, C5 with D5, and C6 with D6 respectively.
Congratulations! You have successfully learned how to create a checkbox and link it to a cell that automatically generates a true or false value like a pro.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2021 Petite Hubpages Fanatic