How To Insert Tick Mark In Excel
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 the overall usability and efficiency of the Excel spreadsheets in various analytical and operational contexts. This blog will show six different methods of inserting tick marks in MS 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
- Insert the Tick Mark as Text
- Insert the Tick Mark as a Symbol
- Insert the Tick Mark Using the CHAR Function
- Insert the Tick Mark Using Copy and Paste
- Insert the Tick Mark Using Unicode Characters
- Insert the Tick Mark Using Macros
Embark on your journey in MS Excel with our guide to the best colleges, innovative programs, online courses, and career opportunities!
To insert a tick mark in Excel, you can utilize various methods, each catering to different needs and preferences. This feature is particularly useful for enhancing the clarity of data presentations, such as checklists or task completion indicators. Lets take a look -
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.
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.
If you want, you can add colours to your cell to make it pop.
Best-suited MS Excel courses for you
Learn MS Excel with these high-rated online courses
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."
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.
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.
Step 3: Select the Wingdings 2 font for the tick mark to appear.
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.
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.
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
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."
You can also check "Xmark" for the X symbol.
To apply the symbols, you can simply drag and drop the cell containing the Macros and fill in the required cells.
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 characters and 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.
Common Issues When Adding Tick Marks and How to Fix Them
Sometimes, inserting tick marks in Excel may not work as you expect them to. Here are some common problems and their simple solutions:
1. Tick Mark Doesn't Appear Correctly
Problem: After typing a character, it does not appear as a tick mark.
Solution: Check if the font is set to "Wingdings 2" or "Segoe UI Symbol", depending on the method used.
2. Formula Doesn't Show a Tick Mark
Problem: Using =CHAR(252) or =UNICHAR(10003) does not display the check symbol.
Solution: Check if the correct font (Wingdings 2 for CHAR or default font for UNICHAR) is applied to the cell.
3. Tick Mark Changes to a Different Symbol
Problem: After inserting, the tick mark turns into another character.
Solution: Ensure the correct font is selected and avoid using incompatible fonts like Calibri or Arial for tick mark characters.
4. Macro Does Not Work
Problem: Running the VBA macro does not insert a tick mark.
Solution:
- Ensure macros are enabled in Excel.
- Check for any spelling errors in the macro code.
- Make sure you have selected a cell before running the macro.
5. Copy-Paste Method Doesn't Work
Problem: The tick mark disappears after being pasted on the spreadsheet.
Solution: Try pasting the symbol using "Paste Special" → "Keep Text Only" to retain its format.
Difference Between A Tick Mark (Check Mark) and a Checkbox in Excel
Though checkmarks and checkboxes may sound the same, but are very different -
| Feature |
Check Mark |
|
| Type |
Static symbol (like text) |
Interactive object (form control) |
| Insertion |
Inserted as a character in a cell |
Added as a control above the worksheet |
| Editing |
Can be copied, deleted, and formatted like text |
Can be selected or deselected by users |
| Interaction with Excel Functions |
Does not interact with formulas |
Returns TRUE or FALSE, making it useful for formulas and conditional formatting |
| Use Case |
Ideal for marking completed tasks manually |
Used in interactive lists, forms, and dashboards |
FAQs - How to insert a tick mark in Excel?
What are the different ways to insert a tick mark in Excel?
There are several ways to insert a tick mark in Excel:
- Symbol Method: Go to the Insert tab, click on Symbol, choose "Wingdings" as the font, and select the tick mark (✔).
- Keyboard Shortcut: Change the cell font to "Wingdings" and press Alt + 0252 using the numeric keypad.
- Copy and Paste: Copy a tick mark from another document or cell and paste it into the desired location.
- Conditional Formatting: Automatically display a tick mark when a condition is met (e.g., when a cell contains "Yes").
- Checkbox Control: Use the Developer tab to add a functional checkbox that shows a tick mark when selected.
What is the easiest way to insert a tick mark in Excel for beginners?
The simplest way to insert a tick mark is to use the Symbol feature:
- Click on the cell where you want the tick mark to appear.
- Go to the Insert tab at the top of the screen.
- Click on Symbol (look for it on the right side of the menu).
- A new window will open. Choose "Wingdings" from the font dropdown.
- Find the tick mark (✔) and click on it, then click Insert.
How can I copy and paste a tick mark into multiple cells in Excel?
To copy and paste a tick mark into multiple cells, follow the below steps -
- Insert a tick mark in one cell using any method (keyboard shortcut, Symbol, or other).
- Select the cell with the tick mark and press Ctrl + C to copy it.
- Highlight the range of cells where you want to paste the tick mark.
- Press Ctrl + V to paste it.
Can I create a tick mark checkbox in Excel to check or uncheck?
Yes, you can create a tick mark checkbox that you can check or uncheck:
- Go to the Developer tab (if you don't see it, enable it in Excel Options).
- Click on Insert in the Controls group.
- Select the Checkbox (Form Control) option.
- Click on the cell where you want to place the checkbox.
This way, you will create a checkbox that can be easily checked or unchecked. Note that it does not insert a tick mark directly into the cell but provides a functional checkbox.
Top Picks & New Arrivals
