How to Add a Checkbox in Google Sheets

Adding a checkbox takes three clicks

Open the cells where you want checkboxes. Select the range — click one cell, then drag to select multiple, or click the first cell and shift-click the last one. Go to the Insert menu at the top, then click Checkbox. Google Sheets fills those cells with empty boxes you can click to mark complete.

The checkbox appears as a small square. Click it once to add a checkmark. Click again to remove it. You can sort and filter by checkbox status, which makes them useful for tracking task lists, inventory status, or anything with a yes-or-no state.

Key Takeaways

Select your cells first, then use Insert > Checkbox to add boxes in one step.
Checkboxes store TRUE (checked) or FALSE (unchecked) as values, so you can count them with formulas.
You can filter a sheet to show only checked or unchecked rows, which helps you focus on what still needs work.
Checkboxes work the same way on desktop and mobile, and they sync when ready across devices.

Using formulas to count checked boxes

When you add a checkbox, Google Sheets stores it as TRUE (checked) or FALSE (unchecked). You can count how many boxes are checked using the COUNTIF function. Type =COUNTIF(A1:A10,TRUE) in an empty cell to count all checked boxes in that range.

This is useful for progress tracking. If you have a task list with checkboxes in column A, you can put a formula in another cell that says "5 of 10 tasks done" by counting the TRUE values. You can also use SUMPRODUCT to count checked boxes: =SUMPRODUCT(--(A1:A10=TRUE)) does the same thing and works in more complex situations.

Filtering to show only checked or unchecked items

Once you have checkboxes, you can filter the sheet to display only the rows you want. Click the filter icon (a funnel shape) at the top of your data. A small arrow appears in each column header. Click the arrow in your checkbox column.

You will see options to show only checked boxes, only unchecked boxes, or both. This is faster than scrolling through a long list. If you have a shopping list with 50 items and 30 are already checked, filter to show only unchecked items so you can focus on what you still need to buy.

Changing checkbox labels or values

By default, Google Sheets uses a checkmark symbol for checked and leaves the box empty for unchecked. You can customize this. Select your checkbox cells, go to Insert > Checkbox again, and a dialog box opens. Instead of the default checkmark, you can type custom text or symbols for the checked state — for example, "Yes" or "Done" or "✓".

You can also set what appears when the box is unchecked. Leave it blank, or type "No" or "Pending". The unchecked value is what Google Sheets stores as FALSE. Custom labels make your sheet easier to read at a glance, especially if you are sharing it with others who may not be familiar with your system.

Checkboxes in conditional formatting and data validation

Checkboxes work well with conditional formatting, which changes how a cell looks based on its value. Select a range of cells, go to Format > Conditional formatting, and set a rule: if the checkbox column is TRUE, highlight that row in green. If FALSE, highlight it in gray. This gives you a visual way to spot completed tasks without reading every cell.

You can also use checkboxes alongside data validation to control what goes in other columns. For example, if someone checks a box in column A, you might require them to fill in a reason in column B. Set up data validation rules to enforce this, so your sheet stays organized and complete.

Copying checkboxes to other sheets or templates

If you build a task list with checkboxes and want to reuse it, copy the cells with checkboxes to a new sheet or save the sheet as a template. The checkboxes copy as-is — they do not reset to unchecked. If you want a fresh copy with all boxes unchecked, select the checkbox cells, go to Insert > Checkbox, and choose the unchecked state you want before copying.

You can also create a template in Google Sheets and share it with your team. Each person who uses the template gets their own copy with blank (unchecked) boxes ready to fill in. This is faster than sending the same sheet back and forth and asking people to clear old checkmarks.

Troubleshooting common checkbox problems

If you paste data into cells that already have checkboxes, the checkboxes may disappear. To fix this, undo the paste, then use Paste special (Ctrl+Shift+V on Windows, Cmd+Shift+V on Mac) and choose Paste values only. This keeps your checkboxes intact while adding the new data.

If a checkbox is not responding when you click it, make sure the sheet is not in edit mode for that cell. Click elsewhere first, then click the checkbox. If the sheet is protected or shared with view-only access, you will not be able to check boxes — the owner must give you edit permission. On mobile, checkboxes work the same way, but the touch target is small; tap directly on the box itself.

Frequently Asked Questions

Can I use checkboxes in a formula to do something else?

Yes. You can use IF statements with checkbox values. For example, =IF(A1=TRUE,"Complete","Incomplete") displays text based on whether the box is checked. You can also use checkboxes to trigger other calculations or hide rows based on their status.

What happens to checkboxes when I sort the sheet?

Checkboxes sort like any other data. If you sort by the checkbox column, all checked boxes move to the top (or bottom, depending on your sort order), and unchecked boxes follow. This is useful for grouping completed and incomplete tasks together.

Can I add checkboxes to a shared Google Form response sheet?

No. Google Forms creates a response sheet automatically, and you cannot add checkboxes to the form responses themselves. However, you can add checkboxes to a separate column next to the responses to track your own progress or status.

Do checkboxes work in Google Sheets on my phone?

Yes. Checkboxes work on mobile devices the same way they do on desktop. Tap the checkbox to toggle it on or off. The changes sync when ready to the cloud, so anyone else viewing the sheet sees the update right away.

Can I make a checkbox required, so people have to check it before submitting?

Checkboxes in Sheets itself are not required fields. If you need to enforce that someone checks a box, use Google Forms instead, which has a required checkbox option built in. You can then link the form responses to a Sheet.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.