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.
Note: you can also insert a check mark symbol with a box around it (see picture above). After inserting one check mark, you can use the Recently used symbols to quickly insert another check mark.
You can easily insert a check mark (also known as a “tick mark”) in Word, Outlook, Excel, or PowerPoint.These marks are static symbols. If you’re looking for an interactive check box that you can click to check or uncheck, see: Add a check box or option button (Excel) or Make a checklist in Word.
Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Excel 2007 Word 2007 Outlook 2007 PowerPoint 2007
- 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:
Was this article helpful?