How to Add and Use Checkboxes in Google Sheets

Checkboxes in Google Sheets turn cells into interactive toggles. They are perfect for task lists, habit trackers, and any spreadsheet that needs yes/no inputs.

Select Your Cells

Highlight the cells where you want checkboxes to appear.

Insert Checkboxes

Go to Insert > Checkbox. Checkboxes will appear in all selected cells.

💡 You can also right-click a cell and choose "Insert checkbox" from the menu.

Use Checkbox Values in Formulas

When checked, a checkbox has a value of TRUE. When unchecked, FALSE. Use =COUNTIF(range, TRUE) to count completed items.

Apply Conditional Formatting to Checkboxes

Create a conditional formatting rule that highlights the row green when the checkbox is TRUE. This visually marks completed tasks.

Try These Templates

To Do List Template Habit Tracker Template

Frequently Asked Questions

Can I change the checkbox label?

Checkboxes do not have labels. Use the adjacent cell for a label.

Can I use checkboxes in formulas?

Yes. Checkboxes return TRUE when checked and FALSE when unchecked.