In this Excel tutorial, you will learn how to insert the check mark symbol in Excel.

Inserting check mark symbols in Excel can be helpful for various purposes, from marking completed tasks to enhancing the visual appeal of your spreadsheet. There are a few ways to insert the check mark symbol into your spreadsheet.

Using the Symbol Dialog Box

This method involves using the Symbol dialog box to insert the check mark symbol into a cell in your spreadsheet.

Navigate to the Insert tab on the ribbon. Click the Symbol button.

Change Font to Wingdings2 (or Marlett). Here you can find two different check symbols: check mark and the box check mark. You will find these checks in the third row.

If you’re not sure which font to use, you can scroll through the list of symbols until you find the check mark symbol, or you can search for it using the search box.

The character codes for them are 82 and 84.

There is also a possibility to insert a bold check mark and a bold box check mark. To insert one of these, change the font to Wingdings and scroll down to the last row.

The character codes for them are 252 and 254.

Using an Excel Font

You can just insert check mark symbols using a Font. Just change it to Wingdings2 and type uppercase P (SHIFT + P) for the check mark and uppercase R (SHIFT + R) for the box check mark.

Using Character Codes

You can also insert check mark symbols in Excel by using the Character Map Windows application or character code. Just open the Character Map, change the Font to Wingdings, find the check symbols, and copy them. Then you can paste them into your Excel spreadsheet.

Character codes for check marks are 0xFC for the check mark and 0xFE for the box check mark.

Using the Keyboard Shortcut

This method involves using a keyboard shortcut to insert the check mark symbol into a cell in your spreadsheet. This is a good option if you need to insert a lot of check marks in your spreadsheet and you prefer to use the keyboard.

1. Select the cell where you want to insert the check mark symbol.
2. Press the keyboard shortcut ALT + 0252. The check mark symbol will be inserted in the selected cell.

Using Autocorrect

This method involves using Autocorrect to automatically replace a keyword with the check mark symbol in your spreadsheet. This is a good option if you need to insert a lot of check marks in your spreadsheet and you prefer to type a keyword instead of using the mouse or keyboard shortcut.

1. Go to the File tab and select Options.
2. In the Excel Options dialog box, select the Proofing option.
3. Click on the AutoCorrect Options button.
4. In the AutoCorrect dialog box, enter a keyword for the check mark symbol in the Replace field (e.g., “check”).
5. Enter the check mark symbol in the With field (using the Symbol dialog box method described above).
6. Click the Add button and then the OK button to close the AutoCorrect dialog box.
7. Now, whenever you type the keyword you entered (e.g., “check”), it will be automatically replaced with the check mark symbol.

Now you can tick the value in the cell to make your spreadsheet easier to read and notice things.

Related posts:

How To Insert Variance-Covariance Matrix Guide to Counting Cells Not Equal to a Specific Value in Excel How to Move Rows in Excel