How to Insert a Checkbox in Google Sheets and Use It

To insert a checkbox in Google Sheets in a web browser, select the cell or range where you want it, then choose Insert > Checkbox. Each checkbox is interactive: click it to mark it checked or unchecked, and use its value in formulas, filters, and other parts of your sheet.

Insert a checkbox in one cell

Start by opening the spreadsheet and selecting the cell that should contain the checkbox. In the Sheets menu bar, click Insert, then Checkbox. The cell displays an empty box; click it to check it, and click again to clear it. You can also use the arrow keys to select a checkbox cell and press the space bar to toggle it, which can be convenient when working through a column without a mouse.

A checkbox is useful when a cell needs to represent a simple yes-or-no state: complete or incomplete, approved or not approved, received or still outstanding. It keeps the choice visible and makes it easier to update than typing a word each time. You do not need to turn on a special mode or install an add-on; the checkbox is a built-in cell feature.

If the Insert menu is unavailable, check that you have permission to edit the spreadsheet. View-only access does not let you add or change checkboxes. In a shared file, an owner or editor may need to change your access level.

Add checkboxes to a range

For a checklist or tracker, add checkboxes to multiple cells at once. Select the cells first—for example, B2:B20—and choose Insert > Checkbox. Sheets places a checkbox in each selected cell. Selecting a range before inserting is usually quicker and more consistent than adding the boxes one by one.

You can also copy an existing checkbox cell and paste it into other cells, or use the fill handle to extend it down a column. If you copy a checkbox, check the destination cells afterward: pasting can replace existing cell contents or formatting. A useful layout is to put task names in column A and the corresponding checkboxes in column B, with one task per row. Leave the header row for labels such as Task and Done.

To create a short personal list, select just the cells beside the tasks you have entered.
For a reusable tracker, insert boxes down the rows you expect to use, but avoid applying them to an entire worksheet unless that is genuinely useful.
To remove a checkbox, select its cell or range and press Delete, or use Edit > Delete values. This removes the cell contents; it does not delete the whole row.

What a checked box means in the sheet

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

The visible box is the control you click; the underlying cell value is what formulas and many other spreadsheet features evaluate. If you use a checkbox cell in a formula, avoid typing a status over the checkbox itself, because replacing the cell value can remove or disrupt the checkbox. Keep descriptive notes in a neighboring column instead.

Checkboxes can also use custom checked and unchecked values. Select the cells, choose Data > Data validation, and inspect the checkbox criterion in the data validation panel. Turn on the option to use custom cell values, then specify the values for checked and unchecked states. For example, a team might choose Yes and No instead of TRUE and FALSE. The box remains clickable, but formulas must then look for the chosen custom value rather than the default Boolean value.

Use checkboxes in formulas

Because checkboxes store values, you can summarize a checklist without manually counting marks. For example, with checkboxes in B2:B6 and three of those five boxes checked, this formula returns 3:

With checkboxes in B2:B6 using the default values, enter =COUNTIF(B2:B6,TRUE) in another cell. It counts the checked boxes. If you change to custom values, update the criterion—for example, count Yes rather than TRUE.

You can also calculate a completion rate. Suppose task names are in A2:A6, checkboxes are in B2:B6, and all five task-name cells are filled. With three boxes checked, this formula returns 60% when the result cell is formatted as a percentage:

With task names in A2:A6 and default checkboxes in B2:B6, enter =IFERROR(COUNTIF(B2:B6,TRUE)/COUNTA(A2:A6),0). The denominator counts the nonblank task names, so blank rows do not lower the rate. IFERROR returns zero if there are no task names to count, rather than displaying a division error.

For a simple status label, you can make a neighboring cell display Done when its checkbox is checked and Pending otherwise. With the checkbox in B2, enter =IF(B2=TRUE,"Done","Pending") in C2. Copy the formula down for other rows. If the checkbox uses custom values such as Yes and No, compare B2 with the custom checked value instead.

Highlight completed rows automatically

Conditional formatting can make a checklist easier to scan by changing the appearance of a task row when its box is checked. Select the rows to format—for example, A2:C10—and choose Format > Conditional formatting. In the panel, set the formatting rule to use a custom formula, then enter =$B2=TRUE. Choose a text or fill style and apply the rule. The dollar sign fixes the checkbox column at B while the row number adjusts for each row.

