Google Sheets Checkbox Format: Setup, Values, and Tips

In Google Sheets, select the cells where you want boxes, then choose Insert > Checkbox. A checkbox is a cell control, not just a symbol: by default, a checked box stores TRUE and an unchecked box stores FALSE, so you can use it in formulas, filters, and formatting rules.

What a Google Sheets checkbox contains

A Sheets checkbox combines a visible square with a value in its cell. When someone clicks the box, the displayed state changes and the cell value changes with it. The default values are the logical values TRUE and FALSE, rather than the text strings “TRUE” and “FALSE.” That distinction matters when a formula evaluates the cell or when you build a summary.

For example, a task list might have task names in column A and checkboxes in column B. A checked box in B2 means the task in A2 is complete; an empty box means it is not complete. The cell still participates in ordinary spreadsheet operations, but the checkbox is the convenient interface for changing its value.

Checkboxes are useful for completion lists, attendance, approval steps, inventory checks, and simple input forms. They are best when each item has two meaningful states. They are not a replacement for a drop-down when a person must choose among several options such as Pending, In progress, and Done.

Add checkboxes to one cell or a range

In Google Sheets in a web browser, add a checkbox this way:

Select a cell, or drag to select the range that should contain checkboxes.
Choose Insert > Checkbox from the menu.
Click a box to test it. Click again to clear it.

For a task list, you could put task descriptions in A2:A10, select B2:B10, and insert checkboxes in the selected range. Each row then has an independent box. You can also select a whole column or a larger range before inserting them, but avoid applying them to thousands of unused rows unless there is a reason: a large validation range can make a sheet harder to navigate and maintain.

To add boxes to a range that already contains data, first consider whether the existing values should be replaced. Checkbox cells use their values to represent the checked state, so applying the control to cells with unrelated content can change how that content is handled. If you need to preserve the original information, use a separate column for the checkboxes.

Set custom checked and unchecked values

The default TRUE and FALSE values work well for formulas, but some workflows call for different values. For example, an export might need the words Yes and No, or a scoring sheet might need 1 and 0. Select the checkbox cells and open Data > Data validation. In the validation rule, set the criteria to Checkbox, enable Use custom cell values, and enter the value for checked and the value for unchecked. The exact controls appear in the data validation side panel.

After saving the rule, the box still appears as a checkbox, but clicking it writes the selected custom value. Choose values consistently across the range. If you use Yes and No, formulas that previously tested for TRUE must instead test for Yes. Text values and Boolean values are not interchangeable merely because they describe the same state.

Custom values are useful when another system expects a particular label or when a sheet is designed for people who find words clearer than TRUE and FALSE. They can also complicate formulas, so use the defaults unless a downstream requirement makes custom values worthwhile. If you change a rule later, check a few existing cells to confirm their current values match the intended checked or unchecked state.

Change appearance and apply conditional formatting

Sheets does not offer a separate menu for changing a checkbox into a different shape or choosing a custom checkmark design. The checkbox is the control; ordinary cell formatting can still change aspects of its surrounding cell, such as fill color, borders, and text formatting. Select the cells and use the toolbar or the Format menu for those cell-level changes. These settings do not turn the checkbox into an icon or change what value it stores.

A practical way to make completion status more visible is conditional formatting. Suppose checkboxes are in B2:B20 and task descriptions are in A2:A20. Select A2:B20, choose Format > Conditional formatting, and use a custom formula rule. With the checkboxes in column B, the formula =$B2=TRUE applies the rule to a row when its box is checked. Set a light fill or strikethrough style in the rule and apply it to the selected range. The dollar sign fixes the checkbox column while the row number adjusts for each row.

If you want to color only the checkbox cells, apply the same rule to B2:B20 instead. For a custom checked value such as Yes, use a condition that compares the cell with that value, such as =$B2="Yes". In a Google Sheets custom formula field, the leading equals sign is required. Check the selected range and column references carefully: a rule can be valid but highlight the wrong rows if its starting row does not match the range.

Use checkbox values in formulas

Because the default checkbox values are Boolean, formulas can count checked items or produce a status label. With task checkboxes in B2:B20, =COUNTIF(B2:B20,TRUE) counts checked tasks. If five of those cells contain TRUE, the result is 5. To count unfinished tasks instead, use FALSE as the criterion: =COUNTIF(B2:B20,FALSE). These examples assume the range contains ordinary checkbox values, not custom text or numbers.

You can also show a word beside each box. With a checkbox in A2, enter =IF(A2,"Done","Open") in B2 and fill the formula down alongside the checkboxes. For example, if A2 is checked, B2 displays Done; if A2 is unchecked, it displays Open. If your boxes use custom values, update the condition to match them. For a Yes/No checkbox, a formula could test whether A2 equals Yes instead of relying on TRUE.

