This blog post will present a few examples of how to create checkboxes and insert tick symbols or cross marks in your Google Sheets. Whatever your history is with Google Sheets, today you may discover some new methods of doing that.
Lists help us put things in order. Stuff to buy, tasks to solve, places to visit, movies to watch, books to read, people to invite, video games to play – everything around us is practically filled with those lists. And if you use Google Sheets, chances are that it would be best to track your endeavours there.
Let's see what instruments spreadsheets offer for the task.
Standard ways to make a checkmark in Google Sheets
Example 1. Google spreadsheet tick box
The quickest way to insert a Google spreadsheet tick box is using the corresponding option from the Sheets menu directly:
- Select as many cells as you need to fill with checkboxes.
- Go to Insert > Checkbox in the Google Sheets menu:
- The entire range you selected will be stuffed with checkboxes:

Tip. Alternatively, you can fill only one cell with a checkbox, then select that cell, hover your mouse over its bottom right corner until a plus icon appears, click, hold and drag it down the column to copy over:
- Click any box once, and a tick symbol will appear:

Click once more, and the box will turn blank again.
Tip. You can tick off multiple checkboxes at once by selecting them all and hitting Space on your keyboard.
Tip. It's also possible to re-color your checkboxes. Select cells where they reside, click on the
Text color tool on the standard Google Sheets toolbar:
And pick the necessary hue:
Example 2. Data validation
Another swift method lets you not only insert checkboxes and tick symbols but also make sure nothing else is entered to those cells. You should use Data validation for that:
- Select the column that you want to fill with checkboxes.
- Go to Data > Data validation in the Google Sheets menu:
- In the next window with all the settings, find the Criteria line, and choose Checkbox from its drop-down list:

Tip. To make Google Sheets remind you not to enter anything but checkmarks to the range, pick the option called
Show warning for the
On invalid input line. Or you can decide to
Reject input whatsoever:
- As soon as you are done with the settings, hit Save. Blank checkboxes will automatically appear in the selected range.
In case you've decided to get a warning once anything else is entered, you'll see orange triangle at the upper right corner of such cells. Hover your mouse over these cells to see the warning:

Other ways to insert tick symbol and cross mark in Google Sheets
Example 1. CHAR function
The CHAR function is the first instance that will provide you with a cross mark as well as with a Google Sheets checkmark:
CHAR(table_number)
The only thing it needs is the number of the symbol from the Unicode table. Here are a few examples:
=CHAR(9744)
will return an empty checkbox (a ballot box)
=CHAR(9745)
will fill cells with a tick symbol within a checkbox (ballot box with check)
=CHAR(9746)
will give back a cross mark in the checkbox (ballot box with X)
Tip. Symbols returned by the function can also
be recolored:
There are different outlines of checks and crosses within ballot boxes available in spreadsheets:
- 11197 – ballot box with light X
- 128501 – ballot box with script X
- 128503 – ballot box with bold script X
- 128505 – ballot box with a bold check
- 10062 – negative squared cross mark
- 9989 – white heavy checkmark

Note. Cross and tick marks cannot be removed from boxes made by the CHAR formula. To get an empty checkbox, change the number of the symbol within a formula to 9744.
If you don't need those boxes and you wish to gain pure tick symbols and cross marks, the CHAR function will also help.
Below are a few codes from the Unicode table that will insert pure checkmark and cross mark in Google Sheets:
- 10007 – ballot X
- 10008 – heavy ballot X
- 128500 – ballot script X
- 128502 – ballot bold script X
- 10003 – checkmark
- 10004 – heavy checkmark
- 128504 – light checkmark

Tip. Cross mark in Google Sheets can also be represented by a multiplication X and crossing lines:

And also by various saltires:
Example 2. Ticks and cross marks as images in Google Sheets
Another not so common alternative would be to add images of Google Sheets checkmarks and cross symbols:
- Select a cell where your symbol should appear and click Insert > Image > Image in cell in the menu:
- The next large window will ask you to point to the image. Depending on where your picture is, upload it, copy and paste its web address, find it on your Drive, or search the Web directly from this window.
Once your picture is chosen, click Select.
- The picture will be fit to the cell. Now you can duplicate it to other cells by copy-pasting:
Example 3. Draw your own tick symbols and cross marks in Google Sheets
This method lets you bring your own check and cross marks to life. The option may seem far from ideal, but it is fun. :) It can really mix up your routine work in spreadsheets with a bit of creativity:
- Go to Insert > Drawing in the Google Sheets menu:
- You'll see an empty canvas and a toolbar with a few instruments:

