How to Add a Checkbox in Google Sheets and Use It

To add a checkbox in Google Sheets, select the cell or range where you want it, then choose Insert > Checkbox. Each box stores a value—by default, TRUE when checked and FALSE when unchecked—so you can use checkboxes in formulas, filters, and other spreadsheet workflows.

What a Google Sheets checkbox does

A checkbox is a cell control, not just a picture of a box. Clicking it switches the cell between two values, which means the sheet can respond to a choice. For example, a checked box can mean a task is complete, an item is included in an order, or a person has confirmed attendance. An unchecked box represents the other state.

By default, those states are the Boolean values TRUE and FALSE. You can see the value in the formula bar when you select the cell, and formulas can refer to it just as they refer to other cell values. The box itself makes the choice easy for people to enter; the stored value makes the choice useful to the spreadsheet.

Checkboxes work well when each row represents one item and a person needs to make a simple yes-or-no decision. They are less suitable when a response needs several options, a date, or explanatory text. In those cases, a dropdown list or a regular text field may communicate the answer more clearly.

How to insert checkboxes in a browser

In Google Sheets on the web, you can add one checkbox or apply checkboxes to a block of cells. The menu path is the same either way:

Open the spreadsheet and select the cell, cells, or range where the boxes should appear. Drag across a range, or click a cell and use Shift while selecting another cell to extend the selection.
Choose Insert > Checkbox from the menu bar.
Click a checkbox to test it. A checked box should display a tick, and an unchecked box should appear empty.

For example, to make a checklist for rows 2 through 20, select A2:A20 before choosing the menu command. Each selected cell gets its own checkbox. If you want a header, put a label such as Done in A1 rather than including the header cell in the selection.

You can also add a box to a single cell first, then copy and paste that cell into other intended cells. Selecting the full range and inserting checkboxes in one step is usually easier, especially when you are starting with a new checklist. Check the selection before inserting so you do not add controls to headings or unrelated columns.

Set custom checked and unchecked values

TRUE and FALSE are convenient for formulas, but a sheet may need different values—for example, the words Yes and No. To change them, select the checkbox cells and open Data > Data validation. In the data validation panel, set the criterion to Checkbox. Enable the option to use custom cell values, then enter the values for checked and unchecked states and save the rule. The precise labels in the panel can vary as Google updates its interface.

Custom values change what the cell contains; the box remains the visible control. This can help when another system or a report expects particular text. However, formulas that assume TRUE and FALSE will need to be adjusted if you switch to text values. For example, a COUNTIF formula searching for TRUE will not count cells whose checked value is Yes.

Choose values that are consistent throughout the range. Mixing different checkbox rules can make a column confusing and can cause formulas, filters, or summaries to miss some responses. If the values matter to a downstream workflow, agree on the exact spelling and capitalization before sharing the sheet.

Use checkboxes in formulas and summaries

Because a default checkbox contains TRUE or FALSE, it can act as a simple input to formulas. Suppose column B has checkboxes for tasks, with rows 2 through 20 holding the tasks. If seven boxes are checked, this formula counts them:

With checkboxes in B2:B20 using the default TRUE/FALSE values, =COUNTIF(B2:B20,TRUE) returns 7 when exactly seven boxes are checked.

You can use the count as a progress indicator, or combine it with the number of tasks. For a small checklist, a person can also filter the checkbox column to show only checked or unchecked rows. A checkbox does not automatically cross out a task or move a row; those effects require formatting rules, formulas, filters, or other actions.

To connect a checkbox to a status label, put a formula in a neighboring column and reference the checkbox cell. For example, with a default checkbox in B2, =IF(B2,"Done","Open") displays Done when B2 is checked and Open when it is not. The formula belongs in another cell, such as C2, rather than in the checkbox cell itself. If you fill it down, each row can show its own status.

Formulas are optional. A checklist can simply be a visual record, but the stored values make it possible to build totals, conditional formatting, and filtered views without asking people to type a status manually.

Make a checklist easier to read

Checkboxes are most helpful when their purpose and location are obvious. Add a clear column heading, keep the checkbox column beside the item it controls, and use one box per decision. A task tracker might have Task in column A, Done in B, and Owner in C. A sign-up sheet might use a column labeled Attending rather than an unexplained column of boxes.

You can use conditional formatting to change the appearance of related cells when a box is checked. Select the task cells, then choose Format > Conditional formatting. Create a rule that applies formatting when a custom formula is true, using a reference to the checkbox in that row—for example, =$B2=TRUE when the first task is in row 2 and its checkbox is in column B. Apply the rule to the task range, such as A2:A20, and choose a format such as muted text. Check that the row reference matches your layout before saving.

