How to Create a Checkbox in Google Sheets (and Use It)

To create a checkbox in Google Sheets in a web browser, select the cell or range where you want it, then choose Insert > Checkbox. Click a box to check or clear it; Sheets stores the standard checkbox state as TRUE or FALSE, so you can also use it in formulas and formatting.

Add a checkbox to one cell or a range

The quickest way to make a checkbox is through the Insert menu. Open the spreadsheet, select the destination cell, and choose Insert > Checkbox. A checkbox appears in the selected cell. To add a row of boxes, select the full range first; for example, select B2:B20 and then choose Insert > Checkbox to add one to every cell in that range.

Click the cell where the first checkbox should appear, or drag to select a range.
Choose Insert > Checkbox from the menu at the top of Google Sheets.
Click a checkbox to mark it, or click it again to clear it.

You can also select cells that already contain data and insert checkboxes, but doing so can replace the existing cell contents. If those values matter, copy them elsewhere before changing the cells. To add boxes to separated cells, hold Ctrl on Windows or Command on Mac while selecting the cells, then use the Insert menu. For a continuous column, selecting a range is faster and reduces the chance of missing a row.

Set up a useful checklist

A checkbox is most useful when its meaning is obvious from the surrounding labels. For a task tracker, put task names in column A and checkboxes in column B. For example, A1 could say Task and B1 could say Done; put the actual tasks in A2:A10 and add checkboxes to B2:B10. A date, owner, or priority can go in another column. The checkbox itself does not explain what the task is, so a clear header and concise task descriptions make a shared sheet easier to use.

For a personal to-do list, add boxes beside errands or steps and mark them as you finish. In an inventory sheet, a checkbox might mean that an item has been inspected, not that it is in stock. Define that meaning in a header or note so collaborators do not interpret checked and unchecked states differently. A checkbox is a single two-state value, not a replacement for a status field with several choices such as Not started, In progress, and Done.

What checked and unchecked mean

By default, a checked Google Sheets 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 using formulas: a formula that checks a Boolean value can behave differently from one that searches for text. You can see the underlying state by referencing the cell in another formula, or by temporarily removing the checkbox validation if you need to inspect ordinary cell content.

Checkboxes are a type of data validation. They restrict a cell to the permitted checked and unchecked states rather than accepting arbitrary entries. If someone types an unrelated value into a validated checkbox cell, Sheets may reject it or show a validation warning, depending on the rule settings. This makes checkboxes more reliable than typing assorted markers such as x, yes, or complete, especially when formulas depend on consistent values.

Use custom checkbox values

If TRUE and FALSE are not convenient for your workflow, you can assign custom values. Select the checkbox cells, open Data > Data validation, and edit the checkbox rule in the panel. In the criteria options, choose the checkbox setting and enable custom cell values; enter the value to use when checked and the value to use when unchecked, then save the rule. The exact controls may be presented in a side panel, but the key is to edit the checkbox validation rule rather than simply type over the cell.

For example, a form might need a checked box to return Yes and an empty box to return No. Custom values can make the results easier for another system or a reader to interpret, but they also change what formulas must look for. If a formula expects TRUE and the checkbox now returns Yes, the formula will not count that selection unless you update its condition. Choose custom values only when there is a practical reason, and keep the values consistent across the range.

Count completed items with a formula

Because standard checkboxes return TRUE or FALSE, you can count checked boxes with COUNTIF. With standard checkboxes in B2:B6, and three boxes checked, enter =COUNTIF(B2:B6,TRUE) in another cell; the result is 3. The range in the formula should include only the checkbox cells you want counted. If you use custom checked values, replace TRUE in the formula with the value assigned to checked boxes.

You can use the count to show progress without changing the checklist itself. With checkboxes in B2:B6 and five total tasks, enter =COUNTIF(B2:B6,TRUE)&" of 5 complete" in a summary cell; if three boxes are checked, it displays 3 of 5 complete. This example uses the standard checkbox value. If you later add tasks, update both the checkbox range and the total displayed in the text, or use a separate formula to calculate the total so the summary does not become outdated.

