How to Insert a Tick Mark in Excel - 7 Methods

Method 1 – Adding a Tick Mark with ASCII Characters on Microsoft Notepad

Steps:

Open the Microsoft Notepad.
Press & hold ALT and use the keyboard number pad to enter 251.

ASCII-Notepad

Copy the tick mark and paste it into Microsoft Excel.

Method 2 – Using Keyboard Shortcuts to Insert a Tick Mark

Step 1: Cell Selection

Select the cells in which you want to insert the tick mark. Here, C5.

Step 2: Changing the Font

Change the font to Wingdings 2.

Step 3: Using the Keyboard Shortcuts

Use, the keyboard shortcuts to insert tick and cross marks as shown below.

Press SHIFT + P and ENTER to get a tick mark.
Press SHIFT + O to get a cross mark.

Wingdings can also be used to insert tick marks, checkboxes, cross marks & cross boxes.

Webdings can be used to insert tick marks & cross marks.

Method 3 – Using the Symbol Dialog Box to Add a Tick Mark

Step 1: Selecting the Cells

Here, C5 is selected.

Go to the Insert tab.

Select Symbols.

Step 2: Choosing the Font and Character Code

Click Symbols.
Change the font to Wingdings.
Enter 252 in the Character code box and click Insert.

This is the output.

Copy and paste the symbol.

You can also use the Segoe UI Symbol font to get tick marks in Excel.

In the Character code box, enter 2714.

This is the output.

Method 4 – Inserting a Tick Mark using the Excel CHAR Function

Use the CHAR function.

Step 1: Altering the Font

Select the cell in which you want to insert the tick mark. Here, C5.
Change the font to Wingdings.

Step 2: Entering the Character Codes

Enter =CHAR(252) to insert a tick mark.
Insert symbols using the CHAR function based on the codes given in the table below.

Method 5 – Using the AutoCorrect Feature to Insert a Tick Mark

Step 1: Go to the File Tab and Select Options

Click the File tab.

Click Options.

Step 02: Proofing and AutoCorrect Options

In Options, select Proofing.
Click AutoCorrect Options.
In the dialog box:
- Replace: CMARK
- With: ✔
Click Add.
Click OK.

Cells containing CMARK will be replaced with the tick mark ✔.

Note:

The autocorrect feature is case-sensitive. So, CMARK must be in caps.

Method 6 – Applying the Conditional Formatting to Insert a Tick Mark

Use the Conditional formatting.

The sample dataset showcases names and their corresponding sales.

You want to insert a tick mark for sales above $3000 and a cross mark for sales below $3000.

Step 1: Creating a Copy of the Cell

Enter =C5 in D5. If the values in column C change column D will be updated automatically.
Drag down the Fill Handle.

Step 2: Using the Conditional Formatting

Select all the cells in the column.
In the Home tab, click Conditional Formatting.
Select New Rule.

Step 03: Applying New Rule

In New Formatting Rule, click Format Style.
Choose Icon Sets.

Step 4: Choosing the Icon Sets

Select the tick mark and cross mark.
Check Show Icon Only.

Step 5: Providing the Condition

Change the exclamation mark to a cross mark by clicking the dropdown list.
Change Type from Percent to Number.
Set the Value and click OK.

Insert a tick mark for Sales exceeding $3000 and a cross mark for Sales below $3000.

Method 7 – Using VBA to Add a Tick Mark

Use a VBA code.

Step 1: Using a VBA Code

Right-click the worksheet.
Click View Code.

Step 2: Locating the Worksheet

Select the worksheet from the list.
Enter the code.

Step 3: Providing the Command

Press the two dropdowns on the right.
Click the first dropdown and change it to Worksheet.

Click on the second dropdown and change it to BeforeDoubleClick.

Step 4: Entering the VBA Code

Copy the code here and paste it.

Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal ActiveCell As Range, Cancel As Boolean)
If ActiveCell.Column = 3 And ActiveCell.Value <> Chr(214) Then
    With ActiveCell
        .Value = Chr(214) 'Required'
        .Font.Name = "Symbol" 'Required'
        .Font.FontStyle = "Regular"
        .Font.Size = 12
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
    End With
ElseIf ActiveCell.Column = 3 And ActiveCell.Value = Chr(214) Then
    ActiveCell.ClearContents
End If
End Sub