How to add checkboxes in Google Sheets
Learn how to insert, customize, and use checkboxes in Google Sheets for to-do lists, tracking, and dynamic charts.
Quick answer
To add checkboxes in Google Sheets, select the cells where you want them, then click Insert in the menu bar and choose Checkbox. Google Sheets instantly fills each selected cell with an interactive checkbox. You can customize checked and unchecked values through data validation, or delete checkboxes by selecting them and pressing Delete.
Steps at a glance
- Open your spreadsheet and select the target cells
- Click Insert in the top menu
- Choose Checkbox from the dropdown list
- Click any checkbox to toggle it on or off
- Optionally set custom checked/unchecked values via data validation
- Select and press Delete to remove checkboxes
Summary
Checkboxes turn ordinary spreadsheet cells into clickable TRUE/FALSE toggles, making Google Sheets useful for to-do lists, attendance trackers, and progress dashboards. Because checkbox values behave like boolean data, they work seamlessly with filters, functions, and charts, so you can build interactive tools without any scripting.
Step-by-step guide
Step 1
Select the cells for your checkboxes
Open your spreadsheet and click and drag to highlight the cell or range of cells where you want checkboxes to appear. This can be a single cell, a column, or a block of cells across multiple rows — for example, a column next to a task list.
Step 2
Insert the checkboxes
Click Insert in the top menu bar, then select Checkbox from the dropdown menu. Google Sheets immediately fills every selected cell with an unchecked checkbox, and any cell that already contained text or a value gets replaced with a default checkbox state.
Step 3
Click to check or uncheck boxes
Click directly on any checkbox to toggle it between checked and unchecked. Behind the scenes, a checked box holds the value TRUE and an unchecked box holds FALSE, which you can reference in formulas just like any other cell value.
Step 4
Set custom checked and unchecked values (optional)
Select your checkbox cells again, then open Data > Data validation and choose Checkbox as the criteria. Turn on 'Use custom cell values' and enter your own text for the checked and unchecked states, such as 'Done' and 'Pending', instead of TRUE and FALSE. This same data validation menu also lets you build dropdown-style rules elsewhere in your sheet.
Step 5
Use checkboxes with formulas and filters
Reference checkbox cells in formulas like COUNTIF or SUM to track completed tasks, since TRUE counts as 1 and FALSE counts as 0. You can also apply a filter to your task list so only unchecked or checked rows are visible at a glance.
Step 6
Copy checkboxes to more cells
Select a cell that already contains a checkbox, copy it with Ctrl+C (or Cmd+C on Mac), then select the new range and paste with Ctrl+V. Pasted cells inherit the same checkbox format instead of requiring you to repeat the Insert menu steps.
Step 7
Remove checkboxes when no longer needed
Select the checkbox cells you want to clear, then press Delete on your keyboard. This removes the checkbox format entirely, leaving the cells empty and ready for regular text or numbers again.
Why this matters
You're building a task tracker, project checklist, or attendance sheet and need a quick way to mark items complete without typing 'yes' or 'x' every time. Adding real checkboxes lets you click to toggle status instantly, then filter, count, or chart that data automatically.
Frequently asked questions
Can I add checkboxes to multiple cells at once?
Yes. Highlight the entire range of cells first, then click Insert > Checkbox. Every selected cell gets its own independent checkbox at the same time.
Do checkboxes work with charts and pivot tables?
Yes, since checkbox values are treated as TRUE/FALSE data, you can use them as filters or data sources for a [pivot table](/guides/google-sheets/create-a-pivot-table) or [chart](/guides/google-sheets/create-a-chart) to visualize completion rates.
Can I change what a checked box displays besides TRUE?
Yes. Use Data > Data validation, choose Checkbox, enable custom cell values, and type your own labels for the checked and unchecked states, such as 'Complete' and 'Incomplete'.
Why can't I click my checkbox?
The sheet or specific range may be protected. Check whether the cells are locked under Data > Protected sheets and ranges, or confirm you have edit access to the file.
Create interactive demos like this one — free, no coding required.
Start for free →