Add Checkbox in Google Sheets: Steps and Uses

To add a checkbox in Google Sheets, select the cell or range where you want it, then choose Insert > Checkbox. Each checkbox is interactive: clicking it marks it checked or unchecked, and its value can be used in formulas, filters, and formatting rules.

Add a checkbox to a cell

In Google Sheets in a web browser, checkboxes are inserted from the Insert menu. You can add one to a single cell or select a group of cells first to create a whole column of checkboxes at once. The checkbox appears inside each selected cell; it does not float over the grid like an image.

Open the spreadsheet and select the cell or cells where the checkboxes should go.
Choose Insert > Checkbox.
Click a checkbox to change its state. A checked box is selected; click it again to clear it.

For example, if a task list has task names in column A and checkboxes in column B, select B2:B20 before inserting. That creates one checkbox beside each task. You can also select a single cell, such as B2, if you only need one. Inserting checkboxes into a range that already contains information can replace or alter cell contents, so check the selection before using the command.

Google Sheets saves changes automatically when you are online. People with permission to edit the spreadsheet can click the boxes too, which makes checkboxes useful for shared lists. A checkbox records a cell value; it does not, by itself, assign a task, notify someone, or prevent another editor from changing the sheet.

What checked and unchecked mean

By default, a checked checkbox stores the Boolean value TRUE, and an unchecked checkbox stores FALSE. These are logical values, not the text strings TRUE and FALSE. That distinction matters when writing formulas: a formula can test the checkbox directly, or count cells containing the logical value TRUE.

The visible box is just a convenient control for changing the underlying value. You can see that value by selecting the cell and looking at the formula bar, or by referring to the cell in another formula. If a checkbox is deleted, the cell no longer acts as a checkbox; depending on how it is cleared or edited, its contents may also be removed or replaced.

This behavior is why a checkbox can be more useful than typing a symbol such as a tick mark. A tick character is usually just text, while a standard checkbox has a predictable checked or unchecked value that formulas can evaluate. For a printable checklist where no calculations are needed, a typed symbol may still be sufficient.

Add checkboxes to a list or range

The easiest way to create a checklist is to reserve one column for the checkbox and another for the item. Put task descriptions in one column, select the matching cells in the next column, and use Insert > Checkbox. Leave a header row above the list so the purpose of each column is clear.

Household list: Put chores in A2:A15 and checkboxes in B2:B15.
Event planning: Put supplies in A2:A30 and use column B to mark items already purchased.
Review tracker: Put document names in A2:A50 and use a checkbox in B to indicate that each has been reviewed.

When adding more items later, insert checkboxes into the new rows as well. You can copy a checkbox cell and paste it into other cells, or select the new range and use the Insert menu. Copying an entire row may also copy its text, formatting, and formulas, so check the pasted range to avoid duplicating data unintentionally.

Checkboxes work in ordinary ranges and can be used in many spreadsheet layouts, but they are not the same as a filter control or a form question. If people need to submit responses without editing the spreadsheet, a Google Form may be a better collection method; its responses can be connected to a sheet.

Use checkboxes in formulas

Because standard checkboxes store TRUE or FALSE, they can drive simple calculations. For instance, a count can show how many items are marked complete. With checkboxes in B2:B6, where three boxes are checked, enter =COUNTIF(B2:B6,TRUE) in another cell. It returns 3. The result updates when a user checks or clears a box.

You can also display a status beside an individual checkbox. With a checkbox in B2, enter =IF(B2,"Done","To do") in C2. If B2 is checked, C2 displays Done; if B2 is unchecked, it displays To do. Copy the formula down alongside the rest of the list, adjusting the row references as needed.

For a completion percentage, count the checked boxes and divide by the number of tasks. With checkboxes in B2:B6 and five tasks in the list, enter =COUNTIF(B2:B6,TRUE)/COUNTA(A2:A6) in a result cell, where task names are in A2:A6. If all five task-name cells are filled and three boxes are checked, the result is 0.6, or 60% when the result cell is formatted as a percentage. If the task range might be empty, account for that before dividing so the sheet does not show a division error.

Use the checkbox cells consistently. If you replace a checkbox with text, such as the word Yes, formulas that expect TRUE may no longer count it. For custom checked and unchecked values, update formulas to match those values rather than assuming they are still Boolean values.

Customize checkbox values

Google Sheets lets you set custom values for checked and unchecked states. This can be useful when a workflow expects labels such as Yes and No, or Complete and Pending, rather than TRUE and FALSE. Select the relevant cells, choose Data > Data validation, and add or edit a rule whose criteria is Checkbox. In the rule settings, enable the option to use custom cell values and enter the values for the checked and unchecked states.

