Insert checkboxes

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells you want to have checkboxes.
  3. In the menu at the top, click Insert and then Checkbox.
  4. 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."

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells you want to have checkboxes.
  3. In the menu at the top, click Data and then Data validation.
  4. Next to "Criteria," choose Checkbox.
  5. Click Use custom cell values.
  6. Next to "Checked," enter a value.
  7. Optional: Next to "Unchecked," enter a value.
  8. Click Save.