A tick mark or checkmark is a symbol inserted into a cell to confirm something or show that something is applicable. If you are looking for special tricks to use character code for inserting a check mark in Excel, you’ve come to the right place. There are two ways to use character code for inserting a check mark in Excel. This article will discuss every step of these methods to use character code for inserting a check mark in Excel. Let’s follow the complete guide to learn all of this.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try yourself while you go through the step-by-step process.
How Can We Find Character Code for Check Mark in Excel?
To insert a checkmark using character code, at first we have to find out the character code in Excel. You have to follow the following process to find out the character code.
- Firstly, select the cell you want to insert the check mark. Then, go to the Insert tab, and select Symbols. Click on the Symbol from the drop-down menu.
- As a consequence, a Symbol dialog will appear.
- Then, change the font to Wingdings.
- Next, select the Checkmark.
- As a consequence, you will get the code in the Character code box.
- Next, you have to follow the above process to get the other character code as shown below.
- Finally, you will get the following character code for the checkmark in Excel.
By following the above method, you will be able to find out the character code for inserting the checkmark in Excel. It is also possible to get the character for a cross mark in Excel by following a similar procedure.
2 Applications of Character Code for Inserting Check Mark in Excel
In the following section, we will use two effective and tricky methods to use character code for inserting a checkmark in Excel. we illustrate the use of the CHAR function to insert a checkmark in this article. In the second method, we use a keyboard shortcut to insert a check mark. This section provides extensive details on these methods. You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference.
1. Using CHAR Function
There is no difference between inserting a checkmark in a cell and inserting any other type of text. The checkmark is copied when you copy the cell, and it is deleted when you delete the cell. By changing the color and font size, you can format it like regular text. Here, we will demonstrate how to use character code for inserting checkmarks in Excel. In this method, we use the CHAR Function to insert a checkmark in an empty cell. Let’s walk through the following steps to use character code for inserting checkmarks in Excel.
- To begin with, select the cell you want to insert the checkmark. For instance, we have selected cell C5 in the example.
- Now, change the font to Wingdings.
- Secondly, you have to type the following formula in cell C5 to insert a check mark.
- Next, press Enter.
- As a consequence, you will get the following types of checkmarks in cell C5.
- Next, select cell C6 to insert the check mark.
- Now, following the previous process, you have to alter the font to
- Afterward, you have to type the following formula in cell C6 to insert a check mark.
- Next, press Enter.
- As a consequence, you will get the following types of a checkmark in cell C6.
- Here, we have a dataset of daily tasks and their status (completed or not).
- Lastly, follow the same process to fill the Status column cells with checkmarks. Or you can copy cell C5 or cell C6 and paste in the Status column cells to insert checkmarks.
- How to Filter Special Characters in Excel (An Easy Guide)
- Apply Formula to Identify Special Characters in Excel (4 Methods)
- How to Set Character Limit in Excel
- Find Special Characters in Excel (3 Easy Methods)
- How to Check Character Limit in Excel (With Easy Steps)
2. Using Keyboard Shortcut
Isn’t it wonderful to have keyboard shortcuts to insert checkmarks in Microsoft Excel? You’re in luck since our next is the answer to your question. Here, we have a dataset of daily tasks and the status of those tasks (completed or uncompleted). Let’s walk through the following steps to use character code for inserting checkmarks in Excel.
- At first, select the cells you want to insert the check mark. Here, we have selected cell C5.
- Secondly, change the font in the selected cell to Wingdings.
- Next, the keyboard shortcuts for inserting check marks are shown below.
- Afterward, press and hold the Alt key and type 0252 or 0254 to get the checkmark in cell C5 or C6.
- Utilizing the above keyboard shortcut, we can complete a dataset of daily tasks and their status (completed or uncompleted) with checkmarks as shown below.
That’s the end of today’s session. I strongly believe that from now you may be able to use character code for inserting a checkmark in Excel. If you have any queries or recommendations, please share them in the comments section below.
Don’t forget to check our website ExcelDemy for various Excel-related problems and solutions. Keep learning new methods and keep growing!
- How to Insert Character Between Text in Excel (5 Easy Methods)
- Check If Cell Contains Special Character in Excel (2 Ways)
- How to Add a Character in Excel to Multiple Cells (5 Easy Ways)
- Convert Special Characters in Excel (6 Easy Ways)
- How to Add Characters in Excel Formula (4 Simple Methods)
- Find Special Characters Using VBA in Excel (3 Quick Ways)