Tjuanmuda – You really need this easy, automatic check or checklist symbol in Microsoft Excel, I think.
There are two types of check marks in Excel, namely interactive check boxes and check symbols. Hmm, what is the difference between these two types of ticks?
A checkbox is a special control that allows you to select or deselect, i.e. check or uncheck, by clicking on it with the mouse.
The check symbol is a special symbol that can be entered into a cell (alone or in combination with other characters) to fill in the answer “yes”, “correct”, “no”, and so on. Sometimes, a cross (x) is also used for this purpose, but more often it indicates imprecision.
Because you already know the differences, you definitely already know which type you will need.
So, let’s go straight into the steps for making it!
How to Make a Check Mark or Symbol in Excel
There are several different ways to insert a check symbol in Excel. All of these tutorials are quick, easy, and work for all versions of Microsoft Excel 2016, Excel 2013, Excel 2010, Excel 2007 and lower.
1. How to Put a Check Mark in Excel Using the Symbols Command
The most common way to insert a tick symbol in Excel, as follows:
Select the cell where you want to insert the check mark.
Go to the Insert tab > select the Symbols group, and click Symbol.
In the Symbol dialog box, on the Symbols tab, click the drop-down arrow next to the Font box, and select Wingdings.
Some checkmarks and cross symbols can be found at the bottom of the list. Select the symbol as desired and click ‘Insert’.
Finally, click Close to close the Symbol window.
Tip: As soon as you select a particular symbol in the Symbol dialog window, Ms Excel will display a code in the Character code box at the bottom. For example, the character code of the check mark (âœ“) is 252, as shown in the image above. Knowing this code, you can easily write formulas to insert tick symbols in Excel or count tick marks in a selected range.Using the Symbol command, you can insert a check mark in an empty cell or add a check mark as part of the cell content, as shown in the following image:
How to Make a Check Mark in Excel Using the CHAR Function
This may not be a conventional way to add check marks or checklist marks in Excel, but if you like working with formulas, this might be interesting.
Of course, this method can only be used to insert check marks in empty cells, yes.
|Tick in a box
|Cross in a box
Simple formula to put a check mark in Excel:
=CHAR(252) or =CHAR(254)Tjuanmuda
To add a cross symbol, use one of the following formulas:
=CHAR(251) or =CHAR(253)Tjuanmuda
Note: For the check and cross symbols to display correctly, the Wingdings font must be applied to the formula cells.
After you paste a formula in one cell, you can quickly copy the check mark to another Excel cell as you normally would copy a formula in Excel.
Tip: To remove a formula, use the Paste Special feature to replace it with a value.
How: select the formula cell, press Ctrl + C to copy it, right-click the selected cell, then click Paste Special> Values.
3. How to Create a Check Symbol in Excel by Typing the Character Code
Another quick way to insert the check symbol in Excel is to type its character code directly in the cell while holding down the Alt key. The detailed steps are as follows:
- Select the cell you want to put a check mark on.
- On the Home tab, in the Font group, change the font to Wingdings.
- Press and hold ALT while typing one of the following character codes on the numeric keypad.
|Tick in a box
|Cross in a box
As you may have noticed, the character code is the same as the code used in the CHAR formula but for leading zeros.
Notes! For the character code to work, make sure NUM LOCK is active and use the numeric keypad rather than the numbers at the top of the keyboard.
So, that’s a tutorial on how to easily create a check symbol or checklist in Microsoft Excel automatically. Hopefully the tutorial above is useful for you!