Google Sheets Checkbox in a Cell: How to Add and Use

To put a checkbox in a Google Sheets cell, select the cell or range, then choose Insert > Checkbox. By default, a checked box represents TRUE and an unchecked box represents FALSE, so you can use checkboxes in formulas, task lists, and summaries.

Add a Checkbox to One Cell or a Range

In Google Sheets in a web browser, click the cell where you want the checkbox and select Insert > Checkbox. A small empty box appears inside the cell. Click it to check or uncheck it. To add checkboxes to multiple cells at once, select the whole range first—for example, B2:B20—then use the same menu command. Sheets puts one checkbox in each selected cell.

You can also select a whole column or a larger range, but consider whether every cell needs a checkbox. Applying them only to the rows intended for tasks or responses keeps the sheet easier to scan and avoids filling unused rows with controls. To remove them, select the relevant cells and press Delete, or use Edit > Delete values. If you want to clear the cell contents while keeping its checkbox rule, use care: clearing values and removing the checkbox validation are different actions.

After inserting boxes, you can resize the column or adjust row height to make the layout more comfortable. The checkbox sits within the cell; it is not a floating drawing. Text can go in an adjacent cell, such as a task name in column A and its checkbox in column B.

What a Checked Box Means in the Sheet

A standard Google Sheets checkbox stores a Boolean value: checked is TRUE, and unchecked is FALSE. The visible box is the control you click, while the underlying value is what formulas and other spreadsheet features can evaluate. This makes a checkbox more useful than a symbol typed into a cell: the state can change, be counted, or trigger a conditional calculation.

For example, if checkboxes are in B2:B20, the formula =COUNTIF(B2:B20,TRUE) counts how many are checked. If the range contains three checked boxes, the result is 3. To count the unchecked boxes instead, use =COUNTIF(B2:B20,FALSE). These formulas refer to the checkbox values, not to the visual shape of the boxes.

You can inspect an individual checkbox cell by selecting it and looking at the formula bar. With standard settings, it will show TRUE or FALSE. Avoid typing a different value into a checkbox cell unless you intend to change its contents: doing so can replace the checkbox value or affect its validation. If a formula or data entry seems not to respond to a box, first check that it references the correct cells and is using the value type that the boxes actually store.

Use Custom Values Instead of TRUE and FALSE

Google Sheets can assign custom values to the checked and unchecked states. This can be helpful when a sheet needs clear text labels, or when it feeds another process that expects particular values. Select the checkbox cells, open Data > Data validation, and edit or add a rule with the checkbox criteria. In the rule settings, enable the option to use custom cell values, then enter the value for checked and the value for unchecked.

For instance, a project tracker might use “Done” for checked and “Not yet” for unchecked. A checkbox in that setup no longer returns TRUE or FALSE; formulas must look for the custom values. If the custom values are in B2:B20, =COUNTIF(B2:B20,"Done") counts completed items. The text in the formula must match the custom checked value. If you later change the rule, review dependent formulas so they still match the values being stored.

Custom values are optional. Standard TRUE and FALSE are often the better choice when you plan to use logical tests or share a sheet with people who expect ordinary checkbox behavior. Choose custom values only when the more descriptive labels solve a real need; they do not make the checkbox more clickable or change its appearance.

Build a Practical Task List

A simple task list can place task names in A2:A10, checkboxes in B2:B10, and a status summary in another cell. Select B2:B10 and choose Insert > Checkbox. Add task descriptions in column A. To display a live completion count, enter =COUNTIF(B2:B10,TRUE) in a summary cell. If four of the nine boxes are checked, the formula returns 4.

To show the number of tasks still open, use =COUNTIF(B2:B10,FALSE). In this example it returns 5 when four of nine items are checked. A completion percentage can be calculated by dividing checked boxes by the number of task rows: =COUNTIF(B2:B10,TRUE)/COUNTA(A2:A10). Format that result as a percentage using the toolbar’s percentage format. With four tasks checked and nine nonblank task names, the result is about 44.4%.

The denominator matters. If you divide by a fixed range that includes many blank future rows, the displayed completion percentage will be lower than the proportion of actual tasks completed. Using COUNTA on the task-name range avoids counting empty task rows, provided each real task has a name. For a small list with no blanks, a fixed count can be easier to understand; for a growing list, design the range deliberately.

