Fortunately, there are several ways that you can make check marks on Excel. You can use shortcuts or, if you prefer, navigate to a symbols dialog box manually and make Excel check marks that way. Without further ado, let’s check out how to make check marks in Excel.
How to insert a check mark in Excel (shortcut)
As mentioned, one way you can insert a check mark in Excel is to use a shortcut.
- Place the cursor in the cell where you’d like to insert a check mark.
- Change the font to Wingdings 2. And yes, it must be Wingdings 2. I don’t know why there are several variants of this weird font, but I digress.
- Press “ALT + P”. A check mark should appear.
How to insert a check mark in Excel (dialog box)
- Click on the cell that you’d like to insert the check mark into.
- Open the “Insert” tab and click on “Symbol.”
- When the Symbol dialog box pops up, type in “Wingdings 2” into the “Font” field.
- You’ll find two check mark symbols that you can use on Excel.
- Click the one you prefer and click on “Insert.”
How to insert a check mark in Excel (Unichar function)
Perhaps the easiest way to insert a check mark in Excel is to use the UNICHAR function, a formula that translates numeric codes into corresponding characters. There are four UNICHAR codes that can manifest check marks in Excel: 9745, 9989, 10003, and 10004. Here’s how to get started.
- Choose a cell where you’d like to insert your check mark.
- Type in “=UNICHAR” followed by one of the aforementioned codes wrapped in parentheses. For example, if you want to use the 10003 code, your input should look like the following: =UNICHAR(10003)
- Hit “Enter” and the check mark should appear.
