Last Updated on November 3, 2023 by Jake Sheridan
In this tutorial, you will learn how to insert a checkmark symbol in Google Sheets.
How to Insert Check Mark Symbol in Google Sheets
When working in Google Sheets, you may require a check mark symbol in your document. For example, you may be creating a to-do list and you want to add a checkmark symbol to indicate that a task is completed.
In this guide, we will explain how to quickly insert a check mark symbol in Google Sheets. We’ll explain how we can use the CHAR function and the Special characters dialog box in Google Docs.
How to Add a Check Mark Character in Google Sheets
Here’s how to add a checkmark character in Google Sheets.
First, select the cell you want to insert a checkmark symbol into.
Next, simply copy and paste any of the following symbols into the textbox:
✓ ✔ ✅
If you want to use a Google Sheets formula to generate the check mark symbol, you can instead use the CHAR function. For example, entering ‘=CHAR(10003)’ will output a ‘✓’ character in your spreadsheet.
Another way to retrieve a checkmark symbol is through the Special characters option found in Google Docs.
First, open a new Google Docs document in a new tab.
In the Insert menu, select the Special characters option.
Type “check” in the provided checkbox to return a list of possible options you can use. Click on any of these options to add it to the current document.
You may now copy the symbol from Google Docs to your Google Sheets spreadsheet.
This guide should be everything you need to insert a check mark symbol in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.