The fastest way to add a check mark

The simplest 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. The character will appear in the cell where your cursor is active.

This method works in any version of Excel and doesn't require you to install fonts or change settings. The check mark appears as a regular character, so you can format it like any other text — change the color, size, or font.

If you're working on a laptop without a numeric keypad, this approach may not work. In that case, use one of the methods below instead.

Key Takeaways

  • On Windows, hold Alt and type 0252 on the numeric keypad to insert a check mark; on Mac, use Option + V.
  • The Insert Symbol dialog lets you search for and insert check marks without memorizing keyboard codes, and works on any device.
  • Wingdings and Wingdings 2 fonts contain check mark characters that look different from standard text, useful if you want a distinctive appearance.
  • You can use conditional formatting to automatically display a check mark based on the value in another cell, saving time on repetitive tasks.
  • Copy and paste is the fastest method if you only need to add the same check mark multiple times in one spreadsheet.

Using the Insert Symbol dialog

The Insert Symbol dialog works on Windows, Mac, and any device, and doesn't require keyboard codes. Click the cell where you want the check mark. Go to the Insert tab in the ribbon, then click Symbol (in newer Excel versions) or Special Character (in older versions).

A dialog box will open. In the search field, type "check mark" or scroll through the list. You'll see several versions — a straightforward ✓, a heavier ✔, and others. Click the one you want, then click Insert. Close the dialog when you're done.

This method takes a few more clicks than the keyboard shortcut, but it's more reliable if you're not sure about the code or if your keyboard doesn't have a numeric pad.

Using Wingdings fonts for a different look

If you want a check mark that looks noticeably different from regular text, use the Wingdings or Wingdings 2 font. These fonts replace letters with symbols — in Wingdings, the letter P displays as a check mark.

Click the cell, type the letter P, then select that cell. In the font dropdown (usually at the top left of the ribbon), change the font from your current choice to Wingdings. The P will when ready become a check mark. In Wingdings 2, use the letter A instead.

This approach is useful if you're building a checklist or status tracker and want the check marks to stand out visually. The downside is that if someone opens your file in a different program or on a different device, the font may not transfer correctly, and you'll see the letter instead of the symbol.

Copying and pasting a check mark

If you need to add the same check mark many times, the fastest approach is to create it once, then copy and paste it. Type or insert a check mark in one cell using any method above. Right-click that cell and select Copy, or press Ctrl+C (Windows) or Command+C (Mac).

Select all the cells where you want the check mark. You can click one cell, hold Shift, and click another to select a range, or click multiple individual cells while holding Ctrl (Windows) or Command (Mac). Then right-click and select Paste, or press Ctrl+V or Command+V.

This method is much faster than inserting a check mark one cell at a time, especially if you're filling in a long list or a table with many rows.

Using conditional formatting to show check marks automatically

If you want a check mark to appear based on a condition — for example, when a task is marked "complete" in another column — use conditional formatting. This saves you from typing or pasting manually.

Select the range of cells where you want check marks to appear. Go to the Home tab, click Conditional Formatting, then select New Rule (Windows) or Manage Rules (Mac). Choose Format only cells that contain, then set the condition — for example, if the adjacent cell equals "yes" or "done".

Click the Format button, go to the Font tab, and change the font to Wingdings. In the preview area, type P (which will display as a check mark in Wingdings). Click OK twice. Now whenever the condition is met, a check mark will appear automatically in those cells.

Troubleshooting check marks that don't display correctly

If you insert a check mark and it appears as a box, a question mark, or a different symbol, the font on your device doesn't support that character. Try changing the font to Calibri, Arial, or Times New Roman — these are standard fonts that usually display check marks correctly.

If you used a Wingdings check mark and it's showing as a letter instead, the person viewing the file doesn't have Wingdings installed, or the font didn't transfer when the file was shared. To avoid this, use the standard check mark (Alt+0252 or Insert Symbol) instead, which works across all devices.

If the check mark is the right symbol but the wrong size or color, select the cell and use the font size dropdown or the font color tool in the ribbon to adjust it. Check marks format like any other character in Excel.

Frequently Asked Questions

Can I use a checkbox instead of a check mark character?

Yes. Go to the Developer tab (you may need to enable it in Excel settings first), click Insert, and select Checkbox. Checkboxes are interactive — you can click them to toggle on and off — but they take up more space and are harder to use in large tables. A check mark character is usually simpler for lists and status tracking.

What's the difference between ✓ and ✔?

Both are check marks, but ✓ is thinner and ✔ is heavier and bolder. The Insert Symbol dialog shows both. Choose whichever looks better in your spreadsheet. There's no functional difference — it's purely visual.

Will my check mark stay if I save the file as a PDF or send it to someone else?

Check marks created with Alt codes or Insert Symbol will transfer correctly to PDF and to other people. Wingdings check marks may not — they'll show as letters if the recipient doesn't have Wingdings installed. For sharing, use the standard check mark method.

Can I search for cells that contain a check mark?

Yes. Press Ctrl+H (Windows) or Command+H (Mac) to open Find and Replace. In the Find field, insert a check mark using Alt+0252 or copy one from your spreadsheet and paste it. Click Find All to see every cell with that check mark.

How do I remove a check mark from multiple cells at once?

Select all the cells containing check marks. Press Delete to clear them. If you want to replace them with something else — like an X or a dash — use Find and Replace instead: press Ctrl+H, find the check mark, and type what you want in the Replace field.