Tick Mark in Excel: Every Method to Insert a Check Mark (5 Ways)

Home » pub » Tutorials » Tick Mark in Excel: Every Method to Insert a Check Mark (5 Ways)

Excel has no dedicated tick-mark button, but it offers five distinct ways to insert one. The Symbol dialog works for one-off insertions with no setup. Alt+0252 in Wingdings is the fastest keyboard-only method. Shift+P in Wingdings 2 is even quicker once the column is pre-formatted. The CHAR function brings ticks inside formulas — combine it with IF to show a tick when a task is done and a cross when it isn’t. Unicode ✓ and ✔ paste directly into any font without changing a thing. This guide covers all five methods, then shows how to count ticks with COUNTIF, restrict a column to ticks and crosses only using data validation, and color entire rows green or red with conditional formatting

A tick mark ✓ in Excel is more than a visual decoration. It signals completion, approval, or correctness at a glance. Project checklists, quality control forms, task trackers, and financial sign-off sheets all rely on tick marks to communicate status without ambiguity. Excel has no dedicated tick-mark button, but it offers five distinct insertion methods — ranging from a three-click symbol picker to a single formula. This guide covers every method, with examples showing how to make ticks conditional, countable, and interactive.

Specifically, you will learn how to insert a tick with the Symbol dialog, Alt codes, keyboard shortcuts, the CHAR function, and Unicode characters. Additionally, later examples show how to build a conditional tick using IF, create a self-counting checklist, and use data validation to restrict a column to ticks and crosses only. No prior knowledge of VBA or formulas is required for any of the insertion methods.

Quick reference — tick mark character codes: In Wingdings font: ✓ = character 252 (=CHAR(252)), ☒ ballot box with check = character 254. In Wingdings 2 font: tick = Shift+P (character 80). In standard fonts (Segoe UI, Calibri, Arial): Unicode ✓ (U+2713) and ✔ (U+2714) insert directly without a font change.

What Tick Mark Symbols Are Available in Excel?

Excel supports two families of tick marks. The first family lives in the Wingdings and Wingdings 2 specialty fonts — these are the classic symbols that Excel tutorials have used for decades. The second family uses Unicode standard characters that display correctly in any modern font without a font change. Choosing between them depends on whether you need formula-based insertion or direct copy-paste simplicity.

Symbol	Name	Font / Method	CHAR code	Unicode
✓	Check mark	Wingdings or any modern font	=CHAR(252) in Wingdings	U+2713
✔	Heavy check mark	Any modern font	—	U+2714
☐	Ballot box (empty)	Any modern font	=CHAR(253) in Wingdings	U+2610
☑	Ballot box with check	Wingdings or Unicode	=CHAR(254) in Wingdings	U+2611
✕	Multiplication X (cross)	Any modern font	=CHAR(251) in Wingdings	U+2715
✖	Heavy ballot X	Any modern font	=CHAR(84) in Wingdings 2	U+2716

What Methods Insert a Tick Mark in Excel?

Five methods exist for inserting tick marks in Excel. Each suits a different situation. The Symbol dialog is best for one-off insertions. Alt codes are fastest for keyboard-only users. The CHAR function is essential when the tick must appear inside a formula. Unicode copy-paste works in any font. Data validation is the right choice when multiple users need to enter ticks consistently.

Method	Setup needed?	Works in formulas?	Best for
Symbol dialog	None	No	One-off insertions, beginners
Alt code (Alt+0252)	Num Lock on, Wingdings font	No	Fast keyboard-only entry in Wingdings cells
Keyboard shortcut (Shift+P)	Wingdings 2 font on the cell	No	Fastest method in a pre-formatted column
=CHAR(252)	Wingdings font on the cell	Yes — use in IF formulas	Conditional and automated ticks via formulas
Unicode ✓ copy-paste	None	Yes (as text)	Any font, shared workbooks, no font dependency

Examples 1–4: Inserting Tick Marks

Symbol dialog — the click-through method for any Excel version

The Symbol dialog is the most reliable method for inserting a tick mark in any Excel version. It requires no memorised codes and no font knowledge. You simply navigate to the symbol, select it, and click Insert. The tick appears in the selected cell using the Wingdings font, which Excel applies automatically when you choose it from the dialog.

