How To Add Check Mark In Google Sheets

In this tutorial, you will learn how to add check mark in google sheets.

Google Sheets has a lot of handy features that you might not be familiar with from other spreadsheets like Excel. One such feature that can be very powerful for quickly checking off tasks and toggling between two different statuses or states is the checkmark.

Inserting Check Marks

Inserting check marks is very easy. Here’s how:

Step 1

Select the cell or range you want to insert check marks into

Step 2

Open the Insert menu and choose Checkbox

Step 3

Unchecked checkboxes will be inserted

Checking and Unchecking Check Marks

Checkboxes are very easy to toggle between checked and unchecked states.

Step 1

To toggle a single checkbox state, simply click on the checkbox

Step 2

To toggle multiple checkboxes simultaneously, select the cells containing the checkboxes and hit space on your keyboard

Step 3

If any of the checkboxes in the selection are unchecked, they will all be set to checked, but if all already checked, the selection will be unchecked

Check Marks in Formulas

While checkboxes on their own are handy as a visual indication, their true power lies in the ability to reference them in formulas to easily toggle between different formula outputs. Here’s how to reference checkboxes in formulas:

Step 1

Checkboxes may look like images, but under the hood they’re actually just values so they can be used in formulas like any other values. By default, the values are TRUE and FALSE for checked and unchecked boxes respectively. You can see this in action by selecting a cell containing a checkbox and looking at the value in the formula bar

Step 2

To reference a checkbox in a formula, simply use the cell reference like you would for any other cell value. For example, if we want to display different text in a cell dependent on whether a checkbox is checked, we could use this formula: “=IF(A2, “The box is checked!”, “The box is not checked :(“)”. This formula checks the value of A2 and if it is TRUE (ie, if the box is checked) the formula returns the first string. Otherwise, the formula returns the second string


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to add check mark in google sheets. Want more? Check out all the Google Sheets Tutorials.