Skip to content
AnIntent

How to Insert Checkboxes in Google Sheets (and Use Yes/No Values)

Add checkboxes in Google Sheets on desktop or Android, and on a computer make them return Yes/No instead of TRUE/FALSE.

AnIntent Editorial · · 3 min read

Person working on a laptop with a spreadsheet outdoors
Photo by Gorilla ROI Data Connector on Unsplash
In this article
  1. Pick the right route before you start
  2. Insert checkboxes on a computer
  3. Make checkboxes return Yes and No
  4. Insert checkboxes on Android
  5. Remove checkboxes
  6. Pasting into Google Docs gives TRUE/FALSE, not boxes
Share this article

To insert checkboxes in Google Sheets, select your cells and click Insert > Checkbox. If you want the boxes to write something like Yes/No into the cell instead of TRUE/FALSE, use Data > Data validation instead. Steps for both, plus Android, are below.

Pick the right route before you start

There are two ways to add a checkbox, and they are not quite the same.

  • Insert > Checkbox is the quick one. Ben Collins explains that the checkbox state is the cell's value: a checked box is TRUE, and setting the cell to TRUE checks the box.
  • Data > Data validation > Checkbox is where custom checked and unchecked values live. Ben Collins notes that only this route exposes those options. Google's own page doesn't spell that out, so if you don't see custom values somewhere, go to Data validation.

If TRUE/FALSE is fine for you (say, for a simple to-do list), use Insert. If a report, filter or colleague needs to read Yes/No or Done/Pending, use Data validation.

Insert checkboxes on a computer

These steps come from Google's desktop help page:

  1. Open a spreadsheet in Google Sheets.
  2. Select the cells you want to have checkboxes.
  3. In the top menu, click Insert, then Checkbox.

Google says checkboxes work "with charts, filters, pivot tables, and functions," and suggests them for tracking a project, taking attendance and checking off a to-do list.

To fill more rows, drag the fill handle down. How-To Geek says this copies the checkboxes, including any custom values, into the adjacent cells.

Make checkboxes return Yes and No

Google's example on the desktop help page uses Checked = "Yes" and Unchecked = "No":

  1. Select the cells.
  2. Click Data, then Data validation.
  3. Next to "Criteria," choose Checkbox.
  4. Click Use custom cell values.
  5. Next to "Checked," enter a value, such as Yes.
  6. Optional: next to "Unchecked," enter a value, such as No.
  7. Click Save.

Already added checkboxes with Insert and now want Yes/No? You don't need to start over. Select those cells and run the steps above. You can also right-click a checkbox cell and choose Data validation, per How-To Geek.

Ben Collins also points out that the validation rule can be set to reject any input other than your two values, which stops people typing stray text into the column.

These custom-value steps are for a computer only. See the Android section below.

Insert checkboxes on Android

The Android app has no Insert route on Google's page. Per Google's Android help page:

  1. Open the spreadsheet in the Google Sheets app.
  2. Select the cells.
  3. At the top right, tap More, then Data validation.
  4. Under "Criteria," tap Checkbox.

That page covers insertion only. Google gives no Android steps for Yes/No or other custom values, and none for removing checkboxes, so this guide can't offer them either. If you need Yes/No, set it up on a computer using the steps above.

This guide doesn't cover iPhone and iPad, which have their own tab on Google's help page.

Remove checkboxes

On a computer, select the checkbox cells and press Delete, as Google's desktop page describes.

Pasting into Google Docs gives TRUE/FALSE, not boxes

That's one outlet's finding, so check it in your own file. If it holds, setting custom values like Yes/No first at least makes the pasted text readable.

Common questions

What value does a checkbox store in Google Sheets?

According to Ben Collins, the checkbox state is the cell's value: a checked box is TRUE, and setting the cell to TRUE checks the box. You can change the stored values through Data > Data validation with custom cell values.

Can I change existing checkboxes to Yes/No?

Yes, on a computer. Select the checkbox cells, open Data > Data validation, choose Checkbox, click Use custom cell values, enter Yes and No, and save.

Can I set custom checkbox values on Android?

Google's Android help page gives no steps for it. It only covers inserting checkboxes through More > Data validation. Set Yes/No values on a computer instead.

a person holding a piece of paper over a laptop
How-to

Google Sheets Sparkline Charts Are Retired: What Google Confirms

Google has retired the Sparkline chart type in Sheets. Here is what Google confirms, what happens to old charts, and what to use instead.

· 2 min

Keep reading