Inserting a tick mark in an Excel cell is straightforward through the Symbol dialog with Wingdings font and character code 252.
A project tracker without tick marks is a list without progress. The official method for how to enter tick mark in Excel is the Insert Symbol dialog — available from the Insert tab, it lets you choose Wingdings font and enter character code 252 to place a clean checkmark in any cell. Below are the methods that work, starting with the one Microsoft documents across every desktop version.
Inserting A Tick Mark In Excel: Methods That Work In Every Version
Each method below serves a different need — from a single one-off tick to hundreds of automated checkmarks. The detailed steps come first for the approaches that require explanation, followed by a comparison table.
The Official Symbol Dialog Method
Microsoft’s support page documents the Symbol dialog as the primary route for tick marks in Excel. Click the cell where you want the symbol, then go to Insert > Symbols > Symbol. In the dialog that opens, set the Font dropdown to Wingdings, type 252 in the Character code field, and click Insert. The tick mark appears in your selected cell immediately.
An alternative character code, 254, produces a boxed checkmark in the same Wingdings font. Both codes work in Excel, Word, Outlook, and PowerPoint, so the skill transfers across Office apps.
Does The Keyboard Shortcut Method Work In Excel?
Alt+0252 is a commonly mentioned shortcut, but it isn’t a native Excel key combination — it relies on Windows Alt codes and a font change afterward. Hold Alt and type 0252 on the numeric keypad, then release Alt. The character appears in the cell. Switch the cell’s font to Wingdings, and the tick mark displays.
This method requires a numeric keypad with NumLock on. Compact laptops without one need the on-screen keyboard or an external keypad. When set up correctly, it’s faster than opening the Symbol dialog each time, but the font change step is mandatory.
Using Wingdings 2 For A One-Key Tick
Wingdings 2 offers the simplest keyboard route: change the cell font to Wingdings 2 and type a lowercase p. The result is a clean tick mark. An uppercase P produces a different symbol in the same font, giving you two options without leaving the keyboard.
This method is ideal when you need to enter multiple tick marks quickly — select the target cells, switch the font once, and type p in each cell.
Can A Formula Display A Tick Mark?
A formula can render a tick mark when paired with the Wingdings font. The formula =CHAR(252) produces the checkmark symbol, and =CHAR(254) produces the boxed checkmark. The cell’s font must stay set to Wingdings for the characters to display correctly.
This approach works well with conditional logic. For example, a formula like =IF(A1="Done", CHAR(252), "") shows a tick mark when a cell contains “Done” and leaves the cell blank otherwise. Microsoft’s official support documentation covers the Symbol dialog method that these CHAR codes are based on.
| Method | How It Works | Best Scenario |
|---|---|---|
| Symbol Dialog | Insert > Symbol, Wingdings, code 252 | Official method, one tick at a time |
| Alt+0252 Shortcut | Alt + 0252 on numpad, switch font to Wingdings | Fast entry with numeric keypad |
| Wingdings 2 + P | Change font to Wingdings 2, type p | Multiple ticks, one-key speed |
| CHAR(252) Formula | =CHAR(252) with Wingdings font | Conditional or automated display |
| Copy-Paste | Paste tick symbol from another source | One-off entries, no setup |
| Checkbox Control | Developer > Insert > Checkbox | Interactive toggling lists |
| Emoji Keyboard | Win + . opens emoji picker, search “check” | Quick visual pick, Windows only |
Copy And Paste As A Fallback
If you already have a tick mark in another document, a web page, or an email, copying it directly into an Excel cell works instantly. The pasted symbol retains its appearance without requiring a specific font setting. This method is best for one-off entries where you don’t need to repeat the process across many cells.
Adding Interactive Checkboxes Instead
An interactive checkbox differs from a static tick mark — it toggles on and off with a click, making it suitable for to-do lists and forms. To add one, enable the Developer tab first: go to File > Options > Customize Ribbon, then check Developer in the right panel. Click OK.
With the Developer tab visible, go to Developer > Insert > Checkbox (under Form Controls), then click in your worksheet where you want the checkbox. The control inserts a clickable box that shows a check mark when selected. This is the right approach for interactive lists where users toggle completion status.
Common Problems When Inserting Tick Marks
Most issues with tick marks come down to font settings, keyboard limitations, or the version of Excel in use. The table below covers the most frequent problems and their fixes.
| Problem | Most Likely Cause | Quick Fix |
|---|---|---|
| Shows 0252 instead of tick | Font not set to Wingdings | Select the cell, change font to Wingdings |
| Alt code does nothing | No numeric keypad or NumLock off | Use Symbol dialog or on-screen keyboard |
| Symbol dialog grayed out | Excel Online limitation | Use Marlett workaround or copy-paste a tick |
| Wrong symbol appears | Wrong font selected | Verify Wingdings or Wingdings 2 is applied |
| Tick mark doesn’t print | Cell font and printer font mismatch | Set the cell font explicitly to Wingdings |
| Checkbox doesn’t appear | Developer tab not enabled | Enable it via File > Options > Customize Ribbon |
| CHAR formula shows text | Cell font not Wingdings | Change cell font to Wingdings |
Pick The Right Method For Your Task
The best method depends on how many tick marks you need and whether they need to be interactive. For a single tick, the Symbol dialog or copy-paste is fastest. For repeated entries across many cells, Wingdings 2 with the p key shortcut saves time. When the tick mark should appear conditionally based on cell values, the CHAR formula is the right tool. And for interactive to-do lists that users click to toggle, the checkbox control is the complete solution.
References & Sources
- Microsoft Support. “Insert a check mark symbol.” Official documentation for inserting tick marks in Excel and other Office apps using the Symbol dialog.