How to Insert a Check Mark Symbol [Tickmark] in Excel

Last week while traveling...

...I met a person who asked me a smart question.

He was quietly working on his laptop...

...and suddenly asked me this:

“Hey, do you know how to insert a check mark symbol in Excel?”

And then I figured out that he had a list of customers...

...and he wanted to add a check mark for every customer to whom he met.

Well, I showed him a simple way and he was happy with that.

But eventually today morning, I thought maybe there is more than one way to insert a checkmark in a cell.

And luckily, I found that there several for this. 

So today in this post, I’d like to show you how to add a check mark symbol in Excel using 10 different methods...

...and all those situations where we need to use these methods.

Apart from these 10 methods...

...I have also mentioned how you can format a checkmark + count checkmarks from a cell of range.

? Quick Notes

When YOU should be using a Check Mark in Excel

The Best 11 Methods which YOU can use to Add a CHECK MARK Symbol in a Cell in Excel

Below are the ways to insert a check mark in Excel. You just need to use the method which you think is convenient for you.

And here are some of the things which you need to know about using a checkmark in Excel.

The Fastest Way to Add a Checkmark is the Keyboard Shortcut ?

Nothing is faster than a keyboard shortcut, and to add a check mark symbol all you need a keyboard shortcut.

The only thing you need to take care: the cell where you want to add the symbol must have wingding as font style.

And below is the simple shortcut you can use insert a check mark in a cell.

insert check mark in excel with shortcut key

If you are using Windows, then:

  • Select the cell where you want to add it.
  • Use Alt + 0 2 5 2 (make sure to hold the Alt key and then type “0252” with your numeric keypad).
    window keyboard shortcut to insert a checkmark in excel

And, if you are using a Mac:

  • Just select the cell where you want to add it.
  • Use Option Key + 0 2 5 2 (make sure to hold the key and then type “0252” with your numeric keypad).
    mac keyboard shortcut to insert a checkmark in excel

Simply Copy-Paste a Checkmark Symbol in a Cell

If you usually don’t use a checkmark then you can copy-paste is from somewhere and insert in a cell.

In fact, it’s a big time saver as well.

Because you are not using any formula, shortcut or VBA here (copy paste a check mark from here ✓).

Or you can also copy it by searching it on google.

The best thing about the copy-paste method is there is no need to change the font style.

Insert a Check Mark Directly from Symbols Options

There are a lot of symbols in Excel which you can insert from Symbols option, and the check mark is one of them.

From Symbols, inserting a symbol in a cell is no brainer, you just need to follow the below steps:

  1. First, you need to select the cell where you want to add it.
  2. After that, go to Insert Tab ➜ Symbols ➜ Symbol.
    go to insert tab and open symbol dialog box
  3. Once you click on the symbol button, you will get a window.
  4. Now from this window, select “Winding” from font drop down.
  5. And in the character code box, enter “252”.
  6. By doing this, it will instantly select the check mark symbol and you don’t need to locate it.
    go to insert tab and open symbol dialog box
  7. In the end, click on “Insert” and close the window.

As this is a “Winding” font, and the moment you insert it in a cell Excel changes the cell font style to “Winding”.

Apart from a simple tick mark, there is also a boxed check mark is there (254) which you can use.

If you want to insert a tick mark symbol in a cell where you already have text, then you need to edit that cell (use F2).

⚠️ The above method is bit long, but you don’t have to use any formula or a shortcut key and once you add it into a cell you can a copy paste it.

Create an AUTOCORRECT to Convent it to a Check Mark

After the keyboard shortcut, the fast way is to add checkmark/tick mark symbol in the cell, it’s by creating AUTOCORRECT.

In Excel, there is an option which corrects misspelled words. So, when you insert “clear” it converts it into “Clear” and that’s the right words.

Now thing is, it gives you the option to create an AUTOCORRECT for a word...

...and you define a word for which you want Excel to convert it into a check mark.

Below are the steps you need to use:

  1. First, go to the File Tab and open the Excel options.
    open options from file tab to add checkmark in excel
  2. After that, navigate to “Proofing” and open “AutoCorrect” Option.
    open autocorrect option to create checkmark in a cell
  3. Now in this dialog box, in the “Replace” box, enter the word you want to type for which Excel will return a check mark symbol (here I’m using CMRK).
  4. Then, in the “With:” enter the check mark which you can copy from here.
    add a replacement in autocorrect option insert a checkmark in excel
  5. In the end, click OK.

