How to Add a Checkbox in Google Sheets and Make It Work

To add a checkbox in Google Sheets, select the cell or range where you want it, then choose Insert > Checkbox. Click a box to switch it on or off; by default, checked and unchecked boxes store the values TRUE and FALSE, which you can use in formulas and other spreadsheet features.

Add a checkbox in a browser

In Google Sheets on the web, you can place a checkbox in one cell or add them to a whole range in one step:

Open the spreadsheet and select the cell where the first checkbox should appear. To add a column or block of boxes, select the entire target range instead.
Choose Insert > Checkbox from the menu.
Click a checkbox to check or clear it. The change is saved in the spreadsheet like other cell edits.

For example, selecting B2:B20 before choosing Insert > Checkbox creates 19 boxes, one in each selected cell. If you select only B2, only that cell receives a checkbox. You can also select nonadjacent cells by holding Ctrl on Windows or Command on Mac while selecting them, then insert checkboxes into the selection.

The command is available in the Google Sheets browser interface. If you are following instructions written for Excel, the menu path will not match: Excel has its own checkbox controls and interface, so use the steps for the specific spreadsheet program you have open.

What a Google Sheets checkbox stores

A checkbox is a cell control with a value, not just a decorative symbol. With the default settings, a checked box evaluates as the Boolean value TRUE and an unchecked box evaluates as FALSE. The cell can still be referenced by formulas, conditional formatting, filters, and other spreadsheet features.

This distinction matters when using formulas. TRUE and FALSE are logical values, not the text strings Yes and No. A formula that looks for TRUE can count default checked boxes, while one that looks for the word Yes will not match them unless you have deliberately set Yes as a custom checked value.

Checkboxes are useful when a sheet needs a simple, visible choice that people can change quickly: complete or incomplete, include or exclude, reviewed or not reviewed. They are not a replacement for every kind of data validation. If a user must choose one option from several, such as a department or priority level, a dropdown is usually a better fit.

Add checkboxes to a task list or tracker

A common layout keeps the checkbox in one column and the item it refers to in the next. For example, put Task in A1 and Done in B1, list task names in A2:A20, and insert checkboxes in B2:B20. The separate columns make it clear what each box means and leave the task description easy to read.

Other practical uses include attendance, packing lists, review queues, event planning, and simple preference forms. For an inventory sheet, a box might mean that an item has been counted; for a content calendar, it might mean a draft has been approved. Pick a clear column heading, because an unlabeled box can be ambiguous to collaborators.

To extend a tracker, select the destination cells and use Insert > Checkbox again. You can also copy a cell containing a checkbox and paste it into other cells. If you copy a formula or formatting along with it, check the pasted result: the copy operation may carry other cell contents or formatting as well as the checkbox.

Use custom checked and unchecked values

By default, the box returns TRUE when checked and FALSE when unchecked. If a workflow needs different values, Google Sheets lets you set custom values for a checkbox. Select the checkbox cell or range, open Data > Data validation, and edit or add a rule whose criteria are Checkbox. In the rule settings, enable Use custom cell values and enter the values for checked and unchecked states. The wording and placement of controls can change as Google updates its interface, but the rule is managed through Data validation.

Custom values can be useful when another system or an existing sheet expects words such as Yes and No, or status codes such as 1 and 0. Choose values that are consistent throughout the range. If formulas already refer to TRUE or FALSE, changing the checkbox values means those formulas may need to be updated to look for the new values instead.

Before changing an established sheet, consider whether other formulas, filters, or connected workflows depend on the current values. A checkbox that displays as a familiar tick can conceal a different underlying value, so inspect the data validation rule if a formula stops responding as expected.

Use checkboxes in formulas

With default checkbox values, formulas can count checked items, calculate totals for selected rows, or show a status. For example, suppose B2:B6 contains checkboxes with B2, B4, and B5 checked, while B3 and B6 are unchecked. With this layout, the formula counts the checked boxes: =COUNTIF(B2:B6,TRUE). It returns 3.

You can also use a checkbox to decide whether a row contributes to a total. Suppose B2:B5 contains checkboxes with B2, B4, and B5 checked, and C2:C5 contains 12, 8, 5, and 3 respectively. With the checkboxes in B2:B5 and the corresponding amounts in C2:C5, this formula adds the amounts on checked rows: =SUMIF(B2:B5,TRUE,C2:C5). It returns 20, because 12 + 5 + 3 = 20.

