How to Insert a Check Mark in Excel

When you need to check things off

What to Know

  • Hands-down easiest option: Click the cell then select Wingdings 2 in the font menu. Click the cell again and press Shift+P.
  • Next easiest: Select the cell and click Insert > Symbol > Wingdings 2 or Segoe UI and select the check mark icon. Click Insert.

This article explains four different ways to insert a check mark into an Excel spreadsheet. Instructions apply to Microsoft Excel 365 and Excel 2019, 2016, and 2013.

How to Add a Check Mark Using a Keyboard Shortcut

Your keyboard is the quickest way to insert a check mark.

  1. Select the cell in Excel where you want to add the check mark.

  2. Using the Font drop-down menu, select Windings 2.

    The Excel font menu with Wingdings 2 selected
  3. Select the cell once again and press Shift+P.

How to Add a Check Mark in Excel Using Symbols

The next easiest method is to use the Insert menu.

  1. Open Microsoft Excel and select the cell where you want to add the check mark.

  2. Select Insert.

    The Excel Insert tab
  3. Select Symbol.

    Excel Symbol menu location
  4. Using the Font drop-down menu, select either Segoe UI Symbol or Wingdings.

    The Excel menu with Wingdings selected

    Each of these fonts has its own check mark icon, so it really depends on which font type you'd like to use.

  5. Select the check mark icon you'd like to use and take note of the Character code number.

    Wingdings check mark character code in Excel

    Each font type has a different character code for the check mark icon.

  6. Select Insert.

    Excel Symbol menu with Insert selected
  7. Select the X in the top right corner to close the Symbol window.

Insert a Check Mark in Excel Using the Character Code

Now that you have successfully added a check mark icon to your Excel spreadsheet using the Symbol menu, you can do so using the built-in Character function in Excel and the character code shown in the Symbol window.

  1. Select the cell where you want to insert the check mark and then select the Home tab.

  2. Using the Font drop-down, select the font type of the check mark you want to use.

    Excel font drop-down menu
  3. Once you've selected the Font, type =char(character code) in the cell where you want to insert the check mark, but replace "character code" with the actual code. For Segoe UI Symbol, use "E001." For Windings, use "252."

    Excel showing check mark made with character code

    If you need to add the check mark to multiple cells, you can just copy this cell and paste it over with the format included.

How to Add a Check Mark Using AutoCorrect

This method is a bit more complicated to set up, but it allows Excel to remember some of your preferences for future use.

  1. Insert a check mark using one of the methods detailed above.

  2. Copy the cell that has the check mark and note the Font type you are using.

  3. Select File > Options > Proofing > AutoCorrect Options.

    Excel autocorrect options
  4. In the "Replace" text field, enter the word you want to be replaced by the check mark icon and paste the value of the copied cell in the "With" text field.

    Excel Replace field
  5. Select Add.

    Add highlighted to save the check mark autocorrect
  6. Select OK.

    AutoCorrect window with OK selected
  7. Type the word you entered in Step 4 in the cell where you want to add the check mark and change the Font type to the one noted in Step 2.

Was this page helpful?