How To Insert Check Marks In Excel (In Easy Steps)

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.

1. Select cell A1 and press SHIFT + P to insert a capital P.

2. 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.

3. 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.

4. To insert a fancy red X, press SHIFT + O to insert a capital O and change the font color to red.

5. 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.

6. On the Insert tab, in the Symbols group, click Symbol.

7. 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.

8. Or simply select this check mark: ✓, right click, and then click Copy (or press CTRL + c), open Excel, select a cell, and press CTRL + v.

Note: on the Home tab, in the Alignment group, use the Align buttons to center the check mark horizontally and vertically.

9. The formula below returns a check mark if the price is greater than 500.

Note: you can paste the check mark (✓) directly into the formula bar. If you're interested, you can also download the accompanying Excel file.

Checkboxes

Did you know you can use the Developer tab to add clickable checkboxes in Excel? It’s a simple way to create interactive and amazing spreadsheets.