From now, every time when you enter CHMRK Excel will convert it into an actual check mark.

There are a few things you need to take care which you this auto corrected check mark.

  • When you create an auto correct you need to remember that it’s a case sensitive. So, the best way can be to create two different auto corrects using the same  word.
  • The word you have specified to be corrected as a check mark will only get converted if you enter it as a separate word. Let’s say if you enter Task1CHMRK it will not get converted as Task1. So, the text must be Task1 CHMRK.
  • The AUTO correct option applied to all the Office Apps. So, when you create a autocorrect for a check mark you can use it in other apps as well.

Use a Macro to Quickly Insert a Checkmark in a Cell + Double Click Method

If you want to save your efforts and time, then you can use a VBA code to insert a check mark.

Here is the code:

Sub addCheckMark()

Dim rng As Range

For Each rng In Selection

With rng

.Font.Name = "Wingdings"

.Value = "ü"

End With

Next rng

End Sub

…here’s how this code work.

When you select a cell or a range of cell and run this code it loops through each of the cells and changes its font style to "Wingdings" and enter value “ü” in it.

Add Macro Code to QAT

Double-Click Method using VBA ?

Let’s say you have a to-do list where you want to insert a checkmark just by double clicking on the cell.

Well, you can make this happen by using VBA’s double-click event.

Here I’m using the same code below code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Target.Column = 2 Then

Cancel = True

Target.Font.Name = "Wingdings"

If Target.Value = "" Then

Target.Value = "ü"

Else

Target.Value = ""

End If

End If

End Sub

…how to use this code

  1. First, you need to open the VBA code window of the worksheet and for this right-click on the worksheet tab and select the “View Code”.
    open code window to add code in the worksheet to add checkmark in a cell by double click
  2. After that, paste this code there and close the VB editor.
  3. Now, come back to the worksheet and double click on any cell in column B to insert a checkmark.

…how this code works

When you double click on any cell this code triggers and check if the cell you on which you have double clicked is in column 2 or not…

And, if that cell is from the column 2 change it’s font style to “Winding”…

…after that it checks if that cell is blank or not, if the cell is blank then enter the value “ü” in it which converts into a checkmark…

…as it has already applied the font style to the cell.

And if a cell has a check mark already then you remove it by double clicking.

Add Green Check Mark with Conditional Formatting

If you want to be more awesome and creative, you can use conditional formatting for a check mark.

Let’s say, below is the list of the tasks you have where you have a task in the one column and a second where you want to insert a tick mark is task is completed.

Below are the steps you need to follow:

  1. First, select the target cell or range of cells where you want to apply the conditional formatting.
  2. After that go to Home Tab ➜ Styles ➜ Conditional Formatting ➜ Icon Sets ➜ More Rules.
  3. Now in the rule window, do the following things:use conditional formatting to insert a green check mark in cell by typing 1
    1. Select the green checkmark style from the icon set.
    2. Tick mark “Show icon only” option.
    3. Enter “1” as a value for green check mark and select number from the type.

  4. In the end, click OK.

Once you do that, enter 1 in the cell where you need to enter a check mark and because of conditional formatting, you will get a green check mark there…

…without the actual cell value.

Create a Dropdown to Insert a Checkmark

If you don’t want copy-paste checkmark and don’t even want to add formula, then the better way can be to create a drop down list using data validation…

…and insert a checkmark using that drop down.

Before you start make sure to copy a checkmark ✓ symbol before you start and then select the cell where you want to create this drop down.

And after that follow these simple steps to create a drop down for adding a checkmark:

  1. First, go to Data tab ➨ Data Tools ➨ Data Validation ➨ Data Validation.
    open the data validation dialog box to create a drop down for inserting a checkmark
  2. Now from the dialog box, select the “List” in the drop down.
  3. After that, paste the copied check mark in the “Source”.
    select list and paste the checkmark symbol
  4. In the end, click OK.

Use CHAR Function to Create a Formula for the Checkmark Symbol

Not all the time you need to enter a check mark by yourself. You can automate it by using a formula as well.

Let’s say you want to insert a checkmark based on a value in another cell.

Like below where when you enter value done in column C the formula will return a tick mark in column A.

And, the formula which I have used here is

To create a formula like this we need to use CHAR function.

CHAR(number)

Quick INTRO: CHAR Function

CHAR function returns the character based on the ASCII value and Macintosh character set.

Syntax:

CHAR(number)

…you can learn more about it from here.

...how does it work

