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

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.

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.

Step 3: Press Enter

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

Alternatively, you can also use the following values:

=CHAR(10004)

=CHAR(128504)

=CHAR(9745)

=CHAR(128505)

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).

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 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.

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.

Here's what the interactive checkbox looks like 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.