Steps to insert a tick mark via the Symbol dialog: 1. Click the cell where you want the tick mark to appear. 2. Go to Insert tab → Symbols group → click Symbol. 3. In the Font dropdown, select Wingdings. 4. Scroll to near the end of the character grid — the tick marks appear in the last two rows, or type 252 in the Character Code box. 5. Select the tick mark (✓) and click Insert. 6. Click Close. The cell now contains the tick character in Wingdings font. You can copy this cell and paste it wherever you need the same tick. Character codes to remember in Wingdings: 252 → ✓ (plain check mark) 251 → ✗ (ballot X) 253 → ☒ (ballot box with X) 254 → ☑ (ballot box with check)

Speed tip — type the character code directly: In the Symbol dialog, clicking through hundreds of characters is slow. Instead, type 252 directly into the Character Code field at the bottom of the dialog. Excel jumps to that character instantly. This works for any code in the Wingdings table and saves 30 seconds per insertion compared to scrolling.

Alt codes and keyboard shortcuts — fastest entry methods

Alt codes let you insert symbols by holding Alt and typing a number on the numeric keypad. For tick marks in Wingdings, the key combination is Alt + 0252. The cell must already be formatted with the Wingdings font before you type the Alt code — otherwise the code produces a number or a different character. Format the column with Wingdings first, then use the Alt code for rapid entry.

Alt code

Symbol (Wingdings)

Shortcut (Wingdings 2)

Name

Alt + 0252

✓

Shift + P

Check mark

Alt + 0254

☑

Shift + R

Ballot box with check

Alt + 0251

✗

Shift + O

Ballot X (cross)

Alt + 0253

☒

Shift + Q

Ballot box with X

Alt code method — requires Num Lock on and a numeric keypad: 1. Select the cell. Format it as Wingdings (Home → Font dropdown). 2. Hold Alt, type 0252 on the numeric keypad, then release Alt. → ✓ appears in the cell. Keyboard shortcut method — Wingdings 2 font: 1. Select the cell. Format it as Wingdings 2. 2. Press Shift + P. → ✓ appears in the cell. Shift + R gives a boxed tick ☑, Shift + O gives a script X cross. Format an entire column at once: Click the column header (e.g. column B) to select the whole column. Apply Wingdings 2 font from the Font dropdown. Now every cell in column B converts Shift+P to a tick mark automatically.

CHAR function — insert a tick mark directly in a formula

The CHAR function converts a character code into its corresponding symbol. In Wingdings, CHAR(252) returns the tick mark character. This method is essential when you need the tick to appear as part of a formula result rather than as manually entered text. Specifically, combining CHAR(252) with IF creates a conditional tick that appears or disappears based on logic in another cell.

The cell containing the CHAR formula must be formatted as Wingdings font. Format the cell first, then enter the formula. Plain tick mark — always shows the tick in a Wingdings-formatted cell: =CHAR(252) → ✓ (check mark in Wingdings) Ballot box with check mark: =CHAR(254) → ☑ (boxed check mark) Cross / ballot X: =CHAR(251) → ✗ Conditional tick — show tick if A2 = "Done", cross if not: Format column B as Wingdings before entering this formula in B2. =IF(A2="Done", =CHAR(252), =CHAR(251)) → ✓ if A2 = "Done", ✗ otherwise Conditional tick with blank for empty rows: Avoids showing a cross when the task has not been entered yet. =IF(A2="", "", IF(A2="Done", =CHAR(252), =CHAR(251))) → Blank for empty rows, ✓ for Done, ✗ for anything else

Unicode tick marks — no font change required

Unicode tick marks are the simplest approach for modern Excel. Characters ✓ (U+2713) and ✔ (U+2714) display correctly in any modern font — Calibri, Arial, Segoe UI, and all default Excel fonts support them. Consequently, Unicode ticks work in shared workbooks and exported PDFs without font embedding concerns. Copy the character and paste it wherever needed.

Unicode tick marks — copy and paste directly into any cell: No font change needed. Works in any modern Excel version. ✓ U+2713 Light check mark (copy this character) ✔ U+2714 Heavy check mark (bold version) ☐ U+2610 Ballot box (empty) ☑ U+2611 Ballot box with check ✕ U+2715 Multiplication X (used as a cross / no) ✖ U+2716 Heavy ballot X Insert via keyboard shortcut (Windows): 1. Place cursor in the cell. 2. Hold Alt and type + on the numeric keypad, then type the Unicode code point. Example: Alt + 2713 (release Alt) inserts ✓. Insert via Find & Replace for bulk replacement: Ctrl+H → Find What: "Done" → Replace With: ✓ (paste the Unicode character). Replace All converts every "Done" cell to a tick mark in one step. Use in a formula with Unicode character: =IF(A2="Done","✓","✗") ← works in any font, no Wingdings needed → ✓ for Done, ✗ otherwise

