Adding a Checkbox in Google Sheets: Steps and Tips

To add a checkbox in Google Sheets in a web browser, select the cell or range where you want it, then choose Insert > Checkbox. Each checkbox can be clicked to switch its cell between checked and unchecked, making it useful for task lists, reviews, simple trackers, and formula-driven summaries.

How to add a checkbox

The basic method works for one cell or a selected range. You do not need to create a special column first: inserting the checkbox adds a checkable control to the selected cell or cells.

Open the spreadsheet in Google Sheets and select the cell, or drag across the range of cells, where the checkboxes should go.
Choose Insert > Checkbox from the menu bar.
Click a checkbox to mark it. Click it again to clear it.

For example, select B2:B20 to add a checkbox beside each item listed in A2:A20. To make a small checklist, select only the cells you intend to use; inserting checkboxes across an entire column can make the sheet harder to navigate. You can add more checkboxes later by selecting additional cells and repeating the menu command.

Checkboxes can also be copied and pasted along with other cell content. This is handy when extending a template, but check the destination cells afterward: pasting may replace existing content or validation rules. If you only need to reuse the checkbox setup, selecting a new range and using Insert > Checkbox is often the simplest option.

What a checkbox stores

A checkbox is more than a visual symbol. In its standard setup, its cell contains the Boolean value TRUE when checked and FALSE when unchecked. Those values let formulas, filters, and conditional formatting respond to the user’s choice. The cell still behaves like a spreadsheet cell, so other content or rules applied to it can affect how the checkbox works.

The check mark itself is not a separate drawing floating above the grid. It is the cell’s displayed control associated with a value and a data-validation rule. This distinction matters when you copy, sort, filter, or use the cell in a formula: you are working with the value in the cell, not just an icon that has no underlying data.

With the default values, you can use a checkbox as a yes/no flag, a completion status, or an on/off setting. It does not automatically record who checked it or when. If you need an audit trail, timestamp, or approval history, a checkbox alone is not enough; you will need an additional process, formula arrangement, or script designed for that requirement.

Choose the right cells and layout

Plan the range before inserting checkboxes. A common task-list layout puts the description in one column and the checkbox in the next, such as task names in A2:A20 and completion boxes in B2:B20. Keep a header row above the list, and avoid putting unrelated notes in the checkbox column. Clear headings such as “Task” and “Done” make the purpose easier to understand when the sheet is shared.

Use one checkbox per record when each row represents one task, order, or review item.
Use a separate status column if you need more than two states, such as “Not started,” “In progress,” and “Complete.” A checkbox only offers a checked and unchecked state.
Keep summaries outside the input range so that totals and instructions do not get mixed into the cells users are meant to click.
Use clear labels near the checkboxes, especially if the meaning of a check mark is not obvious.

Checkboxes can work in filtered tables and lists, but keep each checkbox associated with the correct row as you sort data. Select and sort the whole dataset, rather than sorting only the checkbox column; sorting one column by itself can separate completion marks from their corresponding tasks.

Use checkboxes in formulas

Because standard checkboxes store TRUE or FALSE, formulas can count checked items or return a related status. This is a useful way to make a checklist report progress without manually updating a separate total. The formulas below use the default checkbox values.

With checkboxes in B2:B6, where B2, B3, and B5 are checked, use =COUNTIF(B2:B6,TRUE) in a summary cell. It returns 3, the number of checked boxes in that range. If a row has no checkbox or contains a different value, it will not count as TRUE.

With a checkbox in B2 and its task name in A2, enter =IF(B2,"Done","Open") in C2 to show a text status. If B2 is checked, the result is “Done”; if it is unchecked, the result is “Open.” Fill or copy the formula down column C for other rows, adjusting the references as needed. The formula reports the checkbox state; it does not change the checkbox itself.

These examples assume the standard TRUE/FALSE values. If you set custom checked and unchecked values, update formulas to test for those values instead. Also, a formula that refers to a checkbox should not be placed in the same cell as that checkbox: the formula would replace the checkbox value or rule rather than sit alongside it.

Build a useful checklist

For a practical to-do list, put one task on each row, add checkboxes in a dedicated completion column, and place a short instruction above the list if other people will use it. A checkbox can show completion, but it does not enforce a sequence. Someone can check the last task before the first, and the sheet will accept that state unless you build extra logic around it.

You can make progress easier to scan by using Format > Conditional formatting to change the appearance of a task row when its checkbox is checked. For example, apply a formatting rule to the task-name range and use a custom formula that refers to the checkbox in the same row. Choose the range and rule carefully, and verify the first row reference: a rule applied to A2:A20 should normally refer to the checkbox in row 2, so it can adjust as the rule evaluates later rows. Conditional formatting changes appearance; it does not replace the checkbox value or automatically prevent edits.

