how to add tick mark in excel

June 28, 2026

Adding a tick mark (checkmark) in Excel is straightforward using built-in symbols, shortcuts, or interactive features, making it ideal for task lists or checklists.

Symbol Method

Select the cell, go to Insert > Symbols > Symbol, choose Wingdings or Wingdings 2 font, and pick the tick (often character code 252, like ü).

Press Insert —it appears instantly, and you can copy-paste for multiples.

This works across Excel versions and avoids formulas.

Keyboard Shortcut

Type (a) or (b) in a cell, then change the font to Marlett or Wingdings for an instant tick.

For Wingdings: Hold Alt and type 0252 on the numeric keypad (ensure Num Lock is on).

Pro tip : Format the cell font first to Wingdings, then type P for a thick tick.

CHAR Formula

Enter =CHAR(252) in a cell and set font to Wingdings —Excel converts it to a tick.

Drag the formula down for bulk ticks: =IF(A1="Done", CHAR(252), "").

Customize with colors via cell formatting.

AutoCorrect Trick

Go to File > Options > Proofing > AutoCorrect Options.

Replace "tick" with a copied Wingdings ü (paste from formula bar), add the rule, then type "tick" anywhere for auto-conversion.

Saves time for frequent use, like project trackers.

Checkboxes (Interactive)

Enable Developer tab: File > Options > Customize Ribbon > Check Developer.

Developer > Insert > Checkbox (Form Control), draw on sheet, right-click > Format Control > Cell link to tie to a cell (TRUE/FALSE).

Perfect for dynamic checklists—ticks toggle on click.

Method| Best For| Pros| Cons
---|---|---|---
Symbol| One-offs| Simple, no formulas| Manual per cell 1
Shortcut| Quick entry| Fast keyboard use| Needs font switch 8
CHAR| Formulas/lists| Bulk automation| Formula visible 6
AutoCorrect| Repetition| Hands-free| One-time setup 3
Checkbox| Interactive| Clickable, linked| Requires Developer tab 2

Advanced: Conditional Ticks

Select range, Home > Conditional Formatting > New Rule > Use formula like =A1="Yes".

Set format to Wingdings font with ü —ticks appear automatically on condition.

VBA bonus: Double-click cells for toggle (code in worksheet module).

TL;DR : Use Wingdings symbol or Alt+0252 for basics; checkboxes for interactivity.

Information gathered from public forums or data available on the internet and portrayed here.