How to Insert a Check Mark in Excel in 4 Easy Ways

To insert a check mark in Excel, use Insert > Symbol, paste a check mark into a cell, or enter =UNICHAR(10003). For a clickable box that users can tick, choose Insert > Checkbox in supported Microsoft 365 versions. The best method depends on whether you need a simple visual mark, a formula-generated character, or an interactive checkbox.

What You’ll Need

You need a workbook you can edit and a cell where the mark should appear. The steps below are written for Excel for Microsoft 365 on Windows. For the Symbol method, a font that includes check mark characters—such as Segoe UI Symbol—helps ensure the mark displays correctly. For a formula, the cell must be able to accept a formula rather than being locked or formatted as text.

For a check mark character: Excel’s Symbol command, a check mark to copy, or a cell for the formula.
For a clickable checkbox: a version of Excel that includes the newer in-cell Checkbox feature. If the command is not available, use one of the other methods or update Excel if your organization allows it.

Step-by-Step

Insert a check mark with the Symbol command. Select the cell where you want the mark, then choose Insert > Symbol on the ribbon. In the Symbol dialog, choose a font such as Segoe UI Symbol. Find and select a check mark, such as ✓ or ✔, then click Insert and close the dialog. If the dialog offers a character code field, choose Unicode (hex) and enter 2713 for ✓ or 2714 for ✔. Confirm that the selected character is the one you want before inserting it.

The symbol is placed in the active cell as text. You can change its size, color, alignment, or font using the Home tab just as you would for other cell contents. If the dialog stays open after insertion, you may be able to insert the same mark into additional selected cells by repeating the Insert action; otherwise, close it and repeat the command for another cell.
Copy and paste a check mark. Copy one of these characters: ✓ or ✔. Select the target cell in Excel and press Ctrl+V on Windows. On a Mac, use Command+V. You can also paste the character directly into the formula bar when the cell is selected. This is often the fastest option for a one-off mark, and it works in Excel for the web when the Symbol dialog is unavailable.

If you want the mark in several cells, copy the cell after pasting and paste it into the other destinations. To fill a range without overwriting existing data, paste only into the intended blank cells. A pasted character is not a checkbox: it will stay visible until someone edits or deletes the cell.
Generate the mark with a formula. To put a formula-generated check mark directly in A1, select A1 and enter =UNICHAR(10003). The formula returns ✓, the Unicode character U+2713. For a heavier check mark, enter =UNICHAR(10004), which returns ✔. These formulas work in current Excel versions that support UNICHAR, including Microsoft 365.

Press Enter to see the result. The formula remains in the cell, so you can copy it to other cells or use it as part of a larger formula. UNICHAR returns text, not a clickable control, and the displayed shape can vary with the font. If the cell shows the formula itself instead of a mark, check the troubleshooting section below.
Add an in-cell checkbox when people need to mark items complete. Select the cell or range where the checkboxes should go, then choose Insert > Checkbox. Excel adds a checkbox to each selected cell. Click a box to toggle it between checked and unchecked. This feature is available in supported Microsoft 365 builds; if you do not see the command, it may not have reached your installation or may be disabled by your organization.

Unlike a check mark character, an in-cell checkbox is interactive and its cell value is TRUE when checked and FALSE when unchecked. You can refer to that value in formulas—for example, to count checked items—or use it in a completion workflow. If you only want a printed mark that cannot be toggled, use Symbol, paste, or UNICHAR instead.

Common Mistakes

Confusing a check mark with a checkbox. A pasted, inserted, or formula-generated check mark is just text. It does not toggle when clicked. Use Insert > Checkbox if the user needs to change a task’s checked state.
Choosing a font that cannot display the character. A cell can contain a valid check mark but show a box or an unexpected symbol if its font lacks that glyph. Try Segoe UI Symbol or another Unicode-capable font, and check the cell in the workbook’s intended environment.
Typing the Unicode number into the cell as if it were a formula. Entering 2713 by itself displays the number, not a check mark. Use the Symbol dialog’s character code option, paste the actual character, or use the UNICHAR formula.
Overwriting data while filling a range. Selecting a large range before pasting can replace existing cell contents. Check the selection first, and use a blank helper column if the target cells already contain data.
Expecting a formula result to be permanent text. A UNICHAR formula displays a mark but remains a formula. If you need a fixed character, copy the cell and use Home > Paste > Values where available, or paste the mark directly into the destination.

