How to Insert a Check Mark Symbol in Excel

The quickest way to add a check mark

The fastest method is to type a check mark directly using your keyboard. On Windows, hold Alt and type 0252 on the numeric keypad, then release Alt. On Mac, press Option + V. Both produce a ✓ symbol that you can paste into any cell.

If your keyboard doesn't have a numeric keypad or you're on a laptop, this method won't work — skip to the next section for the Insert Symbol approach instead. The Alt code method works in any version of Excel, including Excel Online, as long as you're typing directly into a cell.

Once you've typed the check mark once, you can copy it and paste it into other cells. Select the cell containing your check mark, press Ctrl + C (Windows) or Command + C (Mac), click the cell where you want it, and press Ctrl + V or Command + V.

Key Takeaways

Windows users can type Alt + 0252 on the numeric keypad to insert a check mark; Mac users press Option + V.
The Insert Symbol menu (Insert tab, then Symbol) works on any computer and shows you dozens of check mark styles to choose from.
Once you've created one check mark, copy and paste it into other cells rather than repeating the keyboard shortcut each time.
Conditional formatting can automatically add check marks based on cell values, useful for tracking completion or status across many rows.
The Wingdings font contains multiple check mark characters that look different from the standard symbol.

Using the Insert Symbol menu for more options

If the keyboard shortcut doesn't work or you want to choose from different check mark styles, use Excel's Symbol menu. Click the cell where you want the check mark, then go to the Insert tab at the top of the ribbon and select Symbol (it's on the right side of the ribbon, usually near Special Characters).

A dialog box opens showing hundreds of symbols. In the search field at the top, type "check" and Excel will filter to show check mark options. You'll see several variations — some are hollow boxes with checks, others are solid, and some are styled differently. Click the one you want and press Insert, then close the dialog.

This method works the same way in Excel Online, Excel for Mac, and Excel for Windows. The Symbol menu is the most reliable way to find exactly the style you're looking for without memorizing keyboard codes.

Changing the font to access Wingdings check marks

Excel includes a special font called Wingdings that contains different check mark characters. To use it, click your cell and type the letter P (capital P). Then select that cell, go to the font dropdown at the top left of the ribbon (it usually says "Calibri" or "Arial"), and change it to Wingdings. The P transforms into a check mark.

Wingdings also contains other symbols — for example, the letter R becomes a different style of check mark, and the letter Q becomes an X. If you want a different symbol style, try other letters. This approach is useful if you're building a template and want all your check marks to match a specific visual style.

The downside is that if someone opens your file on a computer that doesn't have Wingdings installed (rare, but possible), the symbols may not display correctly. The standard check mark from the Insert Symbol menu is safer for files you'll share.

Using conditional formatting to add check marks automatically

If you're tracking whether tasks are complete or whether cells meet certain conditions, you can set up conditional formatting to add check marks automatically. Select the range of cells you want to format, go to the Home tab, click Conditional Formatting, and choose New Rule.

Select Format only cells that contain, then set up your condition. For example, you might say "if the cell value equals 'Done'" or "if the cell value is greater than 100." In the Format section, click the Font tab, change the font to Wingdings, and in the preview area type the letter that produces your check mark (usually P). Click OK.

Now whenever a cell in that range meets your condition, Excel automatically displays the check mark. This saves time if you're managing a long checklist or tracking status across many rows — you only need to enter the trigger value (like "Done" or a number), and the check mark appears on its own.

Copying check marks between cells and workbooks

Once you've created a check mark you like, the easiest way to reuse it is to copy and paste. Select the cell with your check mark, press Ctrl + C (Windows) or Command + C (Mac), then click each cell where you want it and press Ctrl + V or Command + V. You can paste into multiple cells at once by selecting a range first.

To copy a check mark to a different workbook, use the same copy-and-paste method. Open both files, copy the check mark from the first file, switch to the second file, and paste. The symbol carries over without losing its formatting or font.

If you find yourself using the same check mark repeatedly across many files, consider saving a template with the check mark already in place. Create a blank workbook, add your check mark to a cell, save it as a template file, and use that template as your starting point for new projects.

Troubleshooting check marks that don't appear

If you've typed a check mark but it's not showing up, the most common cause is that you're using the wrong font. If you used the Wingdings method, make sure the cell is actually formatted as Wingdings — select it and check the font dropdown. If it says something else, change it back to Wingdings.

If you used the Alt code method on Windows and nothing appeared, you may not have used the numeric keypad. Laptops often require you to hold Fn plus Alt while typing the numbers, or they may not support the Alt code method at all. Try the Insert Symbol menu instead.

On Mac, if Option + V doesn't work, your keyboard layout may be different. Use the Insert Symbol menu as a backup — it works the same way on every computer and doesn't depend on keyboard layout.

Frequently Asked Questions

Can I make the check mark bigger or change its color?

Yes. Select the cell with your check mark, then use the font size dropdown to make it larger or smaller. To change the color, select the cell and use the font color tool (usually a letter A with a colored bar underneath) in the Home tab. The check mark will change to whatever color you choose.

What's the difference between a check mark and an X?

They're just different symbols. If you want an X instead of a check mark, use the Insert Symbol menu and search for "ballot x" or try the letter X in Wingdings font. Both work the same way in Excel — it's purely visual preference.

Will my check marks stay if I save the file as a PDF?

Yes, check marks will appear in a PDF export. Go to File, then Export As (or Save As), choose PDF, and your check marks will be included in the PDF exactly as they appear in Excel.

Can I use check marks in a formula?

Not directly in the formula itself, but you can use conditional formatting to display a check mark based on a formula result. For example, you could write a formula that returns TRUE or FALSE, then use conditional formatting to show a check mark when the result is TRUE.

Why does my check mark look different on someone else's computer?

This usually happens if you used Wingdings font and their computer displays it differently, or if they have a different version of Excel. Using the standard check mark from the Insert Symbol menu is more consistent across computers and versions.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.