How to Insert Tick Mark in Excel (7 Useful Ways)

Get FREE Advanced Excel Exercises with Solutions!

A tick mark or checkmark is a symbol inserted into a cell to confirm something or show that something is applicable. This article shows you 7 useful ways to insert a tick mark in Excel.


How to Insert Tick Mark in Excel: 7 Useful Ways

In this section, we’ll show you 7 useful methods including VBA to insert tick marks in Excel. So, without further delay, let’s see each method one by one.

1. Adding Tick Mark with ASCII Characters on Microsoft Notepad

You can insert a checkmark using Microsoft Notepad by following these easy steps.

Steps:

  • Firstly, open Microsoft Notepad.
  • Press & hold the ALT key and use the keyboard number pad to type the number 251.

ASCII-Notepad

  • Finally, copy this tick mark and paste it into Microsoft Excel.

2. Using Keyboard Shortcuts to Insert Tick Mark

It would be great if there were keyboard shortcuts in Microsoft Excel to insert tick marks. Here, we have a dataset of daily tasks and their status (completed or not) and insert the tick mark using the keyboard shortcut.

Step 01: Cell Selection

  • At first, select the cells you want to insert the tick mark. Here, I selected cell C5.

Using Keyboard Shortcut

Step 02: Changing the Font

  • Change the font in the selected cell to Wingdings 2.

Using Keyboard Shortcut

Step 03: Using the Keyboard Shortcuts

  • Next, the keyboard shortcuts for inserting tick marks and cross marks are shown below.

How to Insert Tick Mark in Excel-Using Keyboard Shortcut

  • Now, press SHIFT + P and ENTER to get a tick mark in the selected cell.
  • Similarly, SHIFT + O will give a cross mark.

How to Insert Tick Mark in Excel-Using Keyboard Shortcut

However, you can apply a similar process with other fonts to get tick marks in Excel.

For example, the Wingdings font can also be used to insert tick marks, checkboxes, cross marks & cross boxes.

Using Keyboard Shortcut-How to Insert Tick Mark in Excel

  • Similarly, the Webdings font can be used to insert tick marks & cross marks.

Using Keyboard Shortcut-How to Insert Tick Mark in Excel

Read More: How to Insert Symbol in Excel Header


3. Using Symbol Dialog Box to Add a Tick Mark

Another way to insert a tick mark is to use Excel’s Symbol dialog box in the Insert ribbon.

Step 01: Selecting the Cells

  • I have selected cell C5 to insert the tick mark.

Using Symbol

  • Then, click the Insert tab, located at the top-left corner beside the Home tab.

Using Symbol

  • Locate the Symbols tab at the top-right corner.

Using Symbol

Step 02: Choosing Font and Character Code

  • Click the Symbols tab.
  • Then, change the font to Wingdings.
  • Type in the 252 in the Character code box and click Insert to close the dialog box.

Using Symbol-How to Insert Tick Mark in Excel

Excel shows you a tick mark in the selected cell.

Using Symbol-How to Insert Tick Mark in Excel

Now, you’re ready to copy and paste the symbol for inserting tick marks into other cells.

You can use the Segoe UI Symbol font to get tick marks in Excel. This font also allows you to insert a tick mark without the need to change the default fonts in the cell.

The inserting process is similar to that above. In the Character code box, just type in 2714.

Using Symbol-How to Insert Tick Mark in Excel

You’ll get the following tick marks.

Using Symbol-How to Insert Tick Mark in Excel

Read More: How to Insert Symbol in Excel Footer


4. Inserting a Tick Mark with Excel CHAR Function

The use of Excel functions is a quick and easy way to insert a tick mark in an empty cell. We can use the CHAR function for that.

Step 01: Altering the Font

  • To begin with, select the cell you want to insert the tick mark. I have selected cell C5.
  • Now, change the font to Wingdings.

Using CHAR Function-How to Insert Tick Mark in Excel

Step 02: Typing in the Character Codes

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

Using CHAR Function-How to Insert Tick Mark in Excel

Read More: How to Insert Sign in Excel Formula


5. Using AutoCorrect Feature to Insert a Tick Mark