This formatting does not alter the checkbox or its stored value; it only changes how the selected cells look. Keep enough contrast for the task text to remain readable, and avoid relying on color alone to communicate completion. A status word or the checkbox itself can provide a non-color cue.

Edit, copy, and remove checkboxes

To change a checkbox, click it. To change its rule or custom values, select the relevant cells and open Data > Data validation. If several cells share one rule, select the range you intend to edit and verify the change afterward. A rule applied to a whole column can affect future entries, while one applied only to a short range will not automatically cover new rows outside it.

Copying a checkbox cell can copy its validation rule as well as its current state. If you are copying a checked example, inspect the pasted cells: you may have copied a checked value when you meant to create empty boxes. You can clear a checkbox by clicking it so it is unchecked, or use the keyboard Delete or Backspace key to clear selected cell contents. Clearing contents and removing a checkbox rule are not always the same thing; if the control remains or the cell still behaves like a checkbox, remove or change its data validation rule.

To remove checkboxes from a range, select the cells and remove the checkbox data validation rule through Data > Data validation. Check the affected cells afterward, particularly if the range also contains values you want to keep. Removing a rule is different from deleting an entire row or column, which can remove other data too.

Common checkbox problems

The menu command is unavailable or the wrong cells change: Confirm that the intended cells are selected and that you are editing the sheet, not viewing it without editing access. In a shared file, permissions can limit changes.
The box displays the wrong state: Default checkboxes interpret TRUE as checked and FALSE as unchecked. Existing values or custom checkbox values can affect what you see. Review the data validation rule and the cell value.
A formula does not count checked boxes: Make sure the formula looks at the correct range and that the checkbox uses the values the formula expects. A TRUE-based count will not match custom text values such as Yes.
New rows have no checkbox: The rule may cover only the original range. Extend the range in data validation or insert checkboxes in the new cells.
The tick is hard to see: Check the cell’s text color, fill, and size, and make the column wide enough to display the control comfortably. Avoid formatting that makes the box blend into the background.

One common misconception is that inserting a checkbox automatically completes a task, sends a notification, or changes another row. It only records a value in the cell. Any additional behavior needs a formula, conditional formatting, a filter, or an automation that has been deliberately set up.

Checkboxes compared with dropdowns

A checkbox is a good fit when there are exactly two states and the user should be able to switch between them quickly. It makes completion, inclusion, and confirmation visible at a glance. A dropdown is usually better when users must choose among three or more options, such as Not started, In progress, and Done, or when you want to limit entries to a known list of names.

Compared with typing Yes or No, checkboxes reduce spelling variations and make the input easier to scan. The trade-off is that a box is compact and does not explain the meaning by itself. Use a descriptive heading and, where necessary, a note that explains what checked means. If users need to explain why they selected an option, add a separate notes column rather than trying to make a binary control do both jobs.

Excel also supports checkboxes, but its menus and available checkbox features depend on the Excel version. These steps and menu paths are for Google Sheets in a web browser; they should not be treated as instructions for Excel. A Google Sheets checkbox is a cell value with validation, so formulas and custom values in the sheet are part of how the feature works.

Frequently Asked Questions

Can I add checkboxes to an entire column?
Select the column or the portion you want to use, then choose Insert > Checkbox. Applying boxes only to the working rows can keep headings and unrelated cells clear. If the list will grow, extend the range when you add rows.

What value does a checked checkbox return?
With the default settings, a checked box stores TRUE and an unchecked box stores FALSE. If custom values are enabled in data validation, the cells use those values instead.

Can I count checked boxes?
Yes. For default checkboxes, use COUNTIF with the checkbox range and TRUE as the criterion. For instance, =COUNTIF(B2:B20,TRUE) counts the checked boxes in B2:B20. Use the matching custom checked value if the boxes were configured with custom values.

Can I make a checkbox cross out a task?
Not by inserting the checkbox alone. Select the task cells and create a conditional formatting rule based on the checkbox cell in the same row. That changes the task’s appearance when checked but leaves the checkbox value intact.

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

For a straightforward checklist, select the destination range, choose Insert > Checkbox, and leave the default TRUE/FALSE values in place. Add custom values or formulas only when the sheet has a specific need for them; clear labels and a well-chosen range make the checkbox useful from the start.

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.