How To Add A Checkmark In Google Sheets

Last Updated on November 3, 2023 by Jake Sheridan

In this tutorial, you will learn how to add a checkmark in Google Sheets.

If you use Google Sheets to keep track of the status of tasks or projects, checkmarks can be a useful visual tool to help users know the status of items at a glance.

Unlike checkboxes, which can be toggled from on to off by clicking on them, checkmarks are simply special characters like emoji that can be inserted into text in a cell. They have the advantage that they can’t be accidentally changed by clicking, and can be placed more easily because they can exist in the same cell as other text. They can also be formatted like other text and there are several different options to match your formatting needs.

Add a Checkmark with the CHAR function

In Google Sheets, the CHAR() function allows you to insert characters by using their unicode number. This can be done with any character, but is especially useful for characters such as checkmarks that cannot be typed on a regular keyboard. Follow these instructions to insert a checkmark using the CHAR() method:

Step 1

Select the cell you want to insert a checkmark in and type the following formula: “=CHAR(10004)

Step 2

Hit enter to finish the formula and a heavy checkmark (✔) will appear in the cell

Step 3

If you want to combine the checkmark with other text in the same cell, use an ampersand (&) to join text and the CHAR() function. Be sure to wrap any text inside quotes and start off with an equals sign to denote that the cell contains a formula. Your formula should look something like this: “=”This is text with a ” & CHAR(10004) & ” right in the middle”

Step 4

If you’d prefer a different style of checkmark, you can use one of the other checkmark character codes in the CHAR() function. Here are a the other options:

  • Regular checkmark ✓
    • =CHAR(10003)
  • Light checkmark
    • =CHAR(128504)
  • Check box with check ☑
    • =CHAR(9745)
  • Heavy check box with check
    • =CHAR(128505)
  • Heavy white checkmark ✅
    • =CHAR(9989)

Paste a Checkmark from the Internet

Another way to insert a checkmark if you don’t want to deal with creating a formula is to use copy paste checkmark characters from the internet

Step 1

The first step for this method is to find the character you want to use. Try doing an internet search for “Check mark character” in your browser of choice and you’ll find a number of hits

Step 2

Once you’ve found the character you want to use, click and drag over it to select it, then copy it by hitting Ctrl + C on Windows or Command + C on Mac

Step 3

Back in Google Sheets, double-click on the cell you want a checkmark in to enter edit mode, then click anywhere on the text to move the cursor where you want the checkmark

Step 4

Hit Ctrl + V on Windows or Command + V on Mac to paste the checkmark


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to add a checkmark in Google Sheets. Want more? Check out all the Google Sheets Tutorials.