Excel guide · 5 min read
How to insert a check mark in Excel
=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.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Rep | Target | Actual | Hit? | Gap |
| 2 | Aisha Khan | 40000 | 43750 | ✓ | 3750 |
| 3 | Ben Ortiz | 40000 | 38900 | ✗ | -1100 |
| 4 | Carla Rossi | 35000 | 35000 | ✓ | 0 |
| 5 | Dan Webb | 35000 | 29400 | ✗ | -5600 |
| 6 | Eva Lind | 45000 | 51200 | ✓ | 6200 |
| 7 | Femi Ade | 45000 | 44100 | ✗ | -900 |
| 8 | Grace Ho | 30000 | 33600 | ✓ | 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.
- Click the cell, or double-click into it to add the mark next to existing text.
- Go to Insert > Symbol (in the Symbols group).
- 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.
- Click Insert, then Close.
- 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.
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.
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.
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.
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.
- Select E2:E8.
- Go to Home > Conditional Formatting > Icon Sets and pick the set with a check mark, exclamation mark and cross.
- With the cells still selected, go to Home > Conditional Formatting > Manage Rules, select the icon set rule and click Edit Rule.
- Set the green check to >= 0 with Type Number, and the yellow icon to >= -2000 with Type Number. Anything below gets the red cross.
- 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
IFPicks a result from a testCOUNTIFCounts cells that matchCOUNTACounts non-empty cellsCHARCharacter from its code number
Related guides
- How to insert the degree symbol in Excel
- How to add a checkbox in Excel (insert tick boxes)
- How to count Yes and No answers in Excel (cells that say Yes)
- How to add bullet points in Excel
- Attendance tracker in Excel: formulas for days present and attendance %
- How to calculate backorder rate in Excel
Updated