Character Code for Check Mark in Excel (2 Applications)

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.

📌 Steps:

  • 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.

Character Code for Check Mark in Excel

  • 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.

Character Code for Check Mark in Excel

  • 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.

📌 Steps:

  • 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.

Using CHAR Function

  • Secondly, you have to type the following formula in cell C5 to insert a check mark.

=CHAR(252)

  • Next, press Enter.
  • As a consequence, you will get the following types of checkmarks in cell C5.

Character Code for Check Mark in Excel

  • 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.

=CHAR(254)

  • 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.

Character Code for Check Mark in Excel


Similar Readings


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.

📌 Steps:

  • 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.

Using Keyboard Shortcut

  • 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.

Character Code for Check Mark in Excel

  • Utilizing the above keyboard shortcut, we can complete a dataset of daily tasks and their status (completed or uncompleted) with checkmarks as shown below.

Character Code for Check Mark in Excel


Conclusion

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!


Related Articles

Saquib
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo