Google Sheets: Add Checkboxes to Cells and Use Them

To add a checkbox in Google Sheets, select the cell or range, then choose Insert > Checkbox. Click a box to check or uncheck it; by default, checked cells have the value TRUE and unchecked cells have the value FALSE, so you can also use them in formulas.

Add a Checkbox in a Few Steps

In Google Sheets in a web browser, a checkbox is an in-cell option. You do not need to draw a shape or insert an image. To add one:

Select the cell where you want the checkbox. To add several at once, select the full range first, such as B2:B20.
Open Insert > Checkbox.
Click a checkbox to switch between checked and unchecked.

Sheets places a checkbox in each selected cell. For a simple to-do list, you might put task names in A2:A10 and select B2:B10 before inserting the boxes. Each task then has a corresponding checkbox in column B. You can also insert a checkbox in a single cell and copy and paste that cell to other locations, although selecting the full destination range and using the menu is often simpler.

If you do not see the checkbox in the spot you expect, check that you selected the intended cell or range before using the menu. A checkbox may be hard to notice in a narrow column, so widening the column or increasing row height can make it easier to use.

What a Checkbox Stores

A checkbox is more than a visual symbol: it is a cell with a checkbox validation rule and a value. With the default settings, checking it assigns the logical value TRUE, while clearing it assigns FALSE. These values are useful because a formula can test them directly. For example, a checked task can count as complete without requiring you to type a separate word such as “Done.”

Clicking the box changes its state. Depending on where you click within the cell, you may instead select the cell, so click directly on the checkbox to toggle it. You can also use the keyboard to work with selected cells: press the space bar to toggle a selected checkbox. The cell’s value, rather than its appearance, is what formulas and other spreadsheet features use.

Checkboxes do not automatically create a task list, enforce a workflow, or stop someone from editing nearby cells. They are a convenient input method. Labels, formulas, permissions, and formatting are separate parts of how you design the sheet.

Add Checkboxes to a Range or List

For a list, select the whole checkbox range before choosing Insert > Checkbox. This is helpful when you want a consistent column of controls, such as a completion column beside a set of assignments. If you already have a list and add more rows later, select the new cells and repeat the same menu command.

Before inserting boxes, consider whether every row should have one. A header row, totals row, or explanatory note generally should not be included in the selected range. For example, if row 1 contains column headings and tasks run from rows 2 through 25, select B2:B25 rather than the entire column B. Keeping the checkbox range limited helps avoid confusing controls in headings or summary areas.

When you need another checkbox in a different part of the sheet, you can select the cell or range there and insert it independently. You are not limited to one checkbox column, but a clear layout makes the sheet easier to scan. For example, separate columns could track “Reviewed” and “Approved,” with distinct headings so collaborators know what each checkbox means.

Use Custom Checked and Unchecked Values

By default, formulas see TRUE and FALSE. If another value is more useful for your workflow, Google Sheets lets you set custom values. Select the checkbox cells, choose Data > Data validation, and open or add the checkbox rule. In the rule’s criteria, choose Checkbox and enable Use custom cell values. Enter the value for checked and the value for unchecked, then save the rule.

For example, a status column might use the text “Complete” when checked and “Waiting” when unchecked. Custom values can make a sheet easier to read or help match an existing template, but they affect formulas: a formula checking for TRUE will not match the text “Complete.” Make sure formulas use the same values as the rule. If the sheet will be used by multiple people, tell them what each state means, especially when the unchecked value is not blank.

To return to the standard behavior, edit the rule and turn off custom values or restore the default setup. Avoid changing values casually after formulas have been built, because formulas that depend on the old values may need to be updated too.

Count and Interpret Checked Boxes with Formulas

Checkboxes can summarize progress without manually counting marks. Suppose task names are in A2:A6 and their checkboxes are in B2:B6. If three of those five boxes are checked, the following formula returns 3:

=COUNTIF(B2:B6,TRUE)

The formula counts cells whose value is TRUE. To count unchecked boxes instead, use =COUNTIF(B2:B6,FALSE). With the same five-cell range, if three tasks are checked and two are not, that formula returns 2. If you use custom text values, replace TRUE or FALSE with the corresponding text criterion.

