How to Insert Checkboxes into Google Sheets

Sure you could just enter in "true" and "false" or "yes" and "no" into your cells, but that's not as easy to scan through like a checkbox is. It's also really easy to do and will save you time in the long-run by letting you use a single click instead of typing out a whole word.

To add in a checkbox, we'll be using the Data Validation feature. Click on the "Data" option in your menu bar and then select the option for "Data validation"

Once you see the modal, input the range you want the checkbox to appear in by entering it into the "Cell range" field and then select "Checkbox" from the drop down option for "Criteria".

Once you have that set up, click on the save option. Once saved, you should see checkboxes in the cells you selected for the "Cell range" field.

Common Use Cases

• Keeping it simple for any cell which needs a binary repsonse (e.g. Yes vs No, True vs False)
• Creating an interactive button for your users (see our guide for checkbox triggers)