How to Add a Tick Mark in Excel: Every Method Explained

Adding a tick mark (✓) in Excel is one of those tasks that seems simple until you're staring at the ribbon wondering where to start. The good news: there are at least six legitimate ways to do it, and each one suits a different workflow. Understanding why they differ helps you land on the approach that actually fits how you work.

What Counts as a "Tick Mark" in Excel?

Before diving into methods, it's worth clarifying what you're actually inserting. Excel doesn't have a dedicated "checkmark button" — instead, tick marks come from a few different sources:

• Symbol characters stored in specific fonts (Wingdings, Webdings, Segoe UI Symbol)
• Unicode characters inserted via keyboard shortcuts or character codes
• Checkboxes from Excel's Developer tools (interactive form controls)
• Conditional formatting icons that display a tick automatically based on cell values

Each of these behaves differently in your spreadsheet, and the right choice depends on whether you want a static visual mark, a clickable control, or an automated indicator.

Method 1: Insert Symbol via the Ribbon

This is the most straightforward path for occasional use.

1. Click the cell where you want the tick mark
2. Go to Insert → Symbol
3. In the Font dropdown, select Wingdings or Wingdings 2
4. Scroll to find the tick/checkmark character (✓ or ✔)
5. Click Insert, then Close

In Wingdings, the tick mark corresponds to character code 252. In Wingdings 2, look for code 82 for a lighter tick.

The limitation here: once inserted, the cell displays the symbol only if the font is set to Wingdings. If you copy the cell and paste it elsewhere with a different font, you may see a completely different character.

Method 2: Keyboard Shortcut Using Character Codes

If you need to insert tick marks repeatedly, typing a character code is faster than navigating menus.

For a standard check mark (✓):

• Hold Alt and type 0252 on the numeric keypad (with Wingdings as the cell font)

For a bold check mark (✔):

• Hold Alt and type 0254 on the numeric keypad

⚠️ This method only works with a numeric keypad, not the number row at the top of a standard keyboard. It also requires the cell font to be set to Wingdings first.

Method 3: Copy-Paste a Unicode Tick Mark

A more font-independent approach is to use the actual Unicode checkmark characters and paste them directly into Excel.

You can copy any of the characters from the table above and paste them directly into a cell. With modern Excel versions (2016 and later), these render correctly under standard fonts like Calibri or Segoe UI Symbol without needing to change the cell font.

This method is particularly useful when you want the tick mark to coexist with regular text in a cell.

Method 4: CHAR Formula

Excel's CHAR() function can generate a tick mark as a formula output — useful when you want to automate tick mark display based on logic.

=CHAR(252) 

Set the cell font to Wingdings and this formula returns a tick mark. You can combine it with an IF statement:

=IF(A1="Complete", CHAR(252), "") 

This approach keeps your spreadsheet dynamic. When the value in A1 changes, the tick mark appears or disappears automatically.

Method 5: Checkboxes via the Developer Tab

If you need an interactive checkbox — one a user can click to toggle — that's a different tool entirely: Form Controls or ActiveX Controls from the Developer tab.

To enable the Developer tab:

• Go to File → Options → Customize Ribbon
• Check Developer in the right-hand column

To insert a checkbox:

1. Click Developer → Insert → Form Controls → Checkbox
2. Draw it onto the sheet
3. Right-click and select Format Control to link it to a cell

When linked to a cell, the checkbox outputs TRUE (checked) or FALSE (unchecked), which you can then use in formulas. This is meaningfully different from inserting a symbol — it creates a functional control, not just a visual character.

Method 6: Conditional Formatting with Icon Sets

For data-driven tick marks that appear automatically, Icon Sets in conditional formatting can display tick marks without inserting anything manually.

1. Select your data range
2. Go to Home → Conditional Formatting → Icon Sets
3. Choose a set that includes a checkmark (look under the "Marks" section)

✅ This works well for dashboards or trackers where "pass/fail" or "complete/incomplete" status needs to be visualized at scale. The trade-off is that you're working within Excel's icon display logic — the tick only appears when values meet specific thresholds you define.

The Variables That Change What Works Best

The six methods above aren't interchangeable. A few factors push users toward different choices:

• Static vs. dynamic needs — Are you marking something once, or does the tick need to appear/disappear automatically?
• Formula integration — Do you need the tick mark to participate in IF, COUNTIF, or other logic?
• Interactivity — Do other users need to click a checkbox in a shared workbook?
• Font consistency — Is your spreadsheet shared across teams where font settings might vary?
• Excel version — Older versions of Excel handle Unicode characters less reliably than newer ones

A tick mark in a personal task list has very different requirements from a tick mark in a shared project tracker used by a dozen people across different devices.