PlayInfoBox

Home /Utilities /How to Insert Checkboxes in Google Sheets

How to Insert Checkboxes in Google Sheets

Tap through each step to turn a plain to-do list into something you can click instead of type.

  1. Select the cell range for checkboxes

    Select the range of cells where you want to track a to-do list or completion status.

  2. Open the Insert menu and click "Checkbox"

    Click the "Insert" menu at the top, then choose "Checkbox" from the list.

  3. Confirm a checkbox appears in each selected cell

    A clickable checkbox is added to every cell you selected, all at once.

  4. Count completed items with a formula (optional)

    Checked cells hold the value TRUE and unchecked ones hold FALSE, so you can use COUNTIF to count how many are checked.

  5. Why it is worth using

    For to-do lists or attendance-style checklists, checkboxes let you mark status with a single click and even tally results automatically.

Still typing "done" and "not done" by hand?

Instead of typing status labels manually, adding checkboxes lets you mark something complete with one click, and if you connect them to a formula, you can automatically tally how many items are finished.

Also worth checking: conditional formatting

Combining checkboxes with conditional formatting lets you automatically highlight completed rows in a different color, which makes a checklist even easier to scan.

Frequently Asked Questions

Can a checkbox represent custom values instead of TRUE/FALSE?

Yes. Right-click the checkbox, choose "Data validation," and you can set custom text or number values for the checked and unchecked states.

Does a spreadsheet program like Excel have the same feature?

Excel can add checkboxes through form controls on the Developer tab, but it takes a few more steps and is not quite as simple as a single menu click.