Tips

Choose one style and use it consistently. The thin ✓ and heavier ✔ can look noticeably different in the same worksheet, especially beside ordinary text. For a checklist intended for printing, try both, then check the print preview so the mark remains legible at the chosen page scale.

Adjust the cell rather than inserting spaces to position the symbol. Use the alignment controls on the Home tab to center it, and adjust row height or column width if it looks cramped. Enlarging the font can make the mark easier to see, but a large character may be clipped if the row is too short.

For a list that changes over time, consider keeping status separate from descriptive text. For example, put the task in one column and the check mark or checkbox in the next. This makes it easier to filter, sort, or count completion states without mixing symbols into the task names. If you use the Checkbox feature, its TRUE or FALSE value can support formulas and other workbook logic.

When sharing a workbook, think about where it will be opened. A Unicode check mark usually travels well, but its appearance depends on the recipient’s fonts and software. A formula using UNICHAR requires a version that supports that function. A newer checkbox feature may not behave the same in older Excel releases or other spreadsheet apps, so test a shared copy if compatibility matters.

Troubleshooting

The Symbol command is missing or looks different. Make sure you are using the desktop Excel app and have the Insert tab selected. Dialog layouts can vary by platform and update. On Excel for the web, copy and paste a check mark or use a formula as an alternative. On Mac, choose Insert > Symbol if available; the character picker and controls may look different from Windows.
The cell displays a square, question mark, or blank space. The selected font may not contain the character. Select the cell, switch its font to Segoe UI Symbol or another Unicode font, and try inserting or pasting the mark again. If the mark appears on your computer but not another, the other device may lack a compatible font or use a different rendering engine.
The formula appears literally, such as =UNICHAR(10003). The cell may be formatted as Text, or Excel may be treating the entry as text. Change the cell format to General using Home > Number Format, then edit the cell and press Enter. If a leading apostrophe was typed before the equals sign, remove it.
Excel reports an error for UNICHAR. Check that the formula is typed exactly as shown and that the parentheses are present. If your Excel version does not support UNICHAR, use the Symbol command or paste the character instead. Also check whether the workbook is open in an older spreadsheet program that does not recognize the function.
You cannot find Insert > Checkbox. The in-cell checkbox feature may not be available in your Excel build, or an administrator may control updates. Check for Office updates if appropriate, then reopen Excel. If the option remains absent, use a check mark character for a static list or ask your organization’s administrator about feature availability.

Frequently Asked Questions

What is the fastest way to insert a check mark in Excel?

For a single mark, copy ✓ from this page, select the cell, and paste. If you need a repeatable result in multiple cells, use =UNICHAR(10003) in each cell or copy the formula.

Can I insert a check mark using a keyboard shortcut?

Excel does not have one universal built-in keyboard shortcut for inserting a check mark across Windows and Mac. Copy and paste is dependable, while the Symbol dialog or UNICHAR formula avoids relying on a font-specific shortcut.

How do I make the check mark larger or change its color?

Select the cell and use the font size and font color controls on the Home tab. The mark is text, so those formatting controls apply to it. Increase row height or column width if the character becomes clipped.

Can I count checked boxes?

Yes. In-cell checkboxes store TRUE when checked and FALSE when unchecked, so a formula can count the TRUE values in their range. A check mark entered as text is not automatically treated as a checked checkbox and needs a text-based count instead.

Will a check mark display in Excel for the web?

Usually, yes, if the workbook contains a supported Unicode character and the browser can render it. If you cannot access the Symbol dialog in the web app, paste the mark or enter a supported UNICHAR formula. Interactive checkbox availability can depend on the web version and rollout.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.