This approach changes formatting, not the checkbox value or the row’s contents. It is useful for dimming finished tasks, applying a fill color, or making a completed item stand out. If your boxes are in another column, change the B in the formula to that column. For custom checkbox values, test the relevant value instead of TRUE.

Common checkbox problems and fixes

The checkbox is missing. Confirm that you selected the intended cells before choosing Insert > Checkbox, and check that you have edit access. If you expected boxes down a column, make sure the selected range included all those rows.
A formula does not count checked boxes. Check whether the cells use default TRUE/FALSE values or custom values. Also check that the formula range covers the checkbox cells, not the task-name column. Default checked boxes are logical TRUE values; custom text such as Yes needs a matching text criterion.
The box disappeared after typing. Typing a value into the checkbox cell can replace its checkbox content. Reinsert the checkbox with Insert > Checkbox, and keep any notes in a separate cell.
Every row highlights, or the wrong row highlights. Review the conditional-formatting range and the column reference in the custom formula. For boxes in column B, =$B2=TRUE is appropriate when the selected range begins on row 2. A mismatched starting row can make the rule appear shifted.
The checkboxes do not respond. Make sure the file is not open in a read-only state and that a cell is selected normally, rather than editing text inside the cell. Browser or access issues can also affect interaction; reload the sheet if the interface appears stuck.

Choose the right checklist setup

Checkboxes work best when a task has two meaningful states, such as not done and done. They are less suitable when a person must select among several options. For example, a project status with Not started, In progress, Blocked, and Complete is better represented by a dropdown than by a single checkbox, because a checkbox only expresses a binary choice.

Before inserting a large range, decide what a checked box will mean and whether unchecked should mean not started, incomplete, or simply not reviewed. Those meanings are easy to confuse in shared trackers. Use a clear column heading, explain any custom values, and avoid treating an empty or unreviewed row as equivalent to a confirmed No unless that is intended.

For a small list, one checkbox column may be all you need. For a shared work tracker, add owner, due date, or notes in separate columns so that the checkbox does not have to carry information it cannot express. Keep related data on the same row so filtering and sorting are less likely to separate a task from its status.

Checkboxes compared with other options

A checkbox is faster to scan and click than typing a status repeatedly, and its Boolean value is convenient for simple formulas. A dropdown is more flexible when there are multiple valid states, but it takes more interaction to choose an option. Plain text is simplest for free-form explanations, though it is easier for people to enter inconsistent labels such as done, Done, and complete.

These controls serve different purposes. Use checkboxes for binary actions, dropdowns for a defined set of choices, and text cells for notes or details. If you need both a completion mark and an explanation, use a checkbox plus a separate notes column rather than trying to make one cell do both jobs.

The instructions here are for Google Sheets in a web browser. Google Sheets has separate Android and iOS apps whose controls and menus can differ from the browser interface. Excel is a different spreadsheet program, so its checkbox insertion steps and cell behavior are not the Google Sheets menu path described above.

Frequently Asked Questions

Can I insert checkboxes in multiple Google Sheets cells at once?
Select the whole range, such as B2:B20, and choose Insert > Checkbox. Sheets adds one checkbox to each selected cell. Review the range first so you do not overwrite existing data.

How do I count checked boxes in Google Sheets?
With default checkbox values in B2:B20, use =COUNTIF(B2:B20,TRUE) in an empty cell. If the checkboxes use custom checked values, use that value as the criterion instead of TRUE.

Can I use words instead of TRUE and FALSE?
Yes. Select the checkbox cells, open Data > Data validation, and set custom values for the checked and unchecked states. Update formulas that refer to those cells so they test the custom values.

How do I delete a checkbox without deleting its row?
Select the checkbox cell or range and press Delete, or choose Edit > Delete values. The row remains in the sheet. Be aware that deleting values also clears other selected cell contents.

Can a checkbox automatically change a task’s color?
Yes. Use Format > Conditional formatting with a custom formula that tests the checkbox cell, such as =$B2=TRUE for a range beginning on row 2 when the boxes are in column B. Choose the formatting style you want in the rule panel.

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.