To remove multiple checkboxes in Google Sheets, select all the cells that contain them and press Delete (or Backspace). The checkboxes disappear along with their checked or unchecked values. If you only want to uncheck them and keep the boxes, select them and press the Spacebar instead.
Quick Answer
Select the checkbox cells > press Delete.
Remove Checkboxes
- Click the first checkbox cell and drag to select the rest. Hold Ctrl (Command on a Mac) to add cells that aren’t next to each other, or click the column letter to select a whole column.
- Press Delete or Backspace.
If Delete Doesn’t Remove Them
Pressing Delete on checked boxes sometimes just unchecks them first. Press Delete again, or remove the rule that creates them:
- Select the cells.
- Click Data > Data validation.
- Click the checkbox rule, then Remove rule.
Checkbox Actions at a Glance
| Goal | How |
|---|---|
| Remove checkboxes | Select and press Delete, or remove the data validation rule |
| Uncheck all | Select checked boxes and press Spacebar |
| Check all | Select unchecked boxes and press Spacebar |
| Add checkboxes | Insert > Checkbox |
| Count checked boxes | =COUNTIF(B2:B20, TRUE) |
Before cleaning up a list, sort by several columns.
Troubleshooting
- Spacebar toggles only some boxes: Mixed selections toggle each box individually. Select only checked (or only unchecked) boxes.
- Can’t delete: The range may be protected. Check Data > Protect sheets and ranges.
- Checkboxes come back: A formula or script may be adding them, or someone else is editing.
- Want to highlight completed rows? Use conditional formatting; see changing cell color in Google Sheets.
Related: How to uncheck all boxes in Google Sheets.
Frequently Asked Questions
Does deleting checkboxes delete the data in other columns?
No. Only the selected cells are cleared.
Can I undo it?
Yes. Press Ctrl + Z (Command + Z) right away.
Summary
- Select the checkbox cells.
- Press Delete to remove them.
- Use Data validation > Remove rule if needed.
- Use Spacebar to uncheck without removing.
Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.