Shortcut 2: We may press the “Shift + R” keys to insert the checkmark inside a square box. Shortcut 1: We must press the “Shift + P” keys to insert the tick mark symbol in Excel. There are two shortcuts for checkmarks in “Wingdings”. The “Font” settings are that the font style should be “Wingdings 2 “or “Webdings. The cell or column of cells where we want to insert a checkmark needs to have the “Font” settings in the “Home” tab. 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 As a result, the symbol we typed will be displayed in the desired cell. Step 2: We must click and hold the “ALT” key while typing the character code. Then, we will go to the “Home” tab and change font settings to “Wingdings.” Step 1: We must place the cursor in the cell where we want to insert a check mark. All the data above 45 shows the check mark for all other data less than 45, it displays an exclamatory symbol. In the above example, the condition taken is salary > = 45. We can use the check mark to validation of the data in Excel Validation Of The Data In Excel The data validation in excel helps control the kind of input entered by a user in the worksheet. In the above example, the data in Excel is represented as different points by using the tick mark. It can be illustrated in the below example. The check marks/tick marks can be used as buttons to style our writing content. You can also format and change the font size and color like normal text. Moreover, you can also delete a check mark when we delete a cell. You can also copy a check mark when we copy a cell. The third is when we change the font to “Wingdings 2” and press the keyboard shortcut “SHIFT+P.”įor example, suppose you insert a check mark as a symbol in a cell, just as in normal text. The second option is inserting a symbol from the insert tab.

The first is just copying a tick mark and pasting it into Excel.

There are three simple methods to insert a checkmark in Excel.

Remember, it is different from the checkbox. What is Check Mark/Tick (✓) Symbol in Excel?Ī check mark in Excel shows whether or not a given task is done.

Finding hidden characters in excel