How to Add Checkboxes in Google Sheets (Tick Boxes)

To add a checkbox in Google Sheets, select the cells and go to Insert → Checkbox — each selected cell gets a tick box. By default a ticked box holds TRUE and an empty one holds FALSE, which means you can count, filter, and total them with ordinary formulas.

Add one checkbox or many

One cell: click the cell → Insert → Checkbox.

A whole column: drag down the range first (or select the column), then Insert → Checkbox. Every selected cell gets one, in a single action.

Remove them: select the cells → Insert → Checkbox again to toggle them off, or press Delete to clear the values while leaving the format.

What a checkbox actually stores

This is the part that makes them useful — a checkbox isn’t a picture, it’s a boolean value:

Because TRUE counts as 1, you can do arithmetic on checkboxes directly. That’s why a column of ticks can drive a progress bar with no extra helper columns.

Set custom checked and unchecked values

You don’t have to use TRUE/FALSE. A checkbox can hold any value you like — “Yes”/“No”, “Done”/"", a number, even a date.

1. Select the checkbox cells.
2. Go to Data → Data validation.
3. Next to Checked, type the value you want.
4. Next to Unchecked, type the other value.
5. Click Done.

Why bother? Two useful cases:

• “Done” / "" reads better if you’re printing or sharing the sheet as a checklist.
• A number — say 10 checked and 0 unchecked — lets you SUM a column and get a score instead of a count.

Remember that once you change them, the cells no longer hold TRUE/FALSE, so COUNTIF needs to look for your new value instead.

Count ticks with COUNTIF

The most common use — how many are done?

=COUNTIF(B2:B21, TRUE)

That counts the ticked boxes in B2 to B21. To show it as a fraction of the total:

=COUNTIF(B2:B21, TRUE) & " / " & COUNTA(B2:B21)

If you set custom values, count those instead:

=COUNTIF(B2:B21, "Done")

For the underlying counting rules, see Google Sheets formulas for beginners.

Make a progress bar from checkboxes

A neat trick — turn the tick count into a visual bar with REPT:

=REPT("█", COUNTIF(B2:B21, TRUE)) & REPT("░", COUNTA(B2:B21) - COUNTIF(B2:B21, TRUE))

That prints filled blocks for done items and empty ones for the rest. It updates live as people tick boxes.

Shade the ticked rows

To make completed rows grey out automatically, use conditional formatting with a custom formula:

=$B2=TRUE

Applied to the whole row range, that shades each row as its checkbox is ticked — the classic live to-do list. The full method, including custom formulas and how to apply them to a whole row, is in how to use conditional formatting.

Checkboxes vs. dropdowns

People often want one when they mean the other:

If you need “Pending / In progress / Done”, that’s a drop-down, not a checkbox. The Excel equivalent is covered in how to create a drop-down list in Excel.

On mobile

Checkboxes work in the Google Sheets app: tap the cell and the box toggles. Inserting new ones needs the app’s ＋ menu → Checkbox, though building a large set is faster on desktop.

Common problems

FAQ

How do I insert a checkbox in Google Sheets?

Select the cells → Insert → Checkbox. Select a range first to add many at once.

What value does a ticked checkbox have?

TRUE when ticked, FALSE when not. TRUE behaves as 1 in calculations, which is why checkboxes can be counted with COUNTIF and summed directly.

How do I count ticked checkboxes?

=COUNTIF(range, TRUE) counts the ticked boxes. If you set custom values, count those instead — e.g. =COUNTIF(range, "Done").

Can I change the checkbox values?

Yes — Data → Data validation and set the Checked and Unchecked values to whatever you want, including text or numbers.

Can I make a checkbox a progress bar?

Yes. =REPT("█", COUNTIF(range, TRUE)) scales a filled bar to the number of ticks, and updates live as boxes are ticked.