Unicode vs Wingdings — which is better? Use Unicode tick marks (✓ ✔) for any workbook that will be shared, exported to PDF, or opened on a Mac. Use Wingdings only when you need the CHAR function for conditional formulas in an environment where you can control the font. Unicode characters are more portable and do not require the Wingdings font to be installed on the recipient's computer.

Examples 5–8: Practical Tick Mark Applications

Checklists, Counting, Validation, and Colour Coding

Conditional tick — automatic tick mark based on a value in another cell

A conditional tick mark updates automatically as data in a linked cell changes. This pattern is the foundation of automated checklists and status dashboards. When a task is marked as complete in column A, the tick appears in column B without any manual entry. The formula also handles percentage thresholds, date comparisons, and numeric conditions with equal ease.

Task (A)

Status (B)

Progress (C)

Tick (D)

Write report

Done

100%

✓

Review draft

In progress

60%

✗

Submit invoice

Done

100%

✓

Column D is formatted as Wingdings. B2 = task status text. Tick if status = "Done", cross otherwise: =IF(B2="Done", =CHAR(252), =CHAR(251)) Tick based on percentage threshold (C2 = progress %): Tick when 100% complete, cross for anything below. =IF(C2=1, =CHAR(252), =CHAR(251)) Tick using Unicode — no Wingdings font required: =IF(B2="Done","✓","✗") Three-way conditional — tick, dash, or cross: Tick = Done, dash = In Progress, cross = Not Started. =IF(B2="Done", =CHAR(252), IF(B2="In Progress", "—", =CHAR(251))) → ✓ for Done, — for In Progress, ✗ for Not Started

Counting tick marks — COUNTIF to total completed items

Once tick marks are in a column, counting them tells you how many tasks are complete. COUNTIF works for both manually entered ticks and formula-generated ones. However, the approach differs depending on whether the ticks are Wingdings CHAR(252) characters or Unicode ✓ characters. The CHAR version requires matching the exact character; the Unicode version matches the character directly as text.

B2:B20 = tick mark column. Each cell contains either ✓ or ✗. The font of B2:B20 is Wingdings (CHAR method used to insert ticks). Count ticks (Wingdings CHAR method) — match the CHAR character: CHAR(252) produces the tick character for matching. =COUNTIF(B2:B20, =CHAR(252)) → Number of cells containing a tick mark Count ticks (Unicode method) — match the Unicode character directly: Paste the ✓ character inside the quotes. =COUNTIF(B2:B20, "✓") → Number of cells containing the Unicode tick mark Count crosses (Wingdings ballot X): CHAR(251) produces the cross character for matching. =COUNTIF(B2:B20, =CHAR(251)) → Number of cells containing a cross mark Completion percentage — ticks divided by total items: C2 = COUNTIF result (number of ticks). 19 = total number of rows. Format the result cell as Percentage. C2 / 19 → e.g. 0.737 displayed as 73.7% complete Dashboard summary label — "12 of 19 tasks complete": Combines the count with text for a single readable KPI cell. =COUNTIF(B2:B20, =CHAR(252)) & " of 19 tasks complete" → "12 of 19 tasks complete"

Data validation — restrict a column to tick or cross only

Data validation restricts what users can enter in a cell. For a tick-and-cross column, validation ensures that only the tick character or the cross character is accepted — preventing accidental text entries like "yes" or "complete" that would break the COUNTIF formulas. This is particularly useful in shared workbooks where multiple people enter data.

Method 1: Dropdown list with tick and cross as options. The dropdown shows the two characters. Users click one to select it. 1. Select the column range (e.g. B2:B50). 2. Data → Data Validation → Allow: List. 3. In the Source field, type: ✓,✗ (paste the Unicode tick and cross separated by a comma) 4. Click OK. → Each cell in B2:B50 now has a dropdown showing ✓ and ✗ only. Method 2: Custom formula validation (rejects anything not a tick or cross). The formula allows only cells that contain exactly the tick or cross character. =OR(B2="✓", B2="✗") Use this in Data Validation → Custom formula field. An alert message appears if the user types anything else. Add an error message for clarity: Data Validation → Error Alert tab. Title: Invalid entry Error message: Please select ✓ or ✗ from the dropdown list only.

Colour-coded ticks — conditional formatting for visual status

A green tick and a red cross communicate status faster than any label. Conditional formatting applies colour automatically based on the cell content. Specifically, cells containing the tick character turn green, cells with the cross turn red. This approach works whether the characters are Wingdings or Unicode. Additionally, you can extend it to colour the entire row based on the status column.

