Creating Checkboxes

Adding Checkboxes

Adding checkboxes allows you to create interactive elements for selection within cells.

• Select the cells where you want to insert checkboxes;
• Go to the Insert menu → Checkbox.

After that, checkboxes will appear in the selected cells. When the checkbox is checked, it represents the value TRUE, and when unchecked, it represents FALSE.

Setting Checkbox Values

Setting checkbox values allows you to assign custom parameters for checked and unchecked states.

• Go to the Data menu → Data validation;
• Click on the desired cell and check the Use custom cell values option;
• In the menu that appears, you can set values for the checked and unchecked states (for example, Yes and No instead of TRUE and FALSE);
• Click Done to apply the changes.

Suppose we have a checkbox in cell A1. Then, if we reference the checkbox in a formula using =A1, we will get the value of that cell.