How To Insert Tick Mark In Excel?

How To Insert Tick Mark In Excel?

4 mins readComment
Rashmi
Rashmi Karan
Manager - Content
Updated on Feb 26, 2024 16:31 IST

Tick marks serve as visual indicators, aiding in data analysis, organization, and interpretation by quickly identifying completed actions, approved items, or fulfilled criteria. They can be inserted into cells manually or generated through formulas or macros, enhancing Excel spreadsheets' overall usability and efficiency in various analytical and operational contexts. This blog will show six different methods of inserting tick marks in Excel.

How To Insert Tick Mark In Excel

What is a Tick Mark in Excel?

A "Tick Mark" in Excel refers to a visual symbol, typically a checkmark or another designated character, used to denote the completion, validation, or verification of specific tasks, conditions, or data points within an Excel worksheet. 

Table of Content

  1. Insert the Tick Mark as Text
  2. Insert the Tick Mark as a Symbol
  3. Insert the Tick Mark Using the CHAR Function
  4. Insert the Tick Mark Using Copy and Paste
  5. Insert the Tick Mark Using Unicode Characters
  6. Insert the Tick Mark Using Macros

Embark on your journey in MS Excel with our guide to the best collegesinnovative programsonline courses, and career opportunities!

Method 1: Insert the Tick Mark as Text

Step 1: Choose the cells where you want to insert the check symbols.

Step 2: Go to the "Font" section of the "Home" tab and select "Wingdings 2" from the font dropdown menu.

Insert the Tick Mark as Text

Step 3: Type a capital "P" (Caps Lock + P or Shift + P) in the selected cell. This will display the check symbol. You can increase or decrease the font size.

Insert the Tick Mark as Text

If you want, you can add colours to your cell to make it pop.

Insert the Tick Mark as Text

Method 2: Insert the Tick Mark as a Symbol

Step 1: Navigate to the "Insert" tab on the toolbar.

Step 2:  Click on the "Symbols" section, then select "Symbol."

Insert the Tick Mark as a Symbol

Step 3: In the Symbols window, ensure the "Wingdings 2" font is selected. Choose the check symbol from the options available and click "Insert." Please note that for the tick mark, Unicode Name is Wingdings: 252 and Character code is 252.

Insert the Tick Mark as a Symbol
Insert the Tick Mark as a Symbol

Method 3: Insert the Tick Mark Using the CHAR Function

Step 1: Choose the cells where you want to insert the check symbols.

Step 2: Type "=CHAR(252)" in the formula bar for a check symbol. Press Enter. This formula corresponds to the check symbol in the Wingdings 2 font.

Insert the Tick Mark Using the CHAR Function

Step 3: Select the Wingdings 2 font for the tick mark to appear.

Wingdings 2 font

Method 4: Insert the Tick Mark Using Copy and Paste

Step 1: Locate a check symbol online or from another document.

Step 2: Select the check symbol, right-click, and choose "Copy."

Step 3: Go to your Excel worksheet, right-click the cell where you want to insert the check symbol and choose "Paste."

Method 5: Insert the Tick Mark Using Unicode Characters

Step 1: Insert Unicode: In the cell where you want to insert the check symbol, type "=UNICHAR(10003)" for a checkmark symbol or "=UNICHAR(10004)" for a heavy checkmark symbol.

Step 2: Press Enter to display the check symbol after typing the formula.

Insert the Tick Mark Using Unicode Characters

Method 6: Insert the Tick Mark Using MACRO

Creating a macro will make this task much easier if you need to insert checkmarks continually. 

Step 1: You need to enable the Developer tab if you haven't already. In the Excel ribbon, you may need to enable it.

Go to File => Options => Customize Ribbon=>"Developer" and click OK.

Insert the Tick Mark Using MACRO

Step 2: Open the Visual Basic for Applications (VBA) Editor: Click on the Developer tab and "Visual Basic" to open the VBA Editor.

Go to Insert => Module to insert a new module.

Step 3: Write the Macro Code:

Sub Checkmark()
 
    Selection.FormulaR1C1 = "P"
    Selection.Font.Name = "Wingdings 2"
 
End Sub

I will also create a macro allowing me to insert the X mark. In this case, the first line inserts the letter "O", and the second line applies the Wingdings 2 font.

Sub Xmark()
 
    Selection.FormulaR1C1 = "O"
    Selection.Font.Name = "Wingdings 2"
 
End Sub

Copy code
Copy code

Insert the Tick Mark Using MACRO 2

Step 4: Close the VBA Editor window to return to Excel. Don't worry; your code is enabled.

Now, you can run the macro whenever you want to insert a checkmark. You can do this by going to the Developer tab, clicking on "Macros," selecting "InsertCheckmark," and clicking "Run."

Insert the Tick Mark Using MACROs

You can also check "Xmark" for the X symbol.

xmark

 To apply the symbols, you can simply drag and drop the cell containing the Macros and fill in the required cells.

Using macros

Why is the Tick Mark Important in Excel?

The tick mark (or checkmark) in Excel offers a concise and clear visual indicator of approvals or completed tasks within your spreadsheet. Here's why it's important:

  • Denotes completion or approval: Tick marks denote that a task is finished, a condition is met, or an item has been approved. You can comprehend the status of your data quickly.
  • Improves data organisation: By visually highlighting completed or approved entries, tick marks enhance the organisation and clarity of your spreadsheet. It makes it easier to identify specific data points within the larger dataset.
  • Compatibility with Excel functions: Tick marks integrate seamlessly with various Excel features and functions. For example, conditional formatting can automatically display a tick mark based on specific criteria, further simplifying data interpretation.
  • Ease of use: Tick marks are the simplest of the characters and are the most straightforward to insert and use. They are readily available through different methods within Excel. You do not need much technical expertise to use it.
About the Author
author-image
Rashmi Karan
Manager - Content

Rashmi is a postgraduate in Biotechnology with a flair for research-oriented work and has an experience of over 13 years in content creation and social media handling. She has a diversified writing portfolio and aim... Read Full Bio