Insert checkboxes
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells you want to have checkboxes.
- In the menu at the top, click Insert Checkbox.
- To remove checkboxes, select the checkboxes you want to remove and press Delete.
Note: You can use checkboxes with charts, filters, pivot tables, and functions.
Add custom checkbox values
You can add checkboxes with custom values. For example, the custom checked value could be "Yes," and the unchecked value could be "No."
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells you want to have checkboxes.
- In the menu at the top, click Data Data validation.
- Next to "Criteria," choose Checkbox.
- Click Use custom cell values.
- Next to "Checked," enter a value.
- Optional: Next to "Unchecked," enter a value.
- Click Save.