How To Create a Checkbox In Google Sheets

Last Updated on November 3, 2023 by Jake Sheridan

In this tutorial, you will learn how to create a checkbox in Google Sheets.

How To Create a Checkbox In Google Sheets

Checkboxes are a great way to add interactivity to your spreadsheet. They allow you to quickly select or deselect items in your list, without having to manually enter data into cells.

Checkboxes can also be used as a reference for other formulas or conditional formatting rules. For example, you might want to highlight rows that have unchecked checkboxes.

In this guide, we will show you how to create a checkbox in Google Sheets.

How To Insert a Checkbox In Google Sheets

Here’s how to insert a checkbox in Google Sheets.

Step 1

First, select the cell or cell range you want to insert a checkbox to.

In this example, our spreadsheet includes a to-do list with a column labeled Completed?. We want the user to mark a task as completed by clicking on a checkbox in this column.

Step 2

Navigate your cursor to the Insert menu found on the top of the website.

Step 3

In the Insert menu, click on the Checkbox option.

Step 4

Your range should now have checkboxes inserted. The checkbox acts as a form of data validation that prevents users from entering values other than TRUE or FALSE.

Step 5

Clicking on an empty checkbox will create a checked checkbox icon. The cell with this icon will hold a TRUE value.

Meanwhile, unchecked checkboxes will have a value of FALSE by default.

Summary

This guide should be everything you need to create a checkbox in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.