Excel Checkmark Keyboard Shortcuts: Windows, Mac, and Web

In Excel for Microsoft 365 on Windows, the quickest keyboard method is to select a cell, choose the Wingdings font, then hold Alt and type 0252 on the numeric keypad; the character appears as a checkmark. For a checkmark that does not depend on a special font, use Insert > Symbol and insert the Unicode check mark (✓), or copy and paste it into a cell.

What the Excel checkmark shortcut actually does

The familiar Alt+0252 method is a character-code shortcut, not a dedicated Excel command for inserting a checkmark. Windows enters the character ü when you type 0252 with the numeric keypad. Wingdings displays that character position as a checkmark, so the selected cell must use the Wingdings font for the result to look right.

To use it reliably, select the destination cell and set its font to Wingdings on the Home tab before entering the code. Hold down Alt, type 0252 using the numeric keypad, and release Alt. If you type the code while using a regular font such as Aptos or Calibri, Excel may show ü rather than a tick. If your keyboard has no separate numeric keypad, this particular shortcut may be inconvenient or may not work as expected; use the symbol dialog or paste a Unicode checkmark instead.

Use the numeric keypad, not the number keys across the top of the keyboard.
Make sure Num Lock is on if your keyboard requires it for keypad number entry.
Set the cell’s font to Wingdings so the character is rendered as a checkmark.
For a portable symbol that keeps its appearance in ordinary fonts, insert ✓ as Unicode instead.

Because the Alt code depends on a legacy symbol font, it is best understood as a quick display trick rather than a universal checkmark shortcut. The underlying character and the visible mark are tied to the font mapping. That distinction matters when sharing a workbook, changing fonts, or copying the contents to another program.

Insert a checkmark with Excel’s Symbol dialog

The Symbol dialog is a dependable choice when you want a genuine Unicode checkmark and do not want to change the cell to Wingdings. In Excel for Microsoft 365 on Windows, select a cell, open Insert > Symbol, choose a Unicode-capable font such as Segoe UI Symbol, and find the check mark. You can enter 2713 in the Character code box with the character set set to Unicode (hex), then select the character and choose Insert. The standard check mark is ✓ (U+2713); the heavier check mark is ✔ (U+2714).

After inserting the symbol, close the dialog and check that the cell displays the mark in the font and size you want. You can format it like other cell text: change its font size, color, alignment, or number of decimal places is not relevant because it is text. If the dialog opens while you are editing text in a cell, the symbol is inserted at the text cursor; otherwise, it is entered in the selected cell.

The dialog is especially useful when a workbook will be opened on different computers. Unicode symbols are generally more portable than Wingdings character mappings, although the exact appearance can vary with the fonts installed on each device. Segoe UI Symbol is common on Windows, but another system may substitute a different font or render a slightly different design.

Copy and paste a checkmark

For a one-off mark, copying a symbol is often the simplest option. Copy ✓ from this page, select a cell in Excel, and paste. You can also copy ✔ if you prefer a heavier shape. The pasted mark is text, so you can edit or delete it as you would any other cell content. If Excel displays an unexpected box or question mark, try changing the cell font to a Unicode font such as Segoe UI Symbol, or use Insert > Symbol to choose a supported character.

When entering many marks, paste into the first cell and use the fill handle or copy and paste to distribute it. Be careful when pasting into a range that already contains data: ordinary paste can replace the existing cell contents. If the marks are meant to indicate completion, consider whether a checkbox or a separate status column would make the data easier to filter and maintain.

Windows, Mac, and Excel for the web

The Alt+0252 instruction is specifically a Windows numeric-keypad method. It is not a reliable Mac shortcut, and keyboard layouts without a physical keypad can require different steps. In Excel for Mac, use Insert > Symbol if that command is available in your version, or open the macOS Character Viewer with Control+Command+Space, search for “check mark,” and insert a suitable symbol. Copying and pasting ✓ is another straightforward option on Mac.

Excel for the web runs in a browser, so desktop character-entry behavior can depend on the operating system and keyboard. Copying and pasting a Unicode checkmark is a practical cross-platform approach. Availability and placement of symbol-insertion commands can also differ by Excel version and interface. When a command is missing, use a symbol copied from another source rather than assuming the Windows Alt code will work in the browser.

The checkmark itself is ordinary cell content, so a workbook containing Unicode marks can be opened on Windows, Mac, and the web. However, rendering depends on fonts and the cell’s formatting. If a mark is important to the meaning of a report, test how it looks in the environments where recipients will view the file, and include a text label such as “Complete” when clarity matters more than appearance.

Checkmark symbol or interactive checkbox?

A typed checkmark is a symbol: it communicates status visually but does not behave like a control. It cannot be clicked to switch between checked and unchecked states. If you need people to mark tasks as they complete them, an in-cell checkbox is more appropriate where that feature is available in your Microsoft 365 version. Select the target cells and use Insert > Checkbox. The checkbox is associated with a TRUE or FALSE value, which can be useful in formulas and summaries.

Do not confuse the in-cell checkbox with the older Form Control checkbox. A Form Control is an object placed over the worksheet and may need to be linked to a cell to expose its checked state to formulas. In-cell checkboxes are cell-based and work more naturally with ranges of data. Feature availability may vary with the Excel build and platform, so if Insert > Checkbox is not shown, use a text status such as Complete or a symbol-based alternative.

For a simple checklist that only needs to look finished, a checkmark is lighter and easier to print. For a shared task list that users will actively update, a checkbox or a status dropdown is usually more practical. Choose based on whether the mark is decoration, a record of a decision, or an input that other worksheet logic must read.

Use checkmarks in a status column

A dedicated status column makes a list easier to sort, filter, and review. For example, place task names in A2:A20 and status text in B2:B20, then add a checkmark in a separate column when a task is complete. This keeps the symbol from replacing the task name or obscuring other information. A text label alongside the mark can also help readers who use assistive technology or view the sheet in a font that renders symbols differently.

If you want Excel to show a checkmark based on a status value, put the formula in C2, assuming the task’s status is in B2 and the word Complete means finished, then fill the formula down:

=IF(B2="Complete","✓","")

For example, if B2 contains Complete, C2 displays ✓; if B2 contains In progress, C2 is blank. This uses a literal Unicode symbol, so it does not require Wingdings. A formula-generated mark updates when the status changes, unlike a manually typed mark, but it also means the mark is an output rather than a cell users should edit directly.

For larger worksheets, keep the underlying status consistent. Values such as Complete, Done, Finished, and Yes may all mean the same thing to a person but are different text to Excel. A dropdown list can reduce inconsistent entries. You can also filter the status column to show only unfinished tasks instead of relying on color or symbols alone.

Formatting, fonts, and common problems

If Alt+0252 produces ü, the code was entered but the cell is not displaying the character through Wingdings. Select the cell and change its font to Wingdings. If nothing appears, check that you used the numeric keypad and that Num Lock is enabled where needed. Laptops sometimes embed keypad functions in other keys; their behavior varies by model, so the Unicode Symbol dialog is often less frustrating.

If a symbol turns into a box after changing fonts or opening the file elsewhere, the chosen font may not contain or correctly map that character. Try a Unicode symbol inserted through the dialog instead of the Wingdings method. Also check whether the cell is too narrow, the font color matches the fill color, or conditional formatting is hiding the mark by changing its appearance.

Symbols are text, so alignment and cell formatting affect how they look. Set horizontal and vertical alignment to center if you want a neat checklist column. Avoid using a checkmark as the only indication of an important status: a printed copy may be grayscale, a symbol may be visually small, and some users may not interpret it consistently. Pair it with words or another clear cue when the status has operational or accessibility significance.

Choosing the right method

Use the Wingdings Alt code when you are on Windows with a numeric keypad and need a fast mark in a workbook that will retain Wingdings formatting. Use Insert > Symbol or paste ✓ when font independence and cross-platform readability matter. Choose an in-cell checkbox when users need to toggle a task’s state and the feature is available. These methods solve different problems; there is no single checkmark shortcut that is best in every Excel environment.

For a report that will be emailed or printed, test a few cells before filling a whole column. Confirm that the marks remain visible after saving, reopening, and viewing the workbook on the intended platform. If the workbook is business-critical, include an explicit status value or label so the meaning does not rely on a particular glyph. That small design choice makes the sheet more robust and easier to understand.

Frequently Asked Questions

What is the keyboard shortcut for a checkmark in Excel?

On Windows, use Alt+0252 on the numeric keypad with the cell formatted in Wingdings. It is a font-dependent character code, not a universal Excel checkmark command. For a standard Unicode checkmark, use Insert > Symbol or paste ✓.

Why does Alt+0252 type ü instead of a checkmark?

The code enters ü, and Wingdings changes how that character position looks. If the cell uses a standard font, you see ü. Change the cell’s font to Wingdings, or insert the Unicode checkmark instead.

Can I insert a checkmark in Excel on a Mac?

Yes. Use Insert > Symbol if available, use Control+Command+Space to open the macOS Character Viewer and search for a check mark, or copy and paste ✓. The Windows Alt+0252 keypad method is not the Mac equivalent.

Is a checkmark the same as a checkbox in Excel?

No. A checkmark is a text symbol and cannot be toggled by clicking. An in-cell checkbox, when available in your Excel version, can be checked or cleared and is associated with a TRUE or FALSE value.

Will an Excel checkmark display on another computer?

Unicode checkmarks usually travel more reliably than Wingdings-based marks, but their appearance depends on fonts available on the other computer. For a workbook shared across platforms, use a Unicode symbol or a checkbox and include a text status where the meaning must remain unmistakable.

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.