Highlight completed rows

Conditional formatting can make a checked task easier to spot. For a checklist with task details in A2:C20 and checkboxes in B2:B20, select A2:C20 and choose Format > Conditional formatting. Under the formatting rules, select the option for a custom formula and use =$B2=TRUE, then choose a fill color or text style. The dollar sign fixes the checkbox column while the row number changes for each row in the selected range. When B2 is checked, the first row is formatted; when B3 is checked, the next row is formatted.

Check the apply-to range and the column reference if the wrong row changes color. If your checkboxes are in a different column, update B in the rule. If you use custom checkbox values, compare against the custom checked value instead of TRUE. Conditional formatting changes how cells look; it does not delete completed tasks or alter the checkbox state.

Copy, fill, and share checkboxes

To extend an existing checklist, copy a checkbox cell and paste it into another cell or range, or select the destination range and use Insert > Checkbox. Check the results after copying: copying a checked checkbox can also copy its current state, so the new box may start checked. If you want every new task to begin unchecked, confirm the state after pasting or insert a fresh checkbox rule into the destination range.

When multiple people edit the same sheet, collaborators with permission to edit can generally change checkbox states. Consider protecting cells that contain formulas or headings so they are not accidentally overwritten, while leaving the checkbox range editable. A checkbox does not record who clicked it or when; if the sheet needs an audit trail, use version history or a workflow designed to record changes rather than treating the box as a timestamp.

Common problems and fixes

The checkbox does not appear: Confirm that you selected the intended cells and used Insert > Checkbox. If you are in a read-only view or lack edit access, ask the owner for permission.
A formula does not count checked boxes: Verify that the formula range matches the checkbox range and that the boxes use standard TRUE/FALSE values. If custom values are enabled, use the custom checked value in the condition.
A box appears checked unexpectedly: The cell may have been copied from a checked box. Click it to clear it, or reset the relevant cells after copying.
Typing in the cell does not work as expected: The checkbox rule validates the cell. Edit or remove the validation rule if you need to use the cells for ordinary text instead.

Also check for accidental extra rows in a formula range. For example, counting a header cell along with the boxes can lead to confusing results if the range is not limited to the checkbox area. If the checkbox cells look like ordinary text rather than interactive controls, check whether the content was pasted as text or whether validation was removed.

Google Sheets checkboxes compared with Excel

The steps above are for Google Sheets in a web browser; its path is Insert > Checkbox. Excel’s interface and availability differ. Recent Microsoft 365 versions include in-cell checkboxes, while older Excel versions may rely on form controls available through the Developer tab. Do not assume a Google Sheets menu path or a sheet’s checkbox behavior transfers exactly to Excel. If you move data between the programs, check how the destination handles the checkbox values and any formulas that refer to them.

Frequently Asked Questions

Can I add checkboxes to many cells at once?
Select the full range, such as C2:C50, and choose Insert > Checkbox. Sheets adds a checkbox to each selected cell. If the range includes existing information, preserve it first because inserting checkboxes can replace cell contents.

How do I remove a checkbox?
Select the checkbox cell or range and press Delete or Backspace to clear its contents. If a checkbox still appears or the cell continues to enforce checkbox values, remove its validation rule using Data > Data validation. Clearing the value and removing the rule are separate actions.

Can I count how many checkboxes are checked?
Yes. With standard checkboxes in B2:B20, use =COUNTIF(B2:B20,TRUE) in a summary cell. It returns the number of checked boxes in that range. If you assigned custom values, use the checked value you configured instead of TRUE.

Can a checkbox automatically cross out a task?
Yes. Use conditional formatting on the task text and base the rule on the checkbox cell, as described above. Choose a strikethrough text style if it is available in the formatting options, or use a muted text color. The checkbox does not cross out neighboring cells by itself; the formatting rule connects the two.

Can I make a checkbox start checked?
Yes. Insert the checkbox, then click it to check it. If you are filling a range, you can set individual boxes as needed; take care when copying checked cells because the checked state may be copied along with the 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.