How to Insert a Check Mark in Excel: 7 Easy Methods

You opened a spreadsheet, you stared at a column of tasks, and somewhere in the back of your head you thought, "There has to be a faster way to mark these done." Spoiler: there is. Several, actually. Inserting a check mark in Excel sounds like a one-click job, but the truth is messier — Excel has at least seven legitimate ways to drop a tick into a cell, and each one fits a different situation.

Some people just need a quick visual cue for a to-do list. Others need a tick that lives inside a real form, one that ties to a TRUE/FALSE value, drives a formula, or kicks off conditional formatting when a row is "complete." Pick the wrong method and you'll end up with a tick that prints fine on paper but breaks every time someone opens the file in Google Sheets. Pick the right one and your sheet becomes a small, quiet productivity machine.

This guide walks through every working method — Insert > Symbol, Wingdings 2, the classic Wingdings ü trick, Unicode characters U+2713 and U+2714, the CHAR function, AutoCorrect setup, plus the two true checkbox options (Form Controls and ActiveX) and the new linked-cell checkbox in Microsoft 365. By the end you'll know which one to use, why it matters, and how to avoid the silly font issues that turn your ticks into question marks on someone else's computer.

Before we touch a single menu, let's clear up the biggest source of confusion: a check mark in Excel is not always the same thing. Sometimes it's a literal Unicode character — a real letter that lives in the cell and can be copied, searched, and replaced like any other text. Other times it's a glyph drawn by a specific font, so the character "P" inside Wingdings 2 actually renders as a tick. And sometimes it's not a character at all but a graphical object floating on top of the grid, like a Form Control checkbox.

That distinction matters more than people realise. If you send a workbook to a colleague who doesn't have Wingdings installed (rare on Windows, slightly more common on stripped-down Linux boxes or older mobile clients), your tidy ticks will degrade into capital P's. If you rely on Unicode instead, you're safe across Windows, macOS, iOS, Android, and Google Sheets. So as a rule of thumb: use Unicode for portable workbooks, Wingdings for quick local lists, and proper checkboxes for anything interactive.

Method 1 — Insert > Symbol (the official menu route)

This is the path Microsoft itself recommends, and it works in every version of Excel from 2010 onward. Click the cell where you want the tick, then go to Insert > Symbol. A dialog opens. In the Font dropdown choose Segoe UI Symbol or Arial Unicode MS, then in the Subset dropdown choose Dingbats. Scroll a little — you'll see ✓ (Unicode U+2713) and the heavier ✔ (U+2714). Double-click to insert, then close the dialog.

The advantage is that the tick is a real Unicode character. Copy it, paste it, search for it, count it with COUNTIF, replace it with Find & Replace — it behaves like text because it is text. The downside is that the dialog takes about four clicks every time, which is fine for one cell but painful for fifty. That's why the next methods exist.

Method 6 — AutoCorrect for super-fast typing

If you insert ticks dozens of times a day, the smartest play is to teach Excel to do it automatically. Go to File > Options > Proofing > AutoCorrect Options. In the "Replace" box type something you would never type by accident — (tick) or :check: are popular choices. In the "With" box paste a real Unicode ✓. Click Add, click OK, and from now on every time you type (tick) in any cell it becomes ✓ as soon as you press space or Enter.

This setup syncs across all Office apps tied to your Microsoft account, so the same shortcut works in Word, Outlook, and PowerPoint without any extra setup. It's the single biggest productivity tweak in this guide and it takes ninety seconds to configure once. After that you never reach for the Symbol dialog again.

Method 2 — Wingdings 2 keyboard shortcut

If you can change the font of a cell, you can type a tick in one keystroke. Set the cell font to Wingdings 2, then press capital P. That's it. Capital P in Wingdings 2 renders as a check mark. Capital O renders as the heavier ballot tick. Capital Q is a check inside a box, R is the boxed heavy tick, and S/T are the matching X marks for "no." Keep a sticky note on your monitor for a week and you'll memorise them.

This method is fastest for human typists. The catch is the font dependency — if Wingdings 2 isn't installed on the machine that opens your file, every P stays a P. On modern Windows and Microsoft 365 you can safely assume it's there. On older Excel-for-Mac builds or third-party viewers, not so much. So use this for personal sheets and internal templates, not for files you send to clients or upload to a public download library.

Method 7 — Interactive checkboxes

So far every method has been a static character — once it's in the cell it just sits there. But what if you want a clickable checkbox that toggles TRUE/FALSE and triggers a formula or a conditional format? Excel gives you three real options.

The first is the Form Control checkbox, on the Developer tab under Insert > Form Controls > Check Box. Draw the box on the sheet, right-click, choose Format Control, and link it to a cell. That linked cell now flips between TRUE and FALSE when the box is clicked. The second is the ActiveX checkbox, which is more powerful but only works on Windows Excel and is increasingly considered legacy.

The third — and the future — is the linked-cell checkbox introduced in Microsoft 365 in 2024: just select a range, go to Insert > Checkbox, and Excel inserts a native checkbox in every cell. Click to toggle, no Developer tab required. If you're on a current Microsoft 365 build, use this one.

Method 3 — Classic Wingdings (the ü trick)

Before Wingdings 2 existed there was just Wingdings, and the lowercase letter ü rendered as a tick. The bold version, û, gave you the heavy tick. You'll still see this method in old training PDFs and YouTube tutorials from 2008. It works, but Wingdings 2's capital P is easier to remember and easier to type on a US keyboard (no Alt codes for the ü).