As I say CHAR is a function to convert a number into an ANSI character (Windows) and Macintosh character set (Mac).

So, when you enter 252 which is the ANSI code for a check mark, the formula returns a checkmark.

Simply Create a Graphical Checkmark using Draw Option

If you are using OFFICE 365 like me, you can see there is a new tab with the name of “Draw” there on your ribbon.

Now the thing is:

In this tab have the option to draw directly into your spreadsheet. There are different pens and markers which you can use.

And you can simply draw a simple checkmark…

…and Excel will insert it as a graphic.

The best thing is when you share it with other it, even if they are using a different version of Excel, it shows as a graphic.

There’s also a button to erase as well.

You must go ahead and explore this “Draw” tab there is a lot of cool things which you can do with it.

Use Checkbox as a Checkmark in a Cell

You can also use a checkbox as a checkmark. But there is a slight difference between both:

  1. A checkbox is an object which is like a layer which placed above the worksheet, but a checkmark is a symbol which you can insert inside a cell.
  2. A checkbox is a sperate object and if you delete content from a cell checkbox won’t be deleted with it. On the other hand, a checkmark is a symbol which you inside a cell.

How to Insert a Checkmark if I’m using Excel’s Online App

If you use Excel’s online App then you need to follow a different way to put a checkmark in a cell.

The thing is, you can use the shortcut key but there is no “Winding” font there, so you can't convert it into a checkmark.

Even if you use CHAR function it won’t be converted into a checkmark.

But…But…But…

I’ve found a simple way by installing an app into the Online Excel for symbols to insert checkmark.

Below are the steps you need to follow:

  1. First, go to the Insert Tab ➜ Add-Ins and then click on the office Add-Ins.
    open-add-ins-to-insert-an-app-to-add-checkmark-in-online-excel
  2. Now, in the add-ins window, click on the store and search for the “Symbol”.
  3. Here you’ll have an add-in with the name of “Symbol and Characters”, click on the add button to install it.
    search-for-the-symbol-app-from-the-search-bar
  4. After that, go to the Add-Ins tab and open the add-in which you have just installed.
  5. At this point, you have a side pane where you can search for the checkmark symbol and double click on it to insert it into the cell.
    search-for-the-checkmark-from-the-searchbar-and-click-on-it-to-insert-it

Yes, that’s it.

Some of the IMPORTANT Points YOU need to learn

Here are a few points which you need to learn about using checkmark.

1. Formatting a Checkmark

Formatting a check mark can be required sometimes especially when you are working with data where you are validating something.

Below are the things which you can do with a checkmark:

  • Make it bold and italic.
  • Change its color.
  • Increase and decrease font size.
  • Apply an underline.

2. Deleting a Checkmark

Deleting a check mark is simple and all you need to do is select the cell where you have it and press the delete key.

Or, if you have text along with a checkmark in a cell then you can use any of the below methods.

3. Count Checkmarks

=COUNTIF(G3:G9,CHAR(252))

In the End,

you must read these tutorials next...

About the Author

Puneet Gogia

He is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

LinkedIn - YouTube

Content Protection by DMCA.com

22 thoughts

Leave a Comment

Your email address will not be published.

  1. Hi.
    I’m locating the tick easily enough, but as soon as I leave the cell it changes to a rectangle shape. I can’t find a solution anywhere. HELP!

  2. You can also use custom number formatting

    ü;;û; will convert a one to a tick and a 0 to a cross, although you still need to convert the font to Wingdings.

  3. Hi,

    Thanks for sharing such a valuable information with us.

    I would like to ask that whether there is any formula which can convert numerical values into text.eg. Rs.2050=Two thousand and fifty rupees.

    Thanks,
    Jayesh
    M-9898509009

  4. Different VBA code that I use, copy all of the below and paste it into the VBA editor in the Worksheet’s object:

    ‘Select a range of cells and give it the named range: Checkboxes
    ‘Change the font in that named range to Webdings
    ‘Place this code in the worksheet object, not a module.

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Intersect(Target, Range(“CheckBoxes”)) Is Nothing Then
    If Target.Value = “a” Then
    Target.Value = “”
    Else
    Target.Value = “a”
    End If
    Cancel = True
    End If

    End Sub

    ‘Double-clicking any cell in the named range “Checkboxes” will toggle a checkmark to appear or disappear.

  5. Thank you Puneet,

    Another one would be from the Developer tab–Controls–Insert–Form Controls–Check Box.
    They’re a little bit trickier to center in the cell, but they work flawlessly.

    Hope this helps!