Check boxes turn a spreadsheet into a tracking tool

A check box in Google Sheets is a small square you can click to mark something done. When you click it, it fills in or shows a checkmark. When you click again, it empties. Google Sheets calls this an interactive checkbox, and it lives in a single cell — you can have one per cell, or leave cells blank if you don't need them.

Check boxes are useful when you're tracking whether something is finished: a to-do list, items to buy, tasks assigned to team members, or boxes on a form. They're faster than typing "yes" or "no" or "done" in a cell, and they make it obvious at a glance which items are complete.

Key Takeaways

  • Check boxes are inserted through the Insert menu, one cell at a time or across multiple cells at once.
  • You can set what a checked box displays — a checkmark, the word "TRUE", or a custom word like "Done".
  • Unchecked boxes show the opposite — blank, "FALSE", or a custom word like "Not started".
  • Check boxes work in shared sheets, so team members can check off their own tasks without editing the text.

How to insert a single check box

Click the cell where you want the check box to appear. Go to the Insert menu at the top, then click Checkbox. A check box appears in that cell. Click it to toggle it on and off.

That's the whole process for one box. If you want to add check boxes to multiple cells in a column or row, select all those cells first — click the first one, hold Shift, and click the last one — then go to Insert and click Checkbox. Google Sheets adds a box to every selected cell at once.

What a checked box displays

By default, a checked box shows a checkmark and an unchecked box shows nothing. But you can change what appears. When you insert a check box, a small dialog box opens with three fields: one for the checked state, one for the unchecked state, and a dropdown to choose the format.

The dropdown offers three options: Checkbox (the default, showing a checkmark or blank), TRUE/FALSE (showing the word TRUE when checked, FALSE when not), or Custom cell values (where you type your own words). If you choose Custom, type what you want to see when it's checked in the first field — for example, "Done" or "Completed" — and what you want to see when it's unchecked in the second field, like "Not started" or "Pending".

Click Insert when you're done. The check box appears with your chosen display format.

Changing a check box after you've created it

If you want to change what a check box displays after you've already inserted it, right-click the cell containing the box. Click Edit the checkbox from the menu. The same dialog opens, and you can change the checked and unchecked values, or switch the format type.

You can also delete a check box this way — right-click and select Delete the checkbox. The cell becomes blank again.

Using check boxes in a shared sheet

Check boxes work well in sheets you share with others because clicking a box doesn't require editing permissions the way typing does. If you've shared a sheet with view-only access, people with that access level cannot click check boxes. But if you've given them edit access, they can click boxes without being able to change the text in other cells — you can set up a sheet where only certain columns have check boxes, and other columns are locked or protected.

When someone clicks a check box, the change appears when ready for everyone viewing the sheet. This makes check boxes useful for team task lists, sign-up sheets, or inventory tracking where multiple people need to mark items as done or present.

Combining check boxes with formulas

Check boxes store their state as TRUE (checked) or FALSE (unchecked) in the background, even if they display as checkmarks or custom words. This means you can write formulas that count how many boxes are checked, or that do something else based on whether a box is checked.

For example, if you have check boxes in column A and you want to count how many are checked, you can write =COUNTIF(A:A, TRUE) in another cell. If you want to sum the values in column B only for rows where the check box in column A is checked, you can use =SUMIF(A:A, TRUE, B:B). These formulas update automatically as people check and uncheck boxes.

When check boxes are better than other options

A check box is faster than typing if you're marking many items as done or not done. It's also clearer — a checkmark is when ready recognizable, while "yes" or "complete" requires reading. Check boxes are better than a dropdown if you only have two states (done or not done), because a dropdown takes more clicks and more space.

Check boxes are not the right choice if you need to track more than two states — for example, "not started," "in progress," and "done." For that, use a dropdown list instead. Check boxes also don't work well if you need to add notes or dates — if you need to record when something was completed, add a separate column for the date and use the check box to mark completion.

Frequently Asked Questions

Can I copy a check box from one cell to another?

Yes. Click the cell with the check box, copy it (Ctrl+C or Cmd+C), then select the cells where you want it and paste (Ctrl+V or Cmd+V). The new cells get check boxes with the same display format. If you want to copy the check box but not the cell's other formatting, use Paste Special and choose Paste Format Only.

What happens to a check box if I delete the row it's in?

The check box is deleted along with the row. If you want to keep the check box but remove the data in other columns, delete the content of those cells instead of deleting the row itself.

Can I make a check box that other people can't uncheck?

Not directly through the check box feature. But you can protect the sheet and allow editing only in certain columns. Go to Data, then Protect Sheets and Ranges, and set up a range that includes only the columns you want people to edit. Other columns, including ones with check boxes, become read-only.

Do check boxes work on mobile or in the Google Sheets app?

Yes. Check boxes work the same way on mobile as on desktop — tap the cell to toggle it on and off. The mobile app supports all the same check box formats as the web version.