How to Insert a Check Mark Symbol in Excel

The fastest way to add a check mark in Excel

You can insert a check mark in Excel in three ways: typing a special character code, copying a symbol from the character map, or using a wingdings font. The quickest method depends on whether you need one check mark or many across your spreadsheet.

The simplest approach for a single check mark is to type it directly using Alt codes on Windows or the character viewer on Mac. For repeated use, switching to the Wingdings font lets you type a regular letter and have it display as a check mark. If you need to insert many check marks at once, a formula approach using the CHAR function works across all devices.

Key Takeaways

On Windows, hold Alt and type 10003 on the numeric keypad to insert a check mark directly into any cell.
On Mac, press Option + V to open the character viewer, search for "check mark", and double-click the symbol you want.
Switching a cell to Wingdings font and typing the letter "a" displays as a check mark without using special codes.
The CHAR(252) formula in Wingdings font creates a check mark that updates automatically if you copy the formula down a column.

Using Alt codes on Windows

On a Windows computer, the Alt code method is the fastest for inserting a single check mark. Click the cell where you want the check mark, then hold down the Alt key while typing 10003 on the numeric keypad (not the number row at the top). Release Alt and the check mark appears in the cell.

This method requires a numeric keypad, which most desktop keyboards have but many laptops do not. If your laptop lacks a numeric keypad, you can enable a software numeric keypad by pressing Alt + the Fn key, or use one of the other methods instead. The check mark inserted this way is a regular character, so it stays in place if you sort or filter your spreadsheet.

Using the character viewer on Mac

On a Mac, click the cell where you want the check mark, then press Control + Command + Space to open the character viewer. Type "check mark" in the search box at the top. The viewer shows several check mark styles — the solid filled checkmark is usually the second option.

Double-click the check mark you want, and it inserts into your cell. Close the character viewer window. This method works on any Mac and gives you access to dozens of check mark styles, from straightforward outlines to filled boxes with checkmarks. The character viewer also lets you search for other symbols you might need in your spreadsheet.

Switching to Wingdings font for repeated check marks

If you need many check marks in your spreadsheet, the Wingdings font method is faster than typing Alt codes repeatedly. Select the range of cells where you want check marks. Open the font dropdown in the toolbar and select Wingdings. Now type the letter "a" in any cell in that range, and it displays as a check mark.

This works because Wingdings is a symbol font where each letter corresponds to a different symbol. The letter "a" is mapped to a check mark. You can type "a" in multiple cells, and each one shows as a check mark. If you later need to change the font back to your regular font, the check marks turn into the letter "a", so only switch to Wingdings when you are sure you want to keep the symbols.

Using a formula to create check marks

For a more flexible approach that works across Windows and Mac, use the CHAR function combined with Wingdings font. Click a cell, type the formula =CHAR(252), and press Enter. The cell displays a check mark. You can copy this formula down a column to fill multiple cells with check marks at once.

To use this method, first select the range where you want check marks to appear. Type the formula in the first cell, press Enter, then select that cell again and drag the fill handle (the small square at the bottom right of the cell) down to copy the formula to other cells. Then select all those cells and change the font to Wingdings. The check marks appear in every cell. If you later need to delete the check marks, you can clear the cells or change the font back.

Choosing between an X and a check mark

Excel also lets you insert an X symbol using the same methods. On Windows, the Alt code for an X is 10005. In Wingdings font, the letter "b" displays as an X. Using both symbols in the same spreadsheet — check marks for "yes" and X marks for "no" — makes it straightforward to scan a list at a glance.

If you are building a checklist or a yes/no column, decide which symbols you want before you start. Mixing different symbols or styles in the same column makes the spreadsheet harder to read. Stick to one check mark style and one X style throughout the sheet.

Keeping check marks when you sort or filter

Check marks inserted as characters stay in place when you sort or filter your spreadsheet, because they are stored as regular data in the cells. If you use a formula like =CHAR(252), the formula moves with the row when you sort, so the check mark stays attached to the correct data.

If you are worried about accidentally deleting check marks, you can lock those cells. Select the cells with check marks, right-click, choose Format Cells, go to the Protection tab, and check the Locked box. Then go to the Review tab, click Protect Sheet, and set a password. Now those cells cannot be edited unless someone unprotects the sheet. This is useful for templates where you want to prevent users from removing check marks you have already placed.

Frequently Asked Questions

Can I use a check mark in a formula or conditional formatting?

Yes. You can reference a cell containing a check mark in a formula, or use conditional formatting to display a check mark based on a condition. For example, you could use =IF(A1="yes",CHAR(252),"") to show a check mark only when column A says "yes". Set the cell font to Wingdings to display the symbol correctly.

What if the check mark looks like a box or question mark?

This usually means the font is not set to Wingdings or the character encoding is wrong. Select the cell, change the font to Wingdings, and the symbol should display correctly. If it still shows as a box, try a different check mark Alt code or use the character viewer to insert a different check mark style.

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

Yes. Select the cell with the check mark and use the font size dropdown to make it larger or smaller. To change the color, select the cell, click the font color button in the toolbar, and choose a new color. The check mark changes to match the cell's formatting.

Do check marks work the same way in Google Sheets?

Google Sheets does not support Alt codes or Wingdings font the same way Excel does. Instead, use Insert > Special Characters, search for "check mark", and click the one you want. You can also type the formula =CHAR(10003) in any cell to insert a check mark, though you may need to adjust the font.

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.