Last Updated on November 3, 2023 by Jake Sheridan
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:
Select the cell or range you want to insert check marks into
Open the Insert menu and choose Checkbox
Unchecked checkboxes will be inserted
Checking and Unchecking Check Marks
Checkboxes are very easy to toggle between checked and unchecked states.
To toggle a single checkbox state, simply click on the checkbox
To toggle multiple checkboxes simultaneously, select the cells containing the checkboxes and hit space on your keyboard
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:
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
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.