|
Use checkboxes to make Google Sheets more interactive. You can use checkboxes with charts, filters, pivot tables, and formulas. Examples
|
Add or remove checkboxes
- In Sheets, open a spreadsheet and select the cells where you want checkboxes.
- Click Insert
Checkbox.
- (Optional) To delete checkboxes, select the checkboxes you want to remove and press Delete.
Note: In formulas, unselected checkboxes have a value of FALSE (exclude) and selected checkboxes have a value of TRUE (include). You can see the value in the Formula bar. You can also change this value.
Add custom values in checkboxes
- In Sheets, select the cells you want to have checkboxes.
- Click Data
Data validation.
- Next to Criteria, choose Checkbox.
- Select the Use custom cell values box.
- Next to Checked, enter a value.
- (Optional) Next to Unchecked, enter a value.
- Next to On invalid data, choose a validation option.
- (Optional) To show a validation message when someone hovers over the checkbox, next to Appearance, select Show validation help text and enter your message.
- Click Save.