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 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.

Related articles

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false