Insert a checkbox in three clicks

Open your Google Sheet and click the cell where you want the checkbox. Go to the menu bar, select Insert, then click Checkbox. Google Sheets will place an empty checkbox in that cell. Click it to toggle between checked and unchecked.

That is the whole process. You do not need to format anything or write a formula. The checkbox appears when ready and works right away.

If you want checkboxes in multiple cells at once, select all of them first (click one cell, hold Shift, click the last cell in the range), then go to Insert > Checkbox. Google Sheets will add a checkbox to every selected cell in one action.

Key Takeaways

  • Checkboxes go in individual cells through Insert > Checkbox and toggle between checked and unchecked with a single click.
  • You can add checkboxes to multiple cells at once by selecting the range first, then inserting.
  • Checkboxes work with formulas — you can count checked boxes, filter by checkbox status, or use them to trigger conditional formatting.
  • Checked boxes show as TRUE in formulas; unchecked boxes show as FALSE, so you can build task lists or tracking sheets that respond to what you check.

Use checkboxes to mark tasks complete or track status

Checkboxes turn a spreadsheet into a straightforward tracking tool. Create a column for task names, add checkboxes in the next column, and check them off as you finish each task. This works for to-do lists, project tracking, inventory counts, or anything where you need to mark something done or present.

The checkbox stays in the cell — it does not move to another column or create a separate entry. When you click it, it toggles when ready. You can see at a glance which items are checked and which are not.

Count checked boxes with a COUNTIF formula

Once you have checkboxes in your sheet, you can count how many are checked using the COUNTIF function. In an empty cell, type =COUNTIF(A2:A10,TRUE) and replace A2:A10 with the range of cells that contain your checkboxes. The formula will return the number of checked boxes.

To count unchecked boxes instead, use =COUNTIF(A2:A10,FALSE). This is useful if you want to see how many tasks remain incomplete or how many items still need review.

You can also use COUNTIF to count checkboxes across multiple columns or to count only the checked boxes in a filtered view. The formula treats a checked box as TRUE and an unchecked box as FALSE, so any formula that works with TRUE and FALSE values will work with checkboxes.

Filter your sheet to show only checked or unchecked boxes

Click the filter button (the funnel icon) at the top of your sheet to turn on filtering. Then click the filter arrow in the column that contains your checkboxes. You will see two options: TRUE (checked) and FALSE (unchecked). Select only TRUE to show completed tasks, or only FALSE to show what still needs to be done.

Filtering does not delete any rows — it just hides the ones you did not select. When you clear the filter, all rows reappear. This is useful for focusing on incomplete work or reviewing only the items you have already marked.

Use conditional formatting to highlight checked rows

You can make checked rows stand out by explore conditional formatting. Select the range of rows that contain checkboxes, then go to Format > Conditional formatting. Under "Format rules," choose "Custom formula is" and enter =A2=TRUE (replace A2 with the first checkbox cell in your selection). Pick a fill color or text color, then click Done.

Now every row with a checked box will highlight automatically. If you uncheck the box, the highlighting disappears. This makes it straightforward to spot completed items at a glance without filtering.

You can set up multiple conditional formatting rules — for example, one color for checked boxes and a different color for boxes checked more than a week ago (using a date formula). This turns your sheet into a visual status tracker.

Checkboxes work in shared sheets and on mobile

If you share your Google Sheet with others, they can click checkboxes just as you can. Each person sees the current state of every checkbox, and changes appear when ready for everyone viewing the sheet. This makes checkboxes useful for shared task lists or team tracking sheets where multiple people need to mark items complete.

Checkboxes also work on mobile devices. If you open a Google Sheet on your phone or tablet, you can tap a checkbox to toggle it. The checkbox responds the same way it does on a computer, and the change syncs when ready to the cloud.

Frequently Asked Questions

Can I change what a checkbox displays when it is checked?

No. A checked box always shows a checkmark, and an unchecked box always shows empty. You cannot customize the symbol or appearance. If you need different symbols, use data validation with a dropdown list instead of checkboxes.

What happens if I delete a checkbox?

The cell becomes empty. If you had a formula counting that checkbox, the count will decrease by one. You can undo the deletion by pressing Ctrl+Z (or Cmd+Z on Mac) when ready after.

Can I copy a checkbox to another cell?

Yes. Click the cell with the checkbox, copy it (Ctrl+C or Cmd+C), then click the destination cell and paste (Ctrl+V or Cmd+V). The checkbox will appear in the new cell with the same checked or unchecked state as the original.

Do checkboxes work with sorting?

Yes. You can sort your sheet by the checkbox column to move all checked boxes to the top (or bottom) and all unchecked boxes to the other end. This is useful for organizing completed and incomplete tasks without filtering.

Can I use a checkbox in a formula to trigger an action?

Yes, through conditional formatting or by using the TRUE/FALSE value in other formulas. For example, you can use an IF statement to show different text based on whether a checkbox is checked, or use COUNTIF to count checked boxes and display a progress percentage.