One tool lets you draw lines, arrows, and curves. Another supplies you with different ready-made shapes. There's also a text tool and one more image tool.
- You can go straight to Shapes > Equation group, and pick and draw the multiplication sign.
Or, instead, choose the line tool, make a shape from a few lines, and edit each line individually: change their color, adjust length and width, turn them into dashed lines, and decide on their start and end points:
- Once the figure is ready, click Save and Close.
- The symbol will appear over your cells in the same size as you drew it.
Tip. To adjust it, select the newly-created shape, hover your mouse over its bottom right corner till a double-headed arrow appears, press and hold the
Shift key, then click and drag to resize the drawing to the size you need:
Example 4. Use shortcuts
As you may know, Google Sheets supports keyboard shortcuts. And it so happened that one of them is designed to insert a checkmark in your Google Sheets. But first, you need to enable those shortcuts:
- Open Keyboard shortcuts under the Help tab:

You will see a window with various key binds.
- To make shortcuts available in Sheets, click the toggle button at the very bottom of that window:
- Close the window using the cross icon at its upper right corner.
- Put the cursor into a cell that should contain a Google Sheets checkmark and press Alt+I,X (first press Alt+I, then release only the I key, and press X while holding Alt).
An empty box will appear in the cell, waiting for you to click on it to fill with a tick symbol:

Example 5. Special characters in Google Docs
If you have time to spare, you can make use of Google Docs:
- Open any Google Docs file. New or existing one – it really doesn't matter.
- Place your cursor somewhere in the document and go to Insert > Special characters in the Google Docs menu:
- In the next window, you can either:
- Search for a symbol by a keyword or a part of the word, e.g. check:
- Or make a sketch of the symbol you're looking for:
- As you can see, in both cases Docs returns symbols that match your search. Pick the one you need and click on its image:

The character will be immediately inserted to wherever your cursor is.
- Select it, copy (Ctrl+C), return to your spreadsheet and paste (Ctrl+V) the symbol into cells of interest:
As you can see, there are different ways to make the checkmark and the cross mark in Google Sheets. Which one do you prefer? Have you had problems inserting any other characters to your spreadsheets? Let me know in the comments section below! ;)
You may also be interested in
17 responses to "How to insert Google Sheets checkmarks and cross marks"
The best explanation about this topic in this part of the universe. Thank you ( ^_^)/
Thank you very much for such a lovely feedback, Humboldt! :)
Looking long for how to add a good checkmark/ cross mark. Found 10004 and 10008. thanks
Thank you for your feedback, Jackson. Good to know this blog post helped :)
How do you change the color of the checkmark or x when using the CHAR function?
Hello Ana,
With the standard 'Text color' tool on the Google Sheets toolbar.
Look for the tip in this part of the blog post, it is described there.
I would also like to know because when i add =CHAR(10062) it only shows as a green box and I cannot change the color using the font color option?
Hello Mike,
It is the 'Text color' you need to use, not the 'Font color'. Please see the comment you replied to, I provided the link to details there.
Wow!! Not just clear, but thorough. Thank you VERY much.
Thank you for the lovely feedback, James!
Hey Natalia!
Is there a way to check off multiple boxes at a time?
Thanks,
Sam
Hey Sam,
There is a way :) Select all the checkboxes you need to tick off and press Space on your keyboard :)
I've added this info into the article as well, thank you!
I would also like to know because when i add =CHAR(10062) it only shows as a green box and I cannot change the color using the font color option?
Hello Mike,
I replied to your comment above, please have a look.
This content is super helpful and it did help me to get my job done.
Wow, this is impressive. I previously used the letter "a" in a different font to get a checkmark. I had a lot of logic built into spreadsheets such as if Cell AX="a" then A, B, etc. Is there a way to reference a checkmark for logical statements in Sheets?
Hi Rich,
I believe it depends on the way you use to show checkmarks in the first place. Which way have you picked? Do you use tick boxes, CHAR formulas, or some other way?