How to Uncheck All Boxes in Google Sheets

Checkboxes in Google Sheets are great for task lists, attendance sheets, and trackers, but clicking dozens of them one at a time to reset the list gets old fast. Sheets has a few faster ways to clear them all at once. The most reliable is selecting the checkboxes and pressing Delete, which unchecks them without removing the boxes. This guide covers that method, the Space bar toggle, filling in FALSE, and how to reset checkboxes automatically.

Quick answer

Select all the cells with checkboxes and press Delete (or Backspace). Every box becomes unchecked, and the checkboxes stay in place.

How checkboxes work in Sheets

A checked box holds the value TRUE and an unchecked box holds FALSE. That’s why you can uncheck boxes by changing their values, and why formulas like =COUNTIF(B2:B50,TRUE) can count checked items.

Method 1: Select and press Delete

1. Click the first checkbox cell and drag to select all of them. To select a whole column, click its letter at the top. Hold Ctrl (or Command on a Mac) to add separate ranges.
2. Press Delete or Backspace.

All the selected boxes are unchecked. The checkboxes themselves stay, because they’re part of the cells’ data validation. If you also selected cells that contain text or numbers, that content is deleted, so select only the checkbox cells.

Method 2: Toggle with the Space bar

Select the checkbox cells and press Space. Sheets toggles the selected boxes. This works perfectly when every box is checked, because they all become unchecked. If your selection is a mix of checked and unchecked boxes, the result may not be all unchecked, so check the column afterward and use Method 1 if needed.

Method 3: Fill the range with FALSE

1. Select the checkbox cells.
2. Type FALSE.
3. Press Ctrl + Enter (Command + Enter on a Mac) to fill every selected cell.

This is useful if your checkboxes use custom values. In that case, type the custom “unchecked” value instead of FALSE.

Method 4: Reset checkboxes automatically

For a daily checklist, you can reset boxes on a schedule with Apps Script:

1. Go to Extensions > Apps Script.
2. Paste a short function such as:
   function resetChecks() { SpreadsheetApp.getActive().getSheetByName('Tasks').getRange('B2:B50').uncheck(); }
3. Change the sheet name and range to match yours, then click Save.
4. Click the clock icon (Triggers), add a trigger for resetChecks, and choose Time-driven > Day timer.

Google asks you to authorize the script the first time it runs. You can also assign the function to a drawing or button so anyone can reset the list with one click.

Remove the checkboxes entirely

If you want the boxes gone, not just unchecked, select the cells and go to Data > Data validation, then remove the rule. See removing multiple checkboxes in Google Sheets.

Tips

• Make a copy of the sheet before resetting a big tracker, in case you need last week’s results.
• Use conditional formatting to strike through or shade rows when their box is checked.
• Need more checkboxes? See inserting a checkbox in Google Sheets.

Frequently asked questions

Why did pressing Delete remove my checkboxes?

If you selected cells that only looked like checkboxes, such as check mark symbols or images, Delete clears them. Real Sheets checkboxes come from Insert > Checkbox or a checkbox data validation rule, and they stay in place when you press Delete.

Can I uncheck boxes on the Google Sheets mobile app?

Yes. Select the range, tap it to open the menu, and choose Clear or Delete (wording varies by device). You can also tap each box individually.

How do I check all boxes instead?

Select the range, type TRUE, and press Ctrl + Enter. Or select the unchecked boxes and press Space.

Will unchecking change my formulas?

Formulas that count or filter checked items update right away, which is usually what you want for a reset.

Summary

1. Select the checkbox cells.
2. Press Delete to uncheck them all.
3. Or type FALSE and press Ctrl + Enter.
4. Use Apps Script with a trigger for automatic daily resets.