Checkmark in Excel (Table of Contents)
- Checkmark in Excel
- How to use Tick mark in an Excel sheet?
- How to insert Tick mark using CHAR Function?
- How to insert Checkmark in excel with AutoCorrect?
Checkmark in Excel
Check Mark in Excel is a kind of marking type which is used as a character into a cell. This becomes applicable only if we have selected the Wingdings2 fonts in Excel, mainly used for creating the marks. If we want to create Checkmark into a cell, we need to type Shift + P or we can directly use capital P which will return Checkmark. Even if we are using the correct alphabet or character under Wingdings2 fonts, but the font size (Upper or Lower Case) is not properly used, we will end up getting a different mark.
Let’s see how to insert checkmark or tick mark in excel.
A tick mark can be inserted into a cell to convey the result of “yes” as an answer to some questions or the option “yes” applies here. There are two types of checkmarks in excel.
- Interactive check box – Conveys a message to the next level
- Tick symbol – Is a Special symbol
Checkmark in Excel – Example #1
The sheet represents a status of which all are the tasks are completed. The complete details are mentioned in the sheet and in the status column tick mark is given to mention which are the completed tasks. When the sheets contain complex data, it is easy to use tick mark instead of using any other comments.
- Select the cell in the status column where you want to insert the tick mark.
- Go to insert Menu click on symbols option. You will get the list of symbols in the dialog window.
- From the symbol dialog window use the drop-down arrow to select the font Wingdings.
- With the dialog window, you can see different symbols. Select the tick mark and click on insert button to insert the symbol to the selected cell.
- Press the cancel button to hide the dialog window.
Checkmark in Excel – Example #2
Instead of tick mark, we can use tick box or checkbox to represent an option selected. This checkmark box can be used to show a Yes, this applies. Along with this, a cross mark is also used to indicate some incorrectness. Here the task which is completed is indicated by the tick box.
- Select the cell in the status column where you want to insert the checkbox. Go to insert Menu click on symbols option. You will get the list of symbols in the dialog window. (As shown in the above steps)
- From the Symbol dialog window use the drop-down arrow to select the font “Wingdings” (As shown in the above steps)
- With the dialog window, you can see different symbols. Select the check mark symbol and click on the insert button to insert the symbol to the selected cell.
- Press the cancel button to hide the dialog window.
How to Use Tickmark in an Excel Sheet?
The simple way is to insert the tick mark symbol from Symbols option.
- Select the particular cell where you want to insert the tick mark symbol.
- Go to the menu bar and select the insert option.
- From Insert menu, go to symbol option.
- From the Symbol dialog window use the drop-down arrow to select the font “Wingdings”
- With the dialog window, you can see different symbols. Select the tick mark and click on insert button to insert the symbol to the selected cell.
- Press the cancel button to hide the dialog window.
The same is shown in the figure where you can see the tick mark is being selected and the same will be added to the “Recently Used Symbols” list.
How to insert Tick mark using CHAR Function?
It is possible to insert the tick mark in excel or checkbox using the char function which is a built-in function in the excel. This is a simple way to those who commonly use formulas more in excel.
While selecting the symbol in the dialog window you can see excel is generating character code for each and every symbol.
For example, the Character code for tick mark is 252.
Use the formula =CHAR (252) to get the tick mark in the selected cell. Make sure that the font of the cell should be Wingdings.
Use the below symbol code for inserting different symbols using CHAR function.
How to insert tick mark in excel using keyboard shortcuts?
The symbols can be inserted in excel using some keyboard shortcuts. It is commonly a combination of the shift key and an alphabet. Before applying the shortcuts, the cells should apply “Windings 2” or “Webdings” font to get the below-given results.
This is also a simple method to insert the tick mark symbol in the cell where you want. Once you apply any of the mentioned fonts, press the shift key along with alphabet P. you can see the tick mark will be appearing on the selected cell.
How to insert checkmark in excel with AutoCorrect?
This is another option on how to insert checkmark in excel. When you want to regularly use this symbol this will be the easy way to insert the checkbox.
- Insert the tick mark symbol from symbols followed by insert menu
- Select the particular cell and copy the symbol from the formula bar
- Select the” ü” symbol and press “Ctrl + C” to copy it.
- Note the font type that is being selected this will be needed while you are auto-inserting the tick mark.
- Go to the File menu then select options.
- Select “proofing “from the dialog window also select the Autocorrect Options
- Once you go through the Autocorrect option you will get another dialog box.
- In the “Replace” box type the word which you want to use instead of tick mark.
- In the “With” box paste the copied symbol ” ü” (Ctrl + V)
- Press on Add button then click OK
By following the mentioned steps, the tick mark symbol is auto-corrected. After completing this when you want to put a tick mark on excel cell, go with the following steps.
- Type the word which you linked with the check mark (Eg: tick mark) and press enter.
- The symbol” ü” will appear in the cell. To change it into tick mark, apply the proper font (i.e: Wingdings) to the cell.
The benefit of using this method is you can associate the word you want to with particular symbol and which you can remember easily. Once you configure the Autocorrect option you can add the symbol anytime by typing the associated word.
Things to Remember about the Checkmark in Excel
- The symbol font should be in “Wingdings” in the dialog window when selecting from insert symbol options.
- While using the character function ensure the selected cells should be in “Wingdings” font to get the expected result.
- Use the Autocorrect method if you are regularly using the same type of symbols.
- To find the character code for the symbol select the symbol from the symbol window and check the corresponding character code in the box given at the end of the symbol window.
Recommended Articles
This has been a guide on Checkmark in Excel. The easiest way to adjust a column is to use the Checkmark in Excel. Here we also discuss how to insert Checkmark in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –
