Can You Add a Checkbox in Google Sheets?

Yes. In Google Sheets in a web browser, select the cell or cells where you want checkboxes, then choose Insert > Checkbox. A checkbox is stored in its cell as a value, so you can also count checked items, filter a list, or use checkboxes in formulas.

How to Add a Checkbox

You can add one checkbox or create a group of them at once. For a task list, it is usually easiest to put the checkbox in one column and the task description in the next. For example, use column A for task names and column B for their checkboxes.

Open the spreadsheet in Google Sheets in your browser.
Select the cell where the checkbox should appear. To add several, select the whole range, such as B2:B20.
Choose Insert > Checkbox.
Click a box to check or uncheck it. You can also use the keyboard to move to a checkbox cell and press the space bar.

Sheets puts a checkbox in each selected cell. Selecting a range first is useful when setting up a checklist, attendance sheet, inventory list, or project tracker; you do not have to insert each box separately. To remove them, select the relevant cells and delete their contents, or use the available data-validation controls to remove the checkbox rule. Be aware that deleting cell contents also removes any other content in those cells.

What a Checkbox Stores

A checkbox is not a picture floating above the grid. It is a cell value displayed as a clickable control. By default, a checked box has the Boolean value TRUE and an unchecked box has the value FALSE. That underlying value is what lets Sheets work with the checkbox in formulas, sorting, filters, and conditional formatting.

This distinction clears up a common misconception: the visible tick is not itself the text “checked.” If a formula needs to test a default checkbox, it should compare the cell with TRUE, or use a function that counts TRUE values. Likewise, copying a checkbox cell copies a cell rule and value rather than inserting an independent drawing.

Checkboxes can be copied and pasted like other cell contents. If you copy an unchecked checkbox into another cell, the destination may also receive its unchecked state and checkbox rule. When you only want to reproduce the checkbox setup, check the destination cells afterward, especially if you are pasting over cells that already contain data.

Custom Checked and Unchecked Values

For some sheets, TRUE and FALSE are not the most convenient values. You can set custom values, such as “Done” for checked and “Not done” for unchecked. Select the checkbox cells, open Data > Data validation, and edit the checkbox rule. The options for custom cell values let you specify what a checked and unchecked box should store. The exact presentation of the controls can change as Google updates its interface, but the checkbox rule is managed through data validation.

Custom values can make a sheet easier to read in formulas or when exporting data, but they also change what formulas need to look for. A test for TRUE will not match a checkbox whose checked value is “Done.” Choose values that fit the way the sheet will be used, and keep them consistent across the range. If another application or a connected workflow expects Boolean values, retaining the defaults is usually simpler.

Use Checkboxes in Formulas

Because default checkboxes contain TRUE or FALSE, ordinary spreadsheet functions can use them. For example, you can count completed tasks or calculate the share of tasks marked complete. These formulas assume standard checkbox values, not custom text values.

With task names in A2:A6 and default checkboxes in B2:B6, this formula counts the checked boxes. If three of the five boxes are checked, the result is 3.

=COUNTIF(B2:B6,TRUE)

With the same layout, this formula divides the number of checked boxes by the number of task names. If all five task-name cells are filled and three checkboxes are checked, the result is 0.6, or 60% when the result cell is formatted as a percentage.

=COUNTIF(B2:B6,TRUE)/COUNTA(A2:A6)

To display a friendly status in another cell, a formula can test a checkbox with IF. For instance, if B2 is a default checkbox, =IF(B2,"Complete","Open") displays Complete when the box is checked and Open when it is not. Avoid counting blank rows as tasks: using the task-name column as the denominator, as in the percentage example, helps prevent empty checkbox cells from distorting a completion rate.

Practical Uses for a Checkbox Column

Checkboxes work well when a person needs to mark a simple yes-or-no state directly in a sheet. They are especially useful when the answer is something like done/not done, present/absent, selected/not selected, or in stock/out of stock. They are less suitable when a record needs several possible statuses, a date, or a longer explanation; those are better represented by text, a dropdown, or separate fields.

Task list: Put task names in one column and completion boxes beside them. Count checked boxes to get a quick total.
Event attendance: Use one checkbox per person to record whether they are attending, while keeping names and contact details in separate columns.
Inventory review: Mark whether each item has been checked, rather than using the checkbox to represent the item’s quantity.
Approval checklist: Track whether each required item has been reviewed. If approval needs a reviewer name or date, record those separately.