These formulas make checkboxes useful as inputs to a small dashboard. A total can show completed items, while a percentage can compare completed items with the number of tasks. Make sure the denominator excludes blank or non-task rows; otherwise, the displayed completion percentage may be misleading. For a changing task list, keep the checkbox range aligned with the rows included in the summary.

Remove, copy, and manage checkbox rules

Copying a checkbox cell can copy its validation rule as well as its value and formatting. This is helpful when extending a list, but check that copied boxes are in the intended cells and that formulas beside them adjust correctly. When pasting, the paste option can affect whether values, formatting, or validation are carried over, so inspect the result if the destination already has its own rules.

To remove checkboxes while keeping the rest of a sheet intact, select the cells and use Data > Data validation to remove the checkbox rule in the side panel. Clearing a cell’s value and removing its validation are different actions: if the rule remains, the cell may still behave as a checkbox. Conversely, removing the rule does not necessarily remove other formatting such as a fill color or border, so clear that separately if you want a plain-looking range.

If you need a blank-looking checkbox range for a fresh checklist, remove or reset the existing values as appropriate, then confirm that the checkbox rule remains. If the goal is to delete the controls entirely, remove the validation rule rather than relying only on a visual change. This distinction helps avoid a sheet that appears cleared but still accepts checkbox input.

Common checkbox problems and fixes

A formula does not recognize a checked box: confirm whether the rule uses the default TRUE/FALSE values or custom values. Update the formula to test the actual cell value.
A box is not visible: check that the cell has a checkbox rule and that the row or column is not hidden or unusually small. Also inspect whether a fill or text color makes the cell hard to distinguish.
Typing into the cell replaces the state: a checkbox cell stores a value, so entering other content can interfere with the intended control. Put notes or descriptions in a neighboring cell.
Rows highlight incorrectly: check the conditional formatting range and references. The formula’s row should correspond to the first row of the apply-to range, and the checkbox column should be fixed if the rule spans multiple columns.
Sorting separates tasks from their boxes: select the full table before sorting, not just the checkbox column. Sorting a single column can detach statuses from the related task names.

Also remember that a checkbox is not a security or approval mechanism. Anyone with permission to edit the sheet may be able to change its state, and a checked box does not prove that a task was independently reviewed. Protect ranges or manage sharing permissions when a workflow requires editing restrictions, and make those controls clear to collaborators.

Checkboxes compared with alternatives

Use a checkbox for a binary choice that can be changed quickly, such as done/not done or present/absent. Use a drop-down when the state has three or more options, when consistent wording matters, or when a reviewer needs to choose among stages. Google Sheets drop-downs are configured through Insert > Dropdown or the data validation controls, depending on the interface. A plain text cell is more flexible but less consistent and harder to summarize reliably.

A checkbox also differs from inserting a checkbox-shaped character or image. A character is only displayed text; it does not toggle a Boolean value when clicked. An image can illustrate a status but is not a cell value for COUNTIF or IF formulas. If you want interactive status tracking, use the built-in checkbox rather than a decorative symbol.

Excel has its own checkbox features and menu paths, which vary with the Excel version and feature availability. The Google Sheets instructions here should not be assumed to describe Excel. In Sheets, the key idea is the same throughout: the visible box is tied to a cell value, and formulas should test the value your checkbox rule actually stores.

Frequently Asked Questions

How do I format a checkbox in Google Sheets?
Choose Insert > Checkbox to add one. Use regular cell formatting for borders, fill, and nearby text, or use conditional formatting to highlight a checked row. Sheets does not provide a separate control for redesigning the checkbox symbol itself.

What value does a checked checkbox return?
By default, a checked box returns TRUE and an unchecked box returns FALSE. If the checkbox rule has custom values, it returns the checked or unchecked value specified in that rule instead.

Can I change TRUE and FALSE to Yes and No?
Yes. Select the checkbox range, open Data > Data validation, choose the checkbox criterion, and enable custom cell values. Enter Yes and No as the checked and unchecked values, then adjust formulas that refer to those cells.

How can I count checked boxes?
With default checkboxes in B2:B20, use =COUNTIF(B2:B20,TRUE). The result is the number of checked cells in that range. If you chose custom checked values, use that value as the COUNTIF criterion instead.

How do I delete a checkbox but keep the cell?
Select the cell or range, open Data > Data validation, and remove the checkbox rule. If you want to retain the value or formatting, check those separately after removing the rule; deleting validation and clearing cell contents are not the same operation.

Can I add checkboxes on a phone?
Google Sheets has mobile apps, but their controls and menus can differ from the web-browser steps above. For the menu paths described here, open the sheet in Google Sheets in a web browser and use Insert > Checkbox.

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.