Add and use tick boxes

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

Insert tick boxes

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells that you want to have tick boxes for.
  3. In the menu at the top, click Insert and then Tick box.
  4. To remove tick boxes, select the tick boxes that you want to remove and press Delete.

Note: You can use tick boxes with charts, filters, pivot tables and functions.

Add custom tick box values

You can add tick boxes with custom values. For example, the custom ticked value could be 'Yes', and the unticked value could be 'No'.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells that you want to have tick boxes for.
  3. In the menu at the top, click Data and then Data validation.
  4. Next to 'Criteria', choose Tick box.
  5. Click Use custom cell values.
  6. Next to 'Ticked', enter a value.
  7. Optional: Next to 'Unticked', enter a value.
  8. Click save.

Related articles

Was this helpful?
How can we improve it?