How to Insert a Check Mark in Excel

When you need to check things off

Adding Checkmarks In Excel

In some cases, people use Microsoft Excel to create checklists. However, to create a useful checklist, one must know how to add a checkmark. Fortunately, adding a check mark in Excel is fairly straightforward, and there are multiple ways of doing so.

This article includes steps on how to add a checkmark in Microsoft Excel 365. These steps also apply to Microsoft Excel 2019, 2016, and 2013.

How to Add a Checkmark in Excel Using Symbols

  1. Open Microsoft Excel and select the cell where you would like to add the checkmark.

  2. Select Insert.

    Insert menu
  3. Select Symbol.

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

    Symbol menu

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

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

    Character code

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

  6. Select Insert.

    Insert
  7. Select the X in the top right corner to close the Symbol window.

Insert a Checkmark in Excel Using the Character Code

Now that you have successfully added a checkmark icon to your Excel spreadsheet using the Symbol menu, you can now 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 would like to insert the checkmark, then select the Home tab.

  2. Using the Font drop-down, select the font type of the checkmark you would like to use.

    Home > Font menu
  3. Once you've selected the Font, type "=char(character code)" in the cell where you want to insert the checkmark, but replace "character code" with the actual code. For Segoe UI Symbol, use "E001;" for Windings, use "252."

    Character code

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

How to Add a Checkmark Using a Keyboard Shortcut

  1. Select the cell where you want to add the checkmark.

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

    Windings 2
  3. Select the cell once again and press Shift+P.

How to Add a Checkmark 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 checkmark and note the Font type you are using.

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

    AutoCorrect Options
  4. In the "Replace" text field, enter the word you want to be replaced by the checkmark icon and paste the value of the copied cell in the "With" text field.

    Replace
  5. Select Add.

    Add
  6. Select OK.

    Okay
  7. Type the word you entered in step 4 under the cell where you want to add the checkmark and change the Font type to the one noted in step 2.