In a shared spreadsheet, editors can click checkboxes directly, which can make a list easier to update than asking everyone to type the same status consistently. However, a checkbox does not record who clicked it or when. If accountability or a timestamp matters, use an appropriate workflow or add separate columns rather than assuming the checkbox provides an audit record.

Copying, Filling, Sorting, and Filtering

To extend a checkbox column, select the intended range before using Insert > Checkbox. You can also copy cells that already have checkbox validation and paste them into additional cells. Check the result if the copied cells contained checked states you did not intend to reproduce. When filling a larger table, avoid including header cells in the selection unless you want the header to become a checkbox too.

Checkbox values can be used with Google Sheets filters. For example, a filter can show rows where the checkbox column is TRUE, leaving only completed records visible. Sorting or filtering a table should keep each row’s information together if the entire table range is included. Selecting and sorting only the checkbox column can separate statuses from their corresponding names or tasks, so work with the full data range.

Formatting and Making a Checklist Easier to Read

Conditional formatting can make the status more visible than the small checkbox alone. In Google Sheets, select the cells or rows to format and choose Format > Conditional formatting. For example, you can apply a style when a checkbox cell is TRUE, or use a custom formula to format the task name in the same row. Make sure the rule’s range and references match your layout; a rule aimed at the wrong column may format unrelated cells.

You can also freeze a header row, add filters, and use clear column labels such as “Task” and “Done.” These choices help collaborators understand how to use the sheet without changing the meaning of the checkbox. If the sheet includes formulas or important data, consider protecting those ranges while leaving the checkbox cells editable. Protection settings and sharing permissions control who can edit; a checkbox itself is not a permission or security feature.

Common Problems and Fixes

“Checkbox” is unavailable or does not appear: Confirm that you are working in Google Sheets and have selected cells in the grid. If you have view-only access, ask the owner for editing permission; you may not be able to change the sheet.
A formula does not count the checked boxes: Check whether the boxes use default TRUE/FALSE values or custom values. A formula counting TRUE will not count a custom checked value such as “Done.” Also check that the formula’s range covers the checkbox cells.
Text appears instead of a checkbox: The cell may contain text, or it may not have checkbox validation. Select it and choose Insert > Checkbox, or inspect its rule through Data > Data validation.
Checkboxes changed when pasting: Pasting can replace both values and validation rules. Undo promptly if appropriate, or restore the intended checkbox range and values. Before a large paste, consider copying a small sample first.
A task disappears from the view: A filter may be hiding rows based on the checkbox value. Clear or adjust the filter; filtering hides records from view but does not normally delete them.

Google Sheets Checkboxes Compared with Excel

This guide describes Google Sheets in a web browser. Excel has its own checkbox features and data-validation options, but menu paths and behavior vary by Excel version; Insert > Checkbox in Sheets is not an instruction for Excel. If a workbook moves between products, verify how the checkbox values and validation rules were converted rather than assuming they will behave identically.

For a sheet intended to stay in Google Sheets, the built-in checkbox is generally more direct than typing symbols such as “☑” and “☐.” Symbols can look like checkboxes, but they are text, not clickable controls, and formulas cannot interpret them as Boolean values unless you build formulas around those exact characters. A checkbox is the better choice when users need to click and formulas need to evaluate the result.

Frequently Asked Questions

Can I add checkboxes to multiple cells at once?
Select the full range first, then choose Insert > Checkbox. Sheets adds a checkbox to each selected cell, so you can set up a whole checklist column in one operation.

How do I count checked boxes in Google Sheets?
For default checkboxes, use COUNTIF with TRUE as the criterion, such as =COUNTIF(B2:B20,TRUE) when the checkboxes are in B2:B20. If you set custom values, use the checked value as the criterion instead.

Can I change the value a checkbox returns?
Yes. Select the checkbox cells and edit their rule through Data > Data validation. Set custom checked and unchecked values if the default TRUE and FALSE values do not suit your sheet.

Can other people click checkboxes in a shared sheet?
People with editing access can generally change editable checkbox cells. Viewers cannot make edits. The owner can also protect ranges or adjust sharing permissions, so access depends on the sheet’s settings.

Can a checkbox automatically record who checked it?
No. A standard checkbox stores a value, not the identity of the person who changed it or the time of the change. Keep separate fields or use a suitable tracking process if you need that information.

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.