Highlight column B green when tick, red when cross: 1. Select B2:B50. 2. Home → Conditional Formatting → New Rule. 3. Use "Format only cells that contain" → Cell Value → equal to. 4. Type the tick character ✓ (or =CHAR(252) for Wingdings). 5. Set Fill: Green (e.g. #DCFCE7) and Font colour: dark green. 6. Repeat with the cross ✗ and red colours for a second rule. Colour entire row based on status column (B): 1. Select the full data range A2:D50. 2. Home → Conditional Formatting → New Rule → Use a formula. 3. Formula for green row when tick in column B: =$B2="✓" 4. Set Fill: light green. Click OK. 5. Add a second rule for red rows when cross in column B: =$B2="✗" 6. Set Fill: light red. Click OK. → Entire rows turn green for complete items and red for incomplete ones. The $ before B locks the column so the rule checks B for every row in the range.

✓For Wingdings conditional formatting, the comparison character must match the font. Paste CHAR(252) into a helper cell formatted as Wingdings, then copy the resulting tick character and paste it into the conditional formatting rule’s value field. Unicode characters (✓ ✔) work directly in the value field of any conditional formatting rule without any font concern.

Common Issues and How to Fix Them

The CHAR formula shows a letter instead of a tick mark

CHAR(252) without the Wingdings font displays the standard ASCII character for code 252, which appears as a number or letter. The fix is straightforward: select the cell containing the formula, then change the font to Wingdings in the Font dropdown. The letter immediately converts to a tick mark. Format the column before entering the formula to avoid this issue on future entries.

The Alt code types a number instead of a tick mark

Alt codes require Num Lock to be active and a numeric keypad — not the number row at the top of the keyboard. On laptops without a dedicated keypad, Alt codes often do not work at all. In that case, use the Shift+P shortcut in Wingdings 2, copy-paste a Unicode ✓ character, or use the Symbol dialog instead. Additionally, the cell must be in Wingdings font before pressing the Alt code — entering the code first in a standard font produces the wrong character.

COUNTIF returns zero even though ticks are visible

This happens when the COUNTIF criterion does not match the character in the cell. If the ticks were inserted as Wingdings CHAR(252), the criterion must be =CHAR(252) (with the cell formatted Wingdings), not the Unicode ✓ character. Conversely, if the ticks are Unicode ✓, use "✓" as the criterion. Mixing the two methods in the same column causes COUNTIF to miss some ticks. Standardise on one method throughout the column.

Avoid mixing Wingdings and Unicode ticks in the same column: A cell formatted as Wingdings that contains a Unicode ✓ will display correctly in Wingdings but cannot be matched by a Unicode COUNTIF criterion. Similarly, a Wingdings CHAR(252) character in a non-Wingdings cell may display incorrectly. Pick one method for the column and use it consistently. For new workbooks, Unicode is the recommended default because it works in any font.

Frequently Asked Questions

How do I insert a tick mark in Excel?+

There are five methods. First, use Insert → Symbol → Wingdings font → character code 252. Second, format the cell as Wingdings and press Alt+0252 on the numeric keypad. Third, format the cell as Wingdings 2 and press Shift+P. Fourth, format the cell as Wingdings and enter =CHAR(252) as a formula. Fifth, copy the Unicode character ✓ and paste it directly into any cell without changing the font. For shared workbooks, the Unicode copy-paste method is the most portable. For conditional ticks driven by formulas, use =CHAR(252) in a Wingdings-formatted cell.
What is the keyboard shortcut for a tick mark in Excel?+

The fastest keyboard shortcut is Shift+P in a cell formatted with the Wingdings 2 font. This produces the tick mark character instantly. For the Wingdings font, use Alt+0252 on the numeric keypad with Num Lock on. For a font-independent shortcut, copy the Unicode ✓ character once, then paste it with Ctrl+V wherever you need a tick. If you use ticks frequently, consider creating a Named Range or AutoCorrect entry that expands a short code like "//tick" to the ✓ character automatically.
How do I create a formula that shows a tick or a cross?+

Use an IF formula combined with CHAR to show different symbols based on a condition. Format the result cell as Wingdings, then enter: =IF(A2="Done", CHAR(252), CHAR(251)). This returns a tick when A2 equals "Done" and a cross otherwise. For a Unicode version without font change: =IF(A2="Done","✓","✗"). Extend to three states with a nested IF: =IF(A2="Done","✓", IF(A2="In Progress","—","✗")). The Unicode version works in any Excel font and is easier to share.