After applying the rule, test both states in a cell. The value stored when checked should match what your formulas, charts, or connected processes expect. For example, a formula that counts TRUE will not count a custom value such as Yes. You would need to change the counting condition to the custom value. This is a common source of confusion when a checkbox appears to work but a summary count stays at zero.

Custom values are best chosen before building calculations around a checklist. If other people will use the sheet, make the labels intuitive and explain them in a header or note. A checkbox with custom values can still look like a checkbox, but it is no longer returning the default Boolean values.

Format rows based on a checkbox

Conditional formatting can make checked items easier to scan. For example, you can gray out a task row when its checkbox is checked. Suppose task details occupy A2:C20 and the checkboxes are in B2:B20. Select A2:C20, choose Format > Conditional formatting, and set the rule to use a custom formula. Enter =$B2=TRUE, then choose a formatting style such as gray text or a strikethrough.

The dollar sign before B keeps the rule looking at the checkbox column as it applies across the selected row, while the row number changes for each row. If your selected range starts on row 2, the formula should refer to row 2. If the checkbox column or starting row differs, adjust the reference to match your layout. Conditional formatting changes how cells look; it does not delete completed tasks or lock them from editing.

Another option is to filter a list to show only unchecked items. Use the filter controls for the relevant range and filter the checkbox column by its value. This can make a long checklist easier to manage, but remember that a filtered-out row is still present in the sheet. Clearing or changing the filter reveals it again.

Common checkbox problems and fixes

The checkbox option is missing or unavailable: Confirm that you are editing the file in Google Sheets, not viewing a downloaded copy in another program. Make sure you have permission to edit and that the selected cells are not protected against changes.
Clicking a cell does not change its state: Check whether the cell actually contains a checkbox rule. A pasted picture or a typed checkmark may look similar but is not an interactive checkbox. Select the cell and use Insert > Checkbox if appropriate.
A count formula returns zero: Check whether the boxes use the default TRUE/FALSE values or custom values. Also confirm the formula covers the checkbox cells, not the task-description column.
The formatting rule affects the wrong rows: Verify the selected range and the row reference in the custom formula. The first row reference should correspond to the first row of the applied range.
Checkboxes disappear after pasting: Pasting values only or pasting content from another application may not preserve the checkbox rule. Reapply the checkbox using Insert > Checkbox or copy a correctly configured checkbox cell.

One useful diagnostic is to select a checkbox cell and inspect its contents or validation rule. If the cell has been overwritten with ordinary text, it may look close to the original but will not behave as expected in formulas. Reinsert the checkbox and then check any formulas that refer to it.

Checkboxes compared with other options

Checkboxes are a good fit when a choice has two states, such as complete or incomplete, approved or not approved, and packed or not packed. They make the current state visible and allow formulas to count or respond to it. They are less suitable when users must choose among several options, such as Not started, In progress, and Complete. For that, a dropdown list created through Data validation is clearer.

A text value such as Yes or No can also represent a two-state choice, but it takes more typing and can be entered inconsistently. A checkbox makes the available states obvious. On the other hand, text labels can be easier to understand in exported data or in systems that do not interpret Boolean values, so the best choice depends on how the sheet will be used.

For a one-time paper checklist, printed boxes or symbols may be enough. For a shared tracker with calculations, sorting, and conditional formatting, native Google Sheets checkboxes are usually more useful. In Microsoft Excel, checkboxes and their insertion options differ by version, so instructions for Sheets should not be assumed to match Excel menus. If collaborators will open the file in Excel, test the workbook and its controls in that program before relying on them.

Frequently Asked Questions

Can I add checkboxes to multiple cells at once?
Select the entire range first, then choose Insert > Checkbox. Sheets adds a checkbox to each selected cell, so selecting B2:B20 creates 19 checkboxes.

What value does a checked Google Sheets checkbox return?
With the default settings, a checked box returns TRUE and an unchecked box returns FALSE. If you set custom checked and unchecked values through data validation, formulas must use those custom values instead.

Can a checkbox automatically mark a task complete?
Yes. A formula can display a status based on the checkbox, or conditional formatting can change the row’s appearance. The checkbox itself does not move, delete, or lock the task; those actions require other spreadsheet features or a separate workflow.

How do I remove a checkbox?
Select the cell or range and press Delete or Backspace to clear its contents, or remove its checkbox rule through the cell’s data validation settings. Check the result afterward, especially if the cells contain other information you want to keep.

Can I use checkboxes in Google Sheets on a phone?
You can work with Sheets files on mobile, but the layout and available controls differ from the web browser. The steps in this guide use the browser interface; for editing data validation or applying checkbox rules, the desktop browser is often the clearest option.

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.