The fastest way: copy and paste from the character map
Open Windows Character Map (search for "Character Map" in your Start menu), type "check" in the search box, and double-click the checkmark you want. It copies to your clipboard. Switch to Excel, click the cell where you want it, and paste. On Mac, use the Character Viewer (press Control + Command + Space), search "check mark", and double-click to insert.
This method works in any version of Excel and takes about 10 seconds. The checkmark appears as a regular character, so it resizes with your font and prints cleanly. You can format it like any other text — change the color, make it bold, or increase the size.
If you use the same checkmark repeatedly, type it once, copy it, then paste it wherever you need it in your spreadsheet. This is faster than opening Character Map each time.
Key Takeaways
- Windows Character Map and Mac Character Viewer let you find and copy any checkmark in seconds without memorizing codes.
- The CHAR function in Excel (=CHAR(252) for a checkmark) works if you know the character code, but copy-paste is simpler for most people.
- Wingdings font contains several checkmark styles, but the character map method gives you more options and works in any font.
- Once you paste a checkmark into one cell, you can copy and paste it to other cells rather than repeating the lookup each time.
Using the CHAR function if you know the code
Excel has a CHAR function that inserts a character based on its code number. For a basic checkmark, type =CHAR(252) into a cell and press Enter. The checkmark appears as a regular character in your spreadsheet.
This method is useful if you are building a template and want the checkmark to appear automatically or if you want to include it in a formula. However, different character codes produce different checkmark styles, and you need to know the code beforehand. The character map method is usually faster unless you are repeating the same code many times.
Wingdings font checkmarks
Wingdings is a font built into Excel that contains several checkmark symbols. Type a regular letter (like "a" or "P"), select the cell, then change the font to Wingdings from the font dropdown. The letter transforms into a checkmark or other symbol.
The downside is that Wingdings is a symbol font, so the underlying character is still a letter — if someone opens your file on a different computer without Wingdings installed, they see the original letter instead of the checkmark. The character map method avoids this problem because it inserts the actual checkmark character, not a letter that looks like one when formatted.
Inserting from the Insert menu (Excel 2016 and later)
In newer versions of Excel, you can use the Insert menu. Click Insert, then Symbol (or Special Characters on Mac). A dialog opens showing available characters. Search for "check" or scroll to find a checkmark, then click Insert. Close the dialog and the checkmark appears in your cell.
This method is built into Excel, so you do not need to open a separate program. However, it takes more clicks than copy-paste from Character Map. Use it if you prefer staying inside Excel or if you want to browse multiple checkmark styles before choosing one.
Conditional formatting with checkmarks
If you want checkmarks to appear automatically based on a condition — for example, a checkmark when a cell contains "yes" or a number above 100 — use conditional formatting combined with a formula. Click the cells you want to format, go to Home > Conditional Formatting > New Rule, and set up a formula that returns TRUE when you want the checkmark to show.
This requires more setup than straightforward inserting a checkmark by hand, but it saves time if you have hundreds of rows and want the checkmarks to update automatically. You can also use an IF formula in a separate column: =IF(A1="yes","✓","") will display a checkmark only when column A says "yes".
Keeping checkmarks consistent across your spreadsheet
Once you have inserted a checkmark you like, copy it and paste it throughout your spreadsheet rather than looking it up each time. This ensures all your checkmarks match and saves repetition. You can also create a small reference cell at the top of your sheet with the checkmark, then copy from that cell whenever you need it.
If you work with the same checkmark style regularly, consider saving a template with the checkmark already in place. When you open the template for a new project, the checkmark is ready to copy and paste.
Frequently Asked Questions
Why does my checkmark look different on someone else's computer?
If you used Wingdings font, the checkmark may not display correctly on computers that do not have Wingdings installed. Use the character map method instead — it inserts the actual checkmark character, which displays the same way on any computer.
Can I use a checkmark in a formula?
Yes. You can include a checkmark in an IF formula like =IF(A1>50,"✓","X") to show a checkmark when a condition is true. You can also use CHAR(252) in a formula: =IF(A1="done",CHAR(252),""). Copy the checkmark from Character Map and paste it directly into your formula.
What if I want different checkmark styles?
Character Map shows many checkmark variations — hollow boxes, filled boxes, heavy checks, and light checks. Open Character Map, search "check", and scroll through the results to find the style you want. The Insert > Symbol menu in Excel also shows multiple options.
Is there a keyboard shortcut for checkmarks?
There is no universal keyboard shortcut in Excel, but you can create one using AutoCorrect. Type your checkmark once, select it, go to File > Options > Proofing > AutoCorrect Options, and set a shortcut (like typing "chk" to insert the checkmark automatically). This works only on your computer.
Can I make a checkbox that people can click to mark complete?
That requires a form control or macro, which is beyond inserting a straightforward checkmark character. If you need interactive checkboxes, look into Excel's Developer tab and Form Controls, or use a checkbox font where clicking toggles between checked and unchecked states.