How to Put a Check Sign in Excel: Every Method Explained

Adding a check mark (✓) in Excel sounds simple, but there are actually several distinct ways to do it — and the right approach depends entirely on what you need that check mark to do. Is it decorative? Does it need to be clickable? Will you be filtering or sorting by it? Each answer points to a different method.

What Counts as a "Check Sign" in Excel?

Before diving into steps, it helps to distinguish between two things people often mean:

• A static check mark symbol — a visual ✓ or ✔ character sitting in a cell, used for display purposes
• An interactive checkbox — a clickable control that toggles TRUE/FALSE, typically used in task lists or forms

These are genuinely different objects in Excel, inserted differently and behaving differently. Mixing them up is the most common source of confusion.

Method 1: Insert a Check Mark Symbol via the Symbol Menu

This is the most straightforward path for a static check mark.

1. Click the cell where you want the check mark
2. Go to Insert → Symbol
3. In the Font dropdown, select Wingdings or Wingdings 2
4. Scroll to find the check mark characters (✓ ✔), or type 252 in the Character Code box (for Wingdings)
5. Click Insert, then Close

Wingdings character codes worth knowing:

One important detail: if you format the cell using the Wingdings font directly, you can type the letter P and it will display as a check mark. This is useful when building templates where users type into cells rather than using menus.

Method 2: Use a Keyboard Shortcut or ALT Code

On Windows, you can insert special characters using ALT codes:

• Hold Alt and type 0252 on the numeric keypad (with Num Lock on) — this inserts ü, which becomes ✓ when the cell font is set to Wingdings

This feels indirect because it is. The character you're typing is technically a standard letter that looks like a check mark only because of the font applied. If the font changes, the symbol changes too. Keep that in mind when sharing spreadsheets across different systems or users.

On Mac, the shortcut Option + V inserts a ✓ character directly as a Unicode symbol, which is more stable across fonts.

Method 3: Copy-Paste a Unicode Check Mark

Unicode check marks are font-independent, meaning they display correctly regardless of what font is applied to the cell. Simply copy one of these and paste it into any Excel cell:

• ✓ (U+2713 — Check Mark)
• ✔ (U+2714 — Heavy Check Mark)
• ☑ (U+2611 — Ballot Box with Check)

This method is underrated for reliability. Because the character is Unicode rather than a font-dependent glyph, it survives formatting changes, copy-pasting between workbooks, and even exporting to other formats.

Method 4: Use a Formula to Display a Check Mark Conditionally ✅

If you want check marks to appear automatically based on data — for example, marking completed tasks when a value in another column equals "Done" — you can use an IF formula combined with the CHAR function:

=IF(A2="Done", CHAR(252), "") 

Set the font of that formula cell to Wingdings, and it will show a check mark whenever A2 contains "Done."

Alternatively, using Unicode directly in a formula:

=IF(A2="Done", "✔", "") 

This second version doesn't require a font change and is generally cleaner for shared workbooks.

Method 5: Insert an Interactive Checkbox (Form Control)

For task lists, surveys, or any situation where users need to click to toggle a check mark, you want a Form Control checkbox — not a symbol.

1. Go to the Developer tab (if it's not visible, enable it under File → Options → Customize Ribbon)
2. Click Insert → under Form Controls, select the checkbox icon
3. Draw the checkbox onto your spreadsheet
4. Right-click → Format Control → link it to a cell to output TRUE/FALSE

🔲 This linked cell becomes the data. You can then use that TRUE/FALSE value in formulas, conditional formatting, or filters. This is a meaningfully different tool from a static symbol — it's interactive and functional, not just visual.

The Variable That Changes Everything: Your Use Case

The method that makes sense varies significantly depending on a few key factors:

Who will use the spreadsheet? A file you build and use yourself can rely on font-dependent Wingdings tricks. A file shared across a team — especially across Mac and Windows — benefits from Unicode symbols or checkboxes that don't depend on installed fonts.

Will the check mark drive logic? If you need to filter rows, trigger conditional formatting, or run calculations based on whether something is checked, a Form Control checkbox linked to a cell is the right architecture. A visual symbol can't be evaluated in a formula.

Is this a printed document or a working tool? Static symbols print cleanly and look professional in reports. Interactive checkboxes are optimized for on-screen use and data entry.

Which Excel version are you on? Older versions of Excel have slightly different paths to the Developer tab and Symbol menu. The newer Excel for Microsoft 365 also supports checkboxes natively in cells (without needing the Developer tab) — a feature rolling out that simplifies the process considerably for supported versions.

The right combination of method, font handling, and interactivity depends on where your spreadsheet lives, who touches it, and what the check mark is actually supposed to communicate.