Checkboxes can also feed an adjacent status message. With a checkbox in B2, a formula in C2 such as =IF(B2,"Complete","Open") displays Complete when checked and Open when unchecked. Copying that formula down applies it to the corresponding rows. If the checkbox uses custom values rather than TRUE and FALSE, adapt the IF test to match those values.

Format Rows Based on Checkbox State

Conditional formatting can make completed work easier to distinguish. For a task list with checkboxes in B2:B20 and descriptions in A2:A20, select A2:B20 and choose Format > Conditional formatting. In the sidebar, set the rule to use a custom formula and enter =$B2=TRUE. Choose a formatting style, such as a muted text color or strikethrough, and click Done. When a box in column B is checked, the formatting applies across that row’s selected cells.

The dollar sign before B keeps the checkbox reference in column B as the rule applies across the row; the row number remains relative so each task is checked against its own checkbox. If the rule applies only to the checkbox cell, select B2:B20 instead. For custom checkbox values, use a condition that matches the checked value, such as =$B2="Done" when Done is the chosen checked value.

Formatting changes only how the cells look. It does not alter the checkbox state, delete a task, or change the value used by formulas. This is useful when readers need a quick visual cue but should retain the full task list for reference.

Common Checkbox Problems and Fixes

The menu option is unavailable or the cell will not change: Check whether the sheet or range is protected, or whether you have permission to edit it. In a shared sheet, viewers cannot change checkboxes.
A formula counts the wrong number: Confirm that its range covers the checkbox cells and that the boxes use the expected values. A COUNTIF looking for TRUE will not count custom text such as Done.
Some cells show boxes and others do not: The checkbox rule may have been applied to only part of the range. Select the intended cells and use Insert > Checkbox, or inspect their rules under Data > Data validation.
A pasted value replaces a checkbox: Pasting cell contents can overwrite values or validation. If the box disappears, reapply the checkbox rule to the affected range and check whether the paste included formatting or data validation.
The checkbox is difficult to click: Make sure the sheet is in edit mode and the cell is not protected. On a narrow screen, zooming in or widening the column can help with precise selection.

When changing a sheet built by someone else, check for custom checkbox values and conditional-formatting rules before resetting cells. A checkbox may be connected to a summary, formula, or workflow, so replacing its values without reviewing those dependencies can make the sheet appear broken even though the box itself still works.

Sharing, Mobile Use, and Excel Differences

In a shared Google Sheet, editors can usually change checkbox states, while access level and protected ranges can limit who is allowed to edit. Because the value is stored in the cell, other formulas and collaborators can see the state as it changes. If a checklist is meant for input from a group, label the checkbox column clearly and explain whether checked means complete, approved, or something else.

Google Sheets also has mobile apps, but the exact controls and menu placement can vary by device and app version. The steps above describe Sheets in a desktop web browser. If you are working on a phone or tablet, select the target cell and look for the insert or data-validation controls in the app; a browser on a small screen may show a different interface from the desktop layout.

Excel also supports in-cell checkboxes in some current Microsoft 365 environments, but the feature and workflow are not identical across spreadsheet programs or versions. A checkbox created in Google Sheets may not behave as an interactive checkbox after export to an Excel file; the exported cell may instead appear as a value or validation, depending on the file and feature support. If a workbook must work reliably in both programs, test the exported copy and confirm that formulas, checkbox controls, and custom values behave as intended. For an uncomplicated shared checklist, keeping it in Google Sheets avoids that compatibility uncertainty.

Frequently Asked Questions

Can I add checkboxes to an entire column?
Select the column or the specific range you want, then choose Insert > Checkbox. Applying boxes only to the rows you use is often tidier than filling an unlimited column.

Can I count checked boxes in Google Sheets?
Yes. If standard checkboxes are in B2:B20, use =COUNTIF(B2:B20,TRUE). It returns the number of checked cells in that range. For custom values, count the checked label instead.

Can a checkbox automatically change another cell?
Yes. Use a formula such as =IF(B2,"Complete","Open") in another cell, assuming B2 contains a standard checkbox. The displayed result changes as the box is checked or unchecked.

Can I change the words represented by the checkbox?
Yes. Open Data > Data validation for the checkbox cells, edit the checkbox rule, and set custom checked and unchecked values. Update any formulas that rely on TRUE or FALSE afterward.

Why can’t I check a box in a shared spreadsheet?
You may have view-only access, or the cell may be protected. Ask the owner for editing permission or for access to the protected range; changing the checkbox requires permission to edit its cell.

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.