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

Adding a tick symbol (✓ or ✔) in Excel sounds simple, but there are actually several distinct ways to do it — and the right approach depends on what you're building, how the cell data will be used, and whether you need the symbol to be functional or purely visual. Each method behaves differently when it comes to sorting, filtering, formulas, and formatting.

What Counts as a "Tick Symbol" in Excel?

Before diving in, it helps to know that Excel treats tick symbols in two fundamentally different ways:

• A visual character — a checkmark glyph inserted as text, either through a special font, a Unicode character, or copy-paste. It looks like a tick but is just a display character.
• A functional checkbox — an interactive element you can click to toggle on or off, typically used in forms or dashboards.

These are not interchangeable. Which one you need shapes which method makes sense.

Method 1: Insert a Tick Using the Symbol Menu

This is the most straightforward approach for one-off use.

1. Click the cell where you want the tick.
2. Go to Insert → Symbol.
3. In the Font dropdown, select Wingdings or Wingdings 2.
4. Scroll to find the checkmark characters — in Wingdings, the tick is character code 252; a boxed tick is 254.
5. Click Insert, then Close.

The result is a text character styled with the Wingdings font. It will only render correctly in that cell if the font stays set to Wingdings. If you change the cell font, the symbol may turn into a random letter.

Method 2: Use a Keyboard Shortcut with Wingdings Font

If you need to enter ticks quickly across multiple cells:

1. Format the target cells with the Wingdings font first (Home → Font dropdown → type "Wingdings").
2. Type the letter ü (Alt+0252 on Windows using the numeric keypad) — this renders as a tick in Wingdings.
3. Alternatively, type the letter þ (Alt+0254) for a boxed checkmark.

This is faster for bulk entry but carries the same font-dependency caveat as Method 1. Anyone receiving the file needs Wingdings installed (standard on Windows and macOS, so rarely a problem).

Method 3: Insert a Unicode Checkmark Character ✓

Unicode checkmarks exist independently of font choice, which makes them more portable.

• ✓ = U+2713 (Check Mark)
• ✔ = U+2714 (Heavy Check Mark)

On Windows: Hold Alt and type the Unicode code point using the numeric keypad — though this requires enabling Unicode input, which isn't default behavior. An easier route: copy the character directly from Character Map (search "Character Map" in Start).

On Mac: Press Control + Command + Space to open the Character Viewer, search "check mark," and double-click to insert.

In any version of Excel: You can use the Symbol dialog (Insert → Symbol) and switch the from dropdown to Unicode (hex), then type 2713 or 2714 in the Character Code box.

Unicode ticks are plain text and will survive font changes — they render in any standard font that includes the character (most modern fonts do). ✅

Method 4: Use a Formula to Return a Tick

If your tick symbols need to respond to data — for example, appearing automatically when a value in another cell meets a condition — formulas are the right tool.

Use a formula like:

=IF(A2="Complete", "✔", "✗") 

Or, using Wingdings font on the cell:

=IF(A2>100, CHAR(252), CHAR(251)) 

CHAR(252) returns the Wingdings tick; CHAR(251) returns an X. The cell must be formatted in Wingdings for this to display correctly.

The formula approach integrates tick symbols with your data logic — useful in status columns, dashboards, or conditional reporting.

Method 5: Use Conditional Formatting with Icon Sets

For visual indicators without inserting any character at all:

1. Select your data range.
2. Go to Home → Conditional Formatting → Icon Sets.
3. Choose a set that includes a green checkmark (found under the "Directional" or "Indicators" categories).

This overlays icons onto cells based on numeric thresholds. It doesn't insert a tick character — the icon is a formatting layer. You can't reference or count it with a formula, but it creates clean visual dashboards quickly.

Method 6: Insert an Interactive Checkbox (Form Control)

This is the functional checkbox — an actual clickable element:

1. Go to Developer → Insert → Form Controls → Check Box. (If Developer isn't visible: File → Options → Customize Ribbon → enable Developer.)
2. Draw the checkbox onto the spreadsheet.
3. Right-click → Format Control → link it to a cell so it outputs TRUE/FALSE when clicked.

This is genuinely interactive and suitable for task lists, surveys, or input forms. However, it's an object floating over the sheet — not a cell value — which creates complications with sorting rows or copying ranges.

Key Differences at a Glance

The Variables That Determine Which Method Fits

A few factors meaningfully shift which approach works best:

• Will the tick respond to data? If yes, a formula is necessary. If it's a static label, character insertion is simpler.
• Does the file need to be shared or opened in Google Sheets / other tools? Wingdings-dependent ticks may not render correctly outside Excel. Unicode characters and icon sets travel better.
• Is this a form someone fills in? Form control checkboxes serve that use case in a way static symbols can't.
• Are you counting or filtering by tick status? Form control outputs (TRUE/FALSE) and formula-based approaches can be counted with COUNTIF. A Wingdings character sitting in a cell can too — but only if you know what character code to match.

The method that feels simplest in isolation often creates friction later when the spreadsheet evolves, gets filtered, or changes hands. What works cleanly in a personal checklist may not hold up in a shared reporting workbook — and that depends entirely on how your file is structured and used.