You can also display a status beside each checkbox. With the checkbox in B2, enter this in C2 and fill it down for the other rows:

=IF(B2=TRUE,"Done","Pending")

For the default checkbox values, a checked box makes the result “Done” and an unchecked box makes it “Pending.” This is useful if another part of the sheet needs readable status labels, or if you want a summary that is easier to interpret than a column of symbols. Keep formulas outside the checkbox cells so that a formula does not overwrite the interactive checkbox.

Highlight Rows When a Box Is Checked

Conditional formatting can visually mark completed items. For example, if checkboxes are in column B and task details are in A2:C20, select A2:C20 and choose Format > Conditional formatting. Under the formatting rules, choose Custom formula is, enter =$B2=TRUE, and select a formatting style such as a light fill or strikethrough. The dollar sign fixes the checkbox column at B while the row number adjusts for each row in the selected range.

This rule applies the formatting to the task row when its checkbox is checked. If your checkboxes are in a different column, change B to that column. If you use custom values, test for the checked value instead of TRUE. Conditional formatting changes how cells look; it does not alter the checkbox value or prevent someone from editing the row.

Common Problems and Fixes

The menu item is unavailable or nothing appears: Confirm that you are editing a Google Sheets spreadsheet in a browser and have permission to edit it. Select an ordinary cell range and try Insert > Checkbox again.
A formula does not count the boxes: Check that the formula refers to the actual checkbox cells and that they still use TRUE and FALSE. Custom checkbox values require matching criteria.
A checkbox seems to have vanished: The row or column may be hidden, too small, or covered by an unexpected display format. Check the selection and adjust the row height or column width.
You want to clear a box but keep the checkbox: Click it to switch it off. Do not remove the validation rule if you intend to keep using the cell as a checkbox.
You want to remove the checkbox control: Select the relevant cells and remove the checkbox rule through Data > Data validation. Removing the rule is different from simply unchecking the box.

A common misconception is that deleting or clearing a checked value always has the same effect as unchecking it. For a reliable result, click the box to set it to its unchecked state. If you are cleaning up a sheet, remove the rule only when you no longer want those cells to behave as checkboxes.

When Checkboxes Are a Good Fit

Checkboxes work well for binary choices: complete or not complete, reviewed or not reviewed, included or excluded. They are especially useful when the sheet has a modest number of rows and users need to change status quickly. Combined with formulas or conditional formatting, they can provide a lightweight tracker without requiring a separate task-management tool.

A dropdown is usually a better choice when a row can have more than two states, such as “Not started,” “In progress,” and “Blocked.” In Sheets, you can create a dropdown using Insert > Dropdown. A dropdown communicates several distinct options, while a checkbox communicates one yes/no decision. For a free-form note, use a normal text cell instead; a checkbox cannot record why a task is incomplete.

Google Sheets checkboxes are not identical to every checkbox feature in other spreadsheet programs. Excel has its own checkbox and data-validation options, and menu locations and behavior can differ by version. If a file is shared or exported between Sheets and Excel, verify that the controls and formulas behave as intended in the destination program rather than assuming every feature will transfer unchanged.

Frequently Asked Questions

Can I add checkboxes to multiple cells at once?
Select the desired range, then choose Insert > Checkbox. Sheets adds a checkbox to each selected cell, so exclude headings or rows where a checkbox is not needed.

Can a checkbox show text instead of TRUE or FALSE?
Yes. Edit the checkbox rule through Data > Data validation, choose the Checkbox criteria, and enable custom cell values. Set the checked and unchecked values, then make sure any formulas use those values.

How do I count checked boxes?
For default checkboxes in B2:B20, use =COUNTIF(B2:B20,TRUE). It counts cells whose value is TRUE. If you customized the checkbox values, use the checked value in the count criterion.

Can I use a checkbox to format a whole row?
Yes. Apply a conditional formatting rule to the row range and use a custom formula that refers to the checkbox column, such as =$B2=TRUE when the checkboxes are in column B and the first data row is row 2.

How do I delete a checkbox without deleting the whole row?
Select the cell or range and remove its checkbox validation rule using Data > Data validation. If you only want to mark a task incomplete, click the box to uncheck it instead.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.