Insert Tick Mark Excel

What this does

There are three routes and they behave differently. The Wingdings trick is fastest: with the cell in Wingdings, ü prints ✓, û prints ✗, and the boxed versions are ý and ý's neighbours. Insert ▸ Symbol inserts a real Unicode character (U+2713 ✓ or U+2714 ✔) that keeps working in any font. And =CHAR(252) with a Wingdings cell, or a conditional-formatting icon set, makes the mark appear automatically from a condition rather than being typed. A tick typed into a cell is decoration — if you need to count completions, store TRUE/FALSE or 1/0 and show the tick with formatting. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. Treat “insert tick mark excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a layout choice that keeps the sheet readable and sortable into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

Fast route: select C2, set the font to Wingdings, type ü and press Enter — the cell shows ✓. Unicode route: Insert ▸ Symbol ▸ Font: Segoe UI Symbol ▸ type 2713 in the Character code box ▸ Insert; this ✓ survives a font change. Automatic route: leave the source column as TRUE/FALSE and put =IF(B2, CHAR(252), "") in a Wingdings-formatted C2, so the tick appears when B2 is TRUE and =COUNTIF(B:B, TRUE) still counts correctly. Ticks show up in every checklist, QA sheet and status tracker, and the distinction that matters is whether the mark is decoration or the data — because only one of those can be counted. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “insert tick mark excel”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.

Common mistakes

• Typing ü in a non-Wingdings cell and getting a literal ü.
• Storing the tick character as the data and then being unable to count or filter it reliably.
• Using Wingdings characters in a file that will be opened on a machine without that font, where they fall back to letters — Unicode ✓ is the portable choice.
• Mixing ✓ (U+2713) and ✔ (U+2714) in one column so filters treat them as two different values.
• Reaching for a checkbox control when a data-driven ✓ from a formula would be simpler and easier to total.

Frequently asked questions