In this article:

How to Insert a Check Mark in Google Sheets (2024 Update)

December 5, 2024

How to Insert a Check Mark in Google Sheets Using the CHAR Function

You can use the CHAR function in Google Sheets to insert a checkmark: 

Step 1: Select a Cell

Click on the cell where you want the checkmark to appear. Let's say, A1.

how to insert check mark in google sheets

Step 2: Enter the CHAR Function

Type =CHAR(10003) or =CHAR(10004) into the cell or the formula bar. CHAR(10003) gives you a bold check mark, while CHAR(10004) gives you a heavier checkmark.

insert check mark in google sheets

Step 3: Press Enter

Once you press enter, the checkmark will appear in the cell.

check mark in google sheets

Alternatively, you can also use the following values:

=CHAR(10004)

=CHAR(128504)

=CHAR(9745)

=CHAR(128505)

check mark google sheets

How to Add a Check Mark in Google Sheets Using Copy and Paste

If you have a check mark symbol somewhere else, you can easily copy that symbol and then paste it directly into a cell in your Google Sheets document. Here's how to do it:

Step 1: Find a Checkmark Symbol

Use a website or a document that has a checkmark symbol you'd like to use. 

Here's a sample checkmark you can copy: ✓ ✔️ ✅

Step 2: Copy the Checkmark

Right-click on the checkmark and select "Copy," or simply use the keyboard shortcut Ctrl+C (Cmd+C on Mac).

insert check mark in google sheets

Step 3: Paste in Google Sheets

Click on the cell where you want the checkmark to appear and paste the checkmark using Ctrl+V (Cmd+V on Mac).

how to add check mark in google sheets

How to Make an Interactive Check Mark in Google Sheets

You can also use checkboxes for creating interactive to-do lists in Google Sheets. Here's how to do it: 

Step 1: Select Cells

Highlight the cells where you want checkboxes. Let's say, A1:A5.

how to add a check mark in google sheets

Step 2: Insert Checkboxes

Click on "Insert" in the top menu, then select "Checkbox" from the dropdown. This will insert interactive checkboxes that can be checked or unchecked.

insert checkmark in google sheets

Here's what the interactive checkbox looks like in Google Sheets:

how to insert a check mark in google sheets

We hope that this article has helped you and given you a better understanding of how to insert a check mark in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->