Checkboxes and status chips in cells

Updated November 13, 2026

Checkboxes and chips make a list easy to tick off and scan. Both are saved the way Excel 365 keeps them.

A to-do list with status chips and ticked checkboxes

Add checkboxes

  1. Select the cells.
  2. Choose Insert › Checkbox.
  3. Click a box to tick it, or press Space on the cell. A ticked box is TRUE and an empty one FALSE, so formulas such as =COUNTIF(C2:C20,TRUE) count them.

Show a list as chips

  1. Select the cells and choose Data › Validation.
  2. Under Allow, choose List and type the choices, separated by commas.
  3. Turn on Show as chips, then choose OK.
  4. Click a chip to pick another choice from its list. Each choice keeps its own colour.

Tips

  • The To-do list template in File › New… already has both.
  • Remove checkboxes: select the cells and press Delete. Ticked boxes are unticked first; press Delete again to take the boxes off.

Was this article helpful?