Cellwise Start free

Excel guide · 5 min read

How to insert a check mark in Excel

Quick answerGo to Insert > Symbol, choose Wingdings in the Font box, type 252 in the Character code box and click Insert. For a check mark that works in any font, choose Segoe UI Symbol and use code 2713 or 2714 instead. To show a ✓ or ✗ automatically, use a formula like =IF(C2>=B2,"✓","✗"), then count the ticks with COUNTIF.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCDE
1RepTargetActualHit?Gap
2Aisha Khan4000043750✓3750
3Ben Ortiz4000038900✗-1100
4Carla Rossi3500035000✓0
5Dan Webb3500029400✗-5600
6Eva Lind4500051200✓6200
7Femi Ade4500044100✗-900
8Grace Ho3000033600✓3600

Download this sheet as an Excel practice file (.xlsx)

A check mark or a checkbox?

A check mark is a character, like a letter. It sits in a cell, you can copy it, and formulas can produce it and count it. A checkbox is a control you click to tick and untick, which stores TRUE or FALSE. If people will tick items off by hand, you probably want a checkbox. If a formula decides whether something passed, or you just want a ✓ in a report, use the character.

Method 1: Insert > Symbol

The Symbol dialog works on every Windows keyboard and shows you the exact character before you insert it.

  1. Click the cell, or double-click into it to add the mark next to existing text.
  2. Go to Insert > Symbol (in the Symbols group).
  3. In the Font box, choose Wingdings, then type 252 in the Character code box. That selects a check mark; 254 is a ticked box two squares along.
  4. Click Insert, then Close.
  5. For a mark that doesn't depend on Wingdings, choose Segoe UI Symbol instead and type 2713 (✓) or 2714 (✔). Code 2705 gives the green emoji-style check.

Why does my Wingdings check mark turn into ü?

A Wingdings check is the letter ü drawn in a picture font. Change the font, paste it into email or export a CSV, and the ü comes back. The Segoe UI Symbol characters are real check marks and survive.

Method 2: paste or type ✓ directly

✓ and ✗ are ordinary Unicode characters. Copy them from this page and paste them into the cell or into a formula, and they display in common fonts such as Aptos, Calibri and Arial. On Windows 10 and 11, Windows key + period opens the emoji panel, which also has a symbols section with check marks.

Pick one character and stick to it. ✓ and ✔ look alike but are different characters, and COUNTIF treats them as different values.

Method 3: show ✓ or ✗ with a formula

In the sample, each rep has a monthly target and an actual figure. Column D marks who hit target, so the status updates as soon as the numbers change.

=IF(C2>=B2,"✓","✗")

Result: ✓

✓: Aisha sold 43,750 against a 40,000 target. Filled down, the column shows four ticks and three crosses. Carla gets a ✓ on exactly 35,000, because >= counts hitting the target as a pass.

How do I count the check marks?

COUNTIF with the same character you used in the formula.

=COUNTIF(D2:D8,"✓")

Result: 4

4: four of the seven reps hit target.

What share of the team hit target?

Divide the ticks by the number of reps. Format the cell as a percentage.

=COUNTIF(D2:D8,"✓")/COUNTA(D2:D8)

Result: 0.57142857143 shows as 57% with Percent format

Four out of seven reps, or 57% once the cell has a percentage format.

The Wingdings 2 trick, and why it breaks

An older trick is a formula such as =IF(C2>=B2,"P","O") with the cell font set to Wingdings 2, where a capital P draws as a check mark and a capital O as a cross. On Windows, =CHAR(252) in a Wingdings cell works the same way. It looks fine until someone changes the font, copies the column to another sheet with a different font, or exports to CSV. Then the report says P, O or ü.

It also makes counting confusing: you have to count "P", not the tick you can see. Use the real ✓ and ✗ characters instead unless you're maintaining an old file built this way.

=CHAR(252)

Result: ü

ü in Windows Excel: the character that Wingdings draws as a check mark. In any other font, that's what everyone sees.

Method 4: icon sets, no formula needed

Conditional formatting can draw a green check, yellow exclamation mark or red cross next to numbers. Column E holds each rep's gap to target (Actual minus Target), which suits an icon set: zero or more is a pass.

  1. Select E2:E8.
  2. Go to Home > Conditional Formatting > Icon Sets and pick the set with a check mark, exclamation mark and cross.
  3. With the cells still selected, go to Home > Conditional Formatting > Manage Rules, select the icon set rule and click Edit Rule.
  4. Set the green check to >= 0 with Type Number, and the yellow icon to >= -2000 with Type Number. Anything below gets the red cross.
  5. Tick Show Icon Only if you want the icons without the numbers, then click OK.

Can people choose ✓ or ✗ from a dropdown?

Yes. Select the cells, go to Data > Data Validation, choose List and type ✓,✗ in the Source box. Everyone then picks the same characters, so COUNTIF stays accurate.

Common mistakes

Mixing ✓ and ✔ in one column

They're different characters, so COUNTIF misses some. Use a dropdown list or a formula so the character is always the same.

Relying on Wingdings for a shared report

A font change shows ü, P or O instead. Use the Unicode ✓ from Segoe UI Symbol or paste it.

Using check marks where you need a tick box

If people tick items by hand, insert checkboxes; they store TRUE or FALSE you can count.

Icon set rules left on Percent

The default thresholds are percentages of the range. Switch Type to Number to set real cut-offs.

FAQ

What is the shortcut for a check mark in Excel?

There's no built-in shortcut key. Use Insert > Symbol, paste ✓, or set the font to Wingdings 2 and type a capital P. Once used, the symbol appears in the Symbol dialog's recently used row.

How do I insert a tick in Excel?

Insert > Symbol, Font Segoe UI Symbol, character code 2713, Insert. Or use Wingdings with code 252.

How do I count check marks in Excel?

Use COUNTIF with the same character, for example =COUNTIF(D2:D8,"✓"). If the marks are Wingdings, count the underlying letter instead, such as "ü" or "P".

How do I make a cell show a check mark when a condition is met?

Use IF, for example =IF(C2>=B2,"✓",""). For a picture-style icon, use Home > Conditional Formatting > Icon Sets.

How do I insert a cross mark (✗) in Excel?

Paste ✗, or use Insert > Symbol with Wingdings code 251. In a formula, write "✗" in quotation marks.

Functions used

Related guides

Updated