How To Do Check Mark In Excel

To do a check mark in Excel, use the Wingdings font and type the letter “a” to get the check mark symbol.

To do a check mark in Excel, use the Wingdings font and type the letter “a” to get the check mark symbol.

Excel is a powerful tool that allows you to perform an array of functions and calculations to streamline your data management. One commonly used feature in Microsoft Excel is the ability to add check marks to your spreadsheets. Whether you want to mark completed tasks, track progress, or simply categorize data, knowing how to add check marks in Excel can be incredibly useful. In this blog post, we will guide you through the various methods to add check marks in Excel, providing you with the knowledge and tools to effectively utilize this feature in your spreadsheets. So, let’s dive in and learn how to do check marks in Excel!

How To Do Check Mark In Excel: Step-by-Step


Step 1: Setup Excel for using Symbols

To insert a check mark in Excel, make sure symbols are enabled. If the check mark is not available, install extra language support.

Next Step

Step 2: Select the Cell

Click on the cell where you want to insert the check mark, which is a symbol typically used to indicate completion or affirmation in spreadsheet applications.

Next Step

Step 3: Open the Symbol Dialog Box

To insert symbols in Excel, go to the ‘Insert’ tab on the ribbon, then click ‘Symbol’. This opens a dialogue box with a comprehensive list of all the symbols that Excel supports.

Next Step

Step 4: Find the Check Mark Symbol

The ‘Symbol’ dialog box allows you to choose different fonts for symbols. By selecting “Wingdings” from the ‘Font’ menu and scrolling, you can find the check mark symbol, typically represented by the character code 252.

Next Step

Step 5: Insert the Check Mark

Once you have located the check mark, simply click on it, followed by the ‘Insert’ button. The check mark will then be seamlessly added into the desired cell. Finally, close the Symbol dialog box.

Next Step

Step 6: Format the Check Mark (Optional)

In Excel, you can easily customize the appearance of a check mark by applying formatting techniques such as bolding, resizing, or changing its color, treating it just like any other text in a cell.


In conclusion, learning how to insert check marks in Excel can be incredibly useful for tracking progress, ensuring accuracy, and enhancing data presentation. With the various methods provided in this blog post, you now have the flexibility to choose the approach that suits your needs best. Whether it’s using a symbol from the Insert tab, leveraging conditional formatting, or employing custom formatting codes, you can impress your colleagues and improve your spreadsheet skills. So go ahead and start incorporating check marks into your Excel documents, and watch your data management become more efficient and visually appealing. Happy Excel-ing!

Table of Contents