Another option is to filter the list to show only incomplete tasks. When the checkboxes use standard values, filtering the checkbox column by FALSE can isolate unchecked rows. This is useful for a shared action list, though users should understand that a filter changes what is visible, not what is deleted. Clear the filter or show all values when you need to review completed entries too.

Custom checkbox values

If TRUE and FALSE are not meaningful to the people using the sheet, Google Sheets lets you assign custom values to a checkbox. Select the relevant cells and open Data > Data validation. In the data-validation controls, set the criterion to Checkbox, then enable the option for custom cell values and enter the values for checked and unchecked. The exact controls appear in the validation panel, so check that both values are clear before applying the rule.

For example, a team might use “Approved” for a checked box and “Pending” for an unchecked one. Those words become the cell values, not just labels printed beside the control. A formula that counts checked items must then look for “Approved,” rather than TRUE. Custom values can make a sheet easier for collaborators to interpret, but they can also complicate formulas or data exports if a downstream process expects Boolean values.

Use custom values when they solve a real clarity problem. For a personal checklist or a formula-based progress tracker, the default TRUE/FALSE values are usually straightforward and work naturally with common spreadsheet logic. If a checkbox is meant to represent several different statuses, use a dropdown list instead of trying to make a two-state control do the work of a multi-state field.

Common checkbox problems

The checkbox is not clickable: Make sure you have permission to edit the sheet and are not viewing a protected range. A viewer or commenter may be unable to change cell values.
A formula returns an unexpected count: Confirm that the boxes use default TRUE/FALSE values and that the formula range includes the intended cells. Custom values require formulas that match those values.
The checkboxes disappeared: Check whether a paste operation, deletion, or change to data validation replaced or removed the rule. You can select the intended cells and add the boxes again with Insert > Checkbox.
Text or a number appears instead of a box: The cell may have a different value or validation rule. Review its contents and the rule under Data > Data validation, then restore the checkbox criterion if needed.
Checkboxes no longer match their tasks: Sort the complete table or range, not just the checkbox column, so each row’s fields stay together.

To remove checkboxes while keeping the rest of a sheet intact, select the affected cells and remove their checkbox data-validation rule using Data > Data validation. Clearing a checked value is not always the same as removing the checkbox control; if the box remains after clearing, remove the rule rather than repeatedly deleting cell contents.

Sharing and practical limits

When you share a checklist, tell collaborators what checked means and who is expected to update it. People with editing access can generally change editable checkbox cells; people with view-only access cannot update them. If only certain people should mark items complete, protect the relevant range or manage access appropriately. Protection is not a substitute for a clear workflow, and spreadsheet permissions should match the sensitivity of the information in the file.

Checkboxes are small controls, so they work best when the sheet has a clear structure and a limited number of decision states. They do not automatically send notifications, create a timestamp, assign a task, or verify that work was actually completed. They record a selection. For a more involved process with multiple roles, deadlines, comments, or approvals, a dedicated task-management tool or a carefully designed spreadsheet workflow may be a better fit.

Google Sheets can be used in a browser without buying a separate checkbox add-on; the feature is built into the spreadsheet menus. Account or organization policies can affect which files you can edit and share, but adding a standard checkbox itself does not require a paid extension. If a menu is unavailable, check your access level and whether the sheet or range is protected before assuming the feature is missing.

Frequently Asked Questions

Can I add checkboxes to multiple cells at once?

Yes. Select the full range, such as B2:B50, and choose Insert > Checkbox. Google Sheets adds a checkbox to each selected cell. Confirm the selection first so you do not overwrite data elsewhere.

How do I count checked boxes in Google Sheets?

With default checkbox values, use COUNTIF on the checkbox range and the value TRUE. For example, if the boxes are in B2:B20, =COUNTIF(B2:B20,TRUE) counts the checked cells. If you assigned custom values, count the checked value you selected instead.

Can a checkbox show Done or Not Done instead of TRUE or FALSE?

Yes. Open Data > Data validation, choose the Checkbox criterion, and set custom values for checked and unchecked. Those custom labels become the values stored in the cells, so formulas that refer to them must use the new values.

How do I delete a checkbox without deleting the whole row?

Select the checkbox cell or range and remove its checkbox rule through Data > Data validation. That removes the control from the selected cells without requiring you to delete the row. Be careful if those cells also contain other validation rules you want to keep.

Why can’t I click a checkbox in a shared spreadsheet?

You may have view-only or comment-only access, or the cell may be in a protected range. Ask the owner for editing access or permission to edit that range. If you already have access, check whether the sheet is protected or whether the checkbox rule was removed.

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.