You can use Excel’s built-in AutoCorrect feature to correct misspelled words, which can handle the most common errors.

Step 01: Go to the File Tab and Select Options

  • Click the File tab.

AutoCorrect Feature

  • Click on the Options tab.

AutoCorrect Feature

Step 02: Proofing and AutoCorrect Options

  • In the Options dialog box, select Proofing.
  • Next, click on the AutoCorrect Options.
  • A dialog box appears:
    • Replace: CMARK
    • With: ✔
  • Finally, click on Add and close the dialog box with OK.

AutoCorrect Feature-How to Insert Tick Mark in Excel

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

Note: 

  • The autocorrect feature is case-sensitive. So, CMARK must be in all caps.
  • All other applications in Microsoft Office are affected by this change. 

6. Applying Conditional Formatting to Insert a Tick Mark

To insert a tick mark or checkmark based on the value of a cell, you can use Conditional formatting.

To describe our next method, we have a dataset of names and their corresponding sales. Here, we want to know which employees meet the sales target of $3000.

Let’s say, we insert a tick mark for sales above $3000 and a cross mark for sales below $3000.

Using Conditional Formatting

Just follow these steps to do the task.

Step 01: Creating a Copy of the Cell

  • Enter =C5 in cell D5. This means that if the values in column C change column D will be updated automatically.
  • In the next step, use the Fill Handle tool to populate the table.

Using Conditional Formatting

Step 02: Navigating to Conditional Formatting

  • Next, select all the cells in the column.
  • In the Home tab locate and click Conditional Formatting.
  • Select the New Rule option.

Using Conditional Formatting

Step 03: Applying New Rule 

  • A dialog named New Formatting Rule appears.
  • Moreover, click the Format Style dropdown and choose Icon Sets.

Using Conditional Formatting-How to Insert Tick Mark in Excel

Step 04: Choosing Icon Sets

  • In the next step, select the tick mark and cross mark style.
  • As a note, remember to check the Show Icon Only.

Using Conditional Formatting-How to Insert Tick Mark in Excel

Step 05: Providing the Condition

  • In the final step, change the exclamation mark to a cross mark by clicking the dropdown.
  • Then, change the Type from Percent to Number.
  • Set the Value accordingly and click OK.

Using Conditional Formatting-How to Insert Tick Mark in Excel

  • After completing these steps, insert a tick mark where the Sales exceeds $3000 and a cross mark where Sales fall below $3000.

Using Conditional Formatting-How to Insert Tick Mark in Excel

In this example, we have used tick marks and cross marks. Likewise, we can also use exclamation marks.

Read More: How to Insert Rupee Symbol in Excel


7. Using VBA to Add a Tick Mark

If you often need to insert a tick mark or remove it, you may consider the VBA code shown below. This code allows you to insert a tick mark or remove it just by double-clicking the mouse. It’s simple and easy just follow along.

Step 01: Navigating to VBA Code

  • Initially, right-click on the worksheet where you want to set this function.
  • Then, click on View Code.

Using VBA Code

Step 02: Locating the Worksheet

  • A new window appears where you can select the worksheet from the list on the left side.
  • Then, on the right side write your code.

Using VBA Code

Step 03: Providing Command

  • Press the two dropdowns on the top right.
  • Now, click on the first dropdown and change it to Worksheet.

Using VBA Code-How to Insert Tick Mark in Excel

  • Similarly, click on the second dropdown and change it to BeforeDoubleClick.

Using VBA Code-How to Insert Tick Mark in Excel

Step 04: Giving VBA Code

  • Copy the code from 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
  • I have written the code to insert a tick mark on column C which is shown as Column = 3, if you wish you can change this according to your need.

Using VBA Code-How to Insert Tick Mark in Excel

  • Close the windows and return back to the worksheet.

Using VBA Code-How to Insert Tick Mark in Excel

  • Now, double-press on the cells to insert a tick mark.
  • Similarly, double press on the cells again to remove a tick mark.

Download Practice Workbook


Conclusion

In this article, I have tried to summarise a handful of simple and quick ways to insert a tick mark in Excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience.


Related Articles


<< Go Back to Insert Symbol in Excel | Excel Symbols | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo