How to Insert a Check Mark in Microsoft Excel. Many times, symbols can be better visuals than letters or numbers. If you want to insert a check mark symbol into your Microsoft Excel spreadsheet, it takes only a few clicks.
While you can certainly use interactive checkboxes for things like creating a checklist in Microsoft Excel, you don’t always need that extra step or added work. You can simply place a checkmark next to something like a completed task, fulfilled order, or confirmed data.
Here is How to Insert a Check Mark in Microsoft Excel
To insert a check mark symbol in Excel, simply press SHIFT + P and use the Wingdings 2 font. You can also insert a checkbox in Excel.
- Select cell A1 and press SHIFT + P to insert a capital P.
- On the Home tab, in the Font group, select the Wingdings 2 font. To insert a fancy check mark, change the font color to green, change the font size to 12 and apply bold formatting.
- On the Home tab, in the Alignment group, use the Align buttons to center the check mark horizontally and vertically. Result. A check mark in Excel.
- To insert a fancy red X, press SHIFT + O to insert a capital O and change the font color to red.
- Now you can create a nice to-do list that uses check marks. Use CTRL + c and CTRL + v to copy/paste a check mark or red X. Instead of executing step 1 and 2, you can also use the Insert tab to insert a check mark symbol. Here you can find other symbols as well
- On the Insert tab, in the Symbols group, click Symbol.
- Select Wingdings 2 from the drop-down list, select a check mark and click Insert.
Insert a check mark symbol
- In your file, place the cursor where you want to insert the symbol.
- Open the Symbol dialog box:
- Word or Outlook: Insert > Symbols > More Symbols
- Excel: Insert > Symbols
- PowerPoint: Insert > Symbols > Symbol
The Symbols button
is on the far right end of the Insert toolbar tab.
- In the Font box, select Wingdings.
- In the Character code box at the bottom, enter: 252In the grid of symbols, the check mark
is selected. Another check-mark option
is available two squares away from it (character code 254).
- Select the check mark you want. Click Insert. Then click Close to dismiss the dialog box.
- Once the check mark has been inserted, you may change its size or color. Select the check mark, right-click it, and make your desired changes by using the floating toolbar:
More check marks to choose from
Another font, Segoe UI Symbol, has three checkmark options. You can opt for this font in step 3 of the procedure above, and you can substitute one of the following character codes in step 4.
Symbol | Character code |
---|---|
![]() |
2705 |
![]() |
2713 |
![]() |
2714 |