Knowing how to insert a check mark in Excel is a valuable skill to have, especially if you want to add a more professional, organized, and clean-cut look to your spreadsheets. Accessing check marks in Excel isn't intuitive as it should be, but we're here to help.
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.
1. Place the cursor in the cell where you'd like to insert a check mark.
2. 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.
3. Press "ALT + P". A check mark should appear.
How to insert a check mark in Excel (dialog box)
1. Click on the cell that you'd like to insert the check mark into.
2. Open the "Insert" tab and click on "Symbol."
2. When the Symbol dialog box pops up, type in "Wingdings 2" into the "Font" field.
3. You'll find two check mark symbols that you can use on Excel.
4. 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.
1. Choose a cell where you'd like to insert your check mark.
2. 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)
3. Hit "Enter" and the check mark should appear.
Stay in the know with Laptop Mag
Get our in-depth reviews, helpful tips, great deals, and the biggest news stories delivered to your inbox.
Kimberly Gedeon, holding a Master's degree in International Journalism, launched her career as a journalist for MadameNoire's business beat in 2013. She loved translating stuffy stories about the economy, personal finance and investing into digestible, easy-to-understand, entertaining stories for young women of color. During her time on the business beat, she discovered her passion for tech as she dove into articles about tech entrepreneurship, the Consumer Electronics Show (CES) and the latest tablets. After eight years of freelancing, dabbling in a myriad of beats, she's finally found a home at Laptop Mag that accepts her as the crypto-addicted, virtual reality-loving, investing-focused, tech-fascinated nerd she is. Woot!