These formulas use the default Boolean values. If you configured custom values, use the matching checked value in the formula instead. For a formula that returns a word based on one box, use an IF test that refers to the checkbox cell; make sure the test matches the value your checkbox actually stores. Keep the checkbox and the data it controls aligned on the same row to avoid counting or summing the wrong records.

Keep a checkbox list clear and manageable

Checkboxes work best when the sheet makes their purpose and scope obvious. A few small design choices can prevent mistakes:

Use a descriptive heading such as Complete, Approved, or Counted rather than a vague heading such as Status.
Keep one meaning per checkbox column. Do not use the same column to mean approved in some rows and paid in others.
Freeze or repeat header rows when a long tracker is difficult to navigate, and use filters when people need to focus on particular records.
Make sure new rows receive the checkbox rule. If a table is extended, check that the inserted cells actually contain boxes before asking collaborators to use them.
Use conditional formatting only if a visual change adds clarity, such as distinguishing completed rows from open ones.

To format rows based on a checkbox, select the relevant range and choose Format > Conditional formatting. Set up a rule that uses the checkbox value, and apply the format to the rows you want to highlight. Take care with the applied range and the rule’s cell references: a rule intended for an entire row needs to refer to the checkbox in that row, not a single fixed checkbox for every row.

Common checkbox problems and fixes

If Insert > Checkbox does not appear to do anything, first check that you selected the intended cells and that the selection is not being confused with a different sheet or range. Try selecting one empty cell and inserting a box there. If that works, repeat the action on the intended range. Also check whether the cell already contains content: inserting a checkbox changes the cell’s contents, so preserve any important value elsewhere before replacing it.

If a box is visible but a formula gives an unexpected result, check the actual checkbox rule and the formula’s criteria. A default checkbox is TRUE or FALSE, whereas a custom checkbox may return text or another value. A formula searching for one type will not necessarily match the other. Confirm that the formula range includes all the checkbox cells and that the amounts or task names it references are on corresponding rows.

If boxes seem to vanish after copying or editing, inspect the affected cells. A paste operation or clearing cell contents can replace a checkbox. Reinsert the checkboxes in the cells that need them. When a shared sheet is involved, also consider whether another editor changed the cells or the validation rule; check version history if you need to review earlier edits.

Finally, a checked box does not automatically mark a task complete in every other system. It changes the cell value in the sheet. Any notification, workflow, or connection to another service requires its own setup; do not assume that ticking a box sends an email or updates an external task manager by itself.

When to use a checkbox instead of a dropdown

Choose a checkbox when the cell represents a simple on-or-off decision. It is compact, easy to scan, and quick for collaborators to change. It suits questions with two meaningful states, such as done or not done, selected or not selected, and present or absent.

Choose a dropdown when users must select among several options, such as Not started, In progress, and Done, or Low, Medium, and High. A dropdown can make those distinctions explicit and reduce inconsistent typing. If users need to select several labels from a longer list, a single checkbox is not enough; you may need multiple checkbox columns or a different data-entry design.

There is no special charge to insert a checkbox as a built-in Google Sheets feature. The key decision is how the sheet should represent the choice and what formulas or processes depend on its value. Plan that structure before filling a large range or sharing the tracker with many editors.

Frequently Asked Questions

Can I add checkboxes to multiple cells at once?
Yes. Select the full range first, then choose Insert > Checkbox. Sheets adds a checkbox to each selected cell, so selecting B2:B100 creates a box in every cell from B2 through B100.

What value does a checked checkbox have?
By default, a checked checkbox has the Boolean value TRUE and an unchecked one has FALSE. If custom values have been set in the checkbox’s data validation rule, it uses those instead.

How do I count checked boxes?
For default checkboxes in B2:B20, use COUNTIF with TRUE as the criterion: =COUNTIF(B2:B20,TRUE). The result is the number of checked cells in that range. Adjust the range to match your sheet.

Can I make a checkbox show Yes and No?
Yes. Edit the checkbox rule under Data > Data validation, enable custom cell values, and set the checked and unchecked values to Yes and No. Update any formulas that previously expected TRUE and FALSE.

Can a checkbox automatically cross out a task?
It can be used as the condition for formatting, but the checkbox does not cross out text automatically by itself. Set a conditional formatting rule using Format > Conditional formatting and apply a strikethrough style to the task text when its row’s checkbox is checked.

Why does a checkbox formula not work?
Common causes include a formula that checks for TRUE while the checkbox has custom values, a range that misses some boxes, or a mismatch between checkbox rows and the data being calculated. Verify the rule and the cell references first.

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.