What is Check Mark/Tick (✓) Symbol in Excel?

A check mark in Excel shows whether or not a given task is done. Remember, it is different from the checkbox. There are three simple methods to insert a checkmark in Excel. The first is just copying a tick mark and pasting it into Excel. The second option is inserting a symbol from the insert tab. The third is when we change the font to “Wingdings 2” and press the keyboard shortcut “SHIFT+P.”

For example, suppose you insert a check mark as a symbol in a cell, just as in normal text. You can also copy a check mark when we copy a cell. Moreover, you can also delete a check mark when we delete a cell. You can also format and change the font size and color like normal text.

The check marks/tick marks can be used as buttons to style our writing content. It can be illustrated in the below example.

In the above example, the data in Excel is represented as different points by using the tick mark.

We can use the check mark to validation of the data in ExcelValidation Of The Data In ExcelThe data validation in excel helps control the kind of input entered by a user in the worksheet.read more. Here is the below example.

In the above example, the condition taken is salary > = 45. All the data above 45 shows the check mark; for all other data less than 45, it displays an exclamatory symbol.

How to Make a Check Mark in Excel?

Top 7 Ways to Put Check Mark (✓ Tick) in Excel

We know that Microsoft Office supports many symbols in Excel. The checkmark is also one of the symbols.

  • A check mark is a wonderful option in Microsoft Excel. It is present in the “Insert ” Tab and the “Symbols” field. If we click on the “Symbols,” a dialogue box is displayed below. After inserting the (✓) in the required cell, we can change the text associated with the check mark.Users can change the user-defined text for the check mark field. The following process can do this. After inserting the checkbox from the “Developer” option, right-click on the checkbox cell and select the “Edit Text” option. Write the user-defined text in the place of the checkbox text. The Excel tick marks are used to create checkboxes, and the checklist is used for selecting single or multiple options at a time.

After inserting the (✓) in the required cell, we can change the text associated with the check mark.Users can change the user-defined text for the check mark field.

After inserting the checkbox from the “Developer” option, right-click on the checkbox cell and select the “Edit Text” option.

The Excel tick marks are used to create checkboxes, and the checklist is used for selecting single or multiple options at a time.

Go to the “Insert” tab and select the “Symbols “option.

A dialogue box will appear, as shown in the below figure.

From the “Font” option, we must select the “Wingdings” font. As a result, you may find many symbols and drag the scroll bar to the end. In addition, you may find two check marks or tick marks in Excel.

The next is the character code. The check mark’s character codes are “252 “and “254”. Now, it is time to choose the symbol we want, i.e., if the user wants only a tick mark in Excel, then “252” is the character code.

Or, if the user wants to use a check mark inside a square box, then “254” is the character code.

#2 – Using the Character Code

Step 1: We must place the cursor in the cell where we want to insert a check mark. Then, we will go to the “Home” tab and change font settings to “Wingdings.”

Step 2: We must click and hold the “ALT” key while typing the character code. Then, release the “ALT “key. As a result, the symbol we typed will be displayed in the desired cell.

The character code of the tick symbol is “0252,” and the character code of the checkmark in the square box is “0254.”

#3 – Use a Keyboard Shortcut Excel key to Insert Tick Mark

The cell or column of cells where we want to insert a checkmark needs to have the “Font” settings in the “Home” tab. The “Font” settings are that the font style should be “Wingdings 2 “or “Webdings.“

There are two shortcuts for checkmarks in “Wingdings”. There are as follows.

Shortcut 1: We must press the “Shift + P” keys to insert the tick mark symbol in Excel.

Shortcut 2: We may press the “Shift + R” keys to insert the checkmark inside a square box.

The Excel shortcutsExcel ShortcutsAn Excel shortcut is a technique of performing a manual task in a quicker way.read more for check marks in the “Webdings” font style. We should follow the above rule of font settings like the “Wingdings.”

Keyboard shortcut: “a” is the shortcut for a checkmark in this font style.

#4 – Using Char Functions

Microsoft Excel supports many functions in addition to formulas and shortcuts.

Char() is the function in ExcelChar() Is The Function In ExcelThe character function in Excel, also known as the char function, identifies the character based on the number or integer accepted by the computer language. For example, the number for character “A” is 65, so if we use =char(65), we get A.read more that can display the characters, special symbols, etc., whenever necessary.

Example: char(252)

=IF(C2=0, CHAR(252),"")

#5 – Using the Option in Conditional Formatting

For this, select the“ Home” tab, then go to conditional formattingGo To Conditional FormattingConditional formatting is a technique in Excel that allows us to format cells in a worksheet based on certain conditions. It can be found in the styles section of the Home tab.read more, and in the drop-down, select the “Icon Sets” option.

Then you can see the check marks in your data according to the conditions.

#6 – Using the ASCII Code

The ASCII code of the check mark is obtained using the ASCII character. For example, the ASCII character of the checkmark is Ü, and the ASCII code of the checkmark is 252.

#7 – From the Bullet Library

We can find the tick mark symbol in Excel’s “Bullet Library.”

That can be used as a bullet option.

Go to the Home tab -> Bullet Library -> select Tick Mark.

The behavior of the Tick (✓) symbol in Excel>

  • Like the normal text and other numeric characters, the symbols behave similarly.We can make the check mark “Bold “or “Italic “by applying the styles.We can fill the cell color with the required color.We can change the tick mark color to another by changing it from the home tab.Like the check mark in Excel, we can use another option manually and check that option whenever necessary. That is called a checkbox.

Things to Remember

  • Unlike Radio buttons in ExcelRadio Buttons In ExcelIn Excel, radio buttons or options buttons record a user’s input. They can be found in the developer’s tab’s insert section. read more, we can select this check mark in multiple numbers.We can use this check mark to fill out any survey or application forms to choose the criteria.The checkmark is also used to determine the compulsory options while reading the privacy policy.

This article is a guide to Check Mark in Excel. We discuss the methods to insert check mark/tick mark in Excel, examples, and a downloadable template. You may learn more about Excel from the following articles: –

  • Match Data in ExcelFormat in ExcelExcel Add Months to DateHow to Remove Watermark in Excel Sheet?