Add & use checkboxes

You can add checkboxes to cells in a spreadsheet. Use checkboxes for many purposes, like to track a project, take attendance, and check off your to-do list.

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 Checkboxes.
  5. Click Use custom cell values.
  6. Next to "Checked," enter a value.
  7. Optional: Next to "Unchecked," enter a value.
  8. Click Save.

Related articles

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?