Keep this method in your back pocket for two situations: legacy templates that someone built fifteen years ago and you don't want to refactor, and Excel files that need to open cleanly in old versions of OpenOffice or LibreOffice where Wingdings 2 mappings can be slightly off.

Pairing check marks with conditional formatting

A check mark on its own is a visual cue. A check mark wired to conditional formatting is a system. The combination most ops teams swear by is: a TRUE/FALSE column driven by an inserted checkbox, plus a conditional formatting rule that highlights or strikes through the whole row when that cell is TRUE.

Here's the recipe in three steps. Insert a checkbox in column A (use the Microsoft 365 native one if you can). Select the data range to the right of column A. Open Home > Conditional Formatting > New Rule > Use a formula and enter =$A2=TRUE. Set the format to a faded grey fill with a strikethrough font. Click OK. Now every time someone ticks a row, the whole row visually retires itself. It's the small touch that makes a to-do list feel professional.

Method 4 — Unicode characters (the portable winner)

The cleanest, most modern way to put a tick in a cell is to use the actual Unicode characters: ✓ (U+2713) and ✔ (U+2714). There are also boxed versions: ☑ (U+2611) for a ticked box and ☒ (U+2612) for a crossed box. These render in every modern operating system without needing a special font, which is why they're the default choice for anything you'll share, sync, or upload to a cloud service.

To enter them, you have three options. First, copy them straight from this page. Second, on Windows hold Alt and type 10003 on the number pad for ✓, or 10004 for ✔ (your cell needs to be in a font that supports Unicode — Calibri, Arial, Segoe UI all work). Third, use the CHAR or UNICHAR function described below. Out of all the methods in this guide, Unicode is the one you should reach for first if your file is going anywhere outside your own laptop.

Common problems and how to fix them

Two issues come up over and over again with Excel check marks. The first is the "my ticks turned into P's" problem, which happens when a file built with Wingdings 2 is opened on a system where that font isn't installed or isn't being substituted correctly. The fix is to convert the column to Unicode ✓ characters: copy the column, paste-special as values into a parking column, run a Find & Replace where the "find" is capital P and the "replace" is ✓, then change the font back to Calibri. Job done.

The second issue is counting. If you try =COUNTIF(A:A, "P") on a Wingdings 2 column, you'll get the right number but a future you will wonder why on earth you're counting capital P's. Use Unicode and you can write =COUNTIF(A:A, "✓") which reads like English. Same logic for SUMIFS, AVERAGEIFS, and pivot table filters — Unicode wins on readability every single time.

Method 5 — CHAR and UNICHAR functions

Spreadsheets that build themselves with formulas need a way to insert a tick programmatically — and that's exactly what CHAR and UNICHAR are for. The classic trick is =CHAR(252), which returns the ü character; format the cell as Wingdings and that ü renders as a tick. So a formula like =IF(B2="done", CHAR(252), CHAR(251)) with the result column set to Wingdings will show a tick for "done" rows and a cross for everything else.

The more portable cousin is UNICHAR, introduced in Excel 2013. =UNICHAR(10003) returns ✓ directly — no Wingdings, no font dependency. =UNICHAR(10004) returns ✔. This pairs beautifully with IFS or SWITCH for status columns, and the resulting characters survive being exported to CSV, pasted into emails, or opened in Google Sheets. It's quietly become the most-used method on serious finance and ops teams for that reason.

Quick tips for printing and exporting

Two more things worth knowing. When you print a sheet with Form Control checkboxes, the checkbox object will print exactly where it sits on the grid — but if you've used the Microsoft 365 native cell checkbox, it prints as a small ticked or unticked box inside the cell, which usually looks tidier on paper. Test print one page before you commit to a full report.

For exports: PDF handles every method we've covered flawlessly, including Wingdings, as long as the font is embedded (which Excel does by default for "Save as PDF"). CSV strips all formatting, so Wingdings ticks become plain capital P's in the exported file — a strong argument for Unicode if your workflow includes a CSV step. And Google Sheets imports Unicode ticks perfectly, Wingdings ticks not at all.

Choosing the right method for your sheet

So which one do you actually use day to day? It depends on three factors: how often you need to insert the tick, who else will open the file, and whether the tick needs to drive a formula or just sit there as decoration. The structure cards below give you a quick decision map, and the tabs section after that walks through each method side by side with steps.

One quick warning before we move on: if you're building a dashboard that has to render the same way for every viewer, do not mix methods. A column of Wingdings 2 ticks next to a column of Unicode ticks looks fine on your screen, but the kerning and baseline shift on other machines and your beautiful sheet looks lopsided. Pick one method, stick to it, document it in a cell comment if the file will be edited by others.

Putting it all together

For most people the answer is going to be one of two methods: the Unicode character ✓ for cells that need to be portable and searchable, or the Microsoft 365 native checkbox for sheets that need to be interactive. The other five methods exist because Excel has thirty years of history behind it and Microsoft never breaks anything, but in a brand-new sheet you're building today you almost never need them.

If you take one thing away from this guide, let it be this: set up the AutoCorrect entry once. Type (tick), press space, get ✓. Five seconds of setup, saved forever. Then layer in conditional formatting when you want the tick to drive behaviour, and reach for the native checkbox only when you genuinely need a click target. That's the whole system — simple, portable, and fast.