The tutorial shows six different ways to insert a tick in Excel and explains how to format and count cells containing checkmarks.
There are two kinds of checkmarks in Excel - interactive checkbox and tick symbol.
A tick box, also known as checkbox or checkmark box, is a special control that allows you to select or deselect an option, i.e. check or uncheck a tick box, by clicking on it with the mouse. If you are looking for this kind of functionality, please see How to insert checkbox in Excel.
A tick symbol, also referred to as check symbol or check mark, is a special symbol (✓) that can be inserted in a cell (alone or in combination with any other characters) to express the concept "yes", for example "yes, this answer is correct" or "yes, this option applies to me". Sometimes, the cross mark (x) is also used for this purpose, but more often it indicates incorrectness or failure.
There are a handful of different ways to insert a tick symbol in Excel, and further on in this tutorial you will find the detailed description of each method. All of the techniques are quick, easy, and work for all versions of Microsoft Excel 2016, Excel 2013, Excel 2010, Excel 2007 and lower.
The most common way to insert a tick symbol in Excel is this:
Tip. As soon as you've selected a certain symbol in the Symbol dialog window, Excel will display its code in the Character code box at the bottom. For example, the character code of the tick symbol (✓) is 252, as shown in the screenshot above. Knowing this code, you can easily write a formula to insert a check symbol in Excel or count tick marks in a selected range.
Using the Symbol command, you can insert a checkmark in an empty cell or add a tick as part of the cell contents, as shown in the following image:
Perhaps it's not a conventional way to add a tick or cross symbol in Excel, but if you love working with formulas, it may become your favorite one. Obviously, this method can only be used for inserting a tick in an empty cell.
Knowing the following symbol codes:
|Tick in a box||254|
|Cross in a box||253|
The formula to put a checkmark in Excel is as simple as this:
=CHAR(252) or =CHAR(254)
To add a cross symbol, use either of the following formulas:
=CHAR(251) or =CHAR(253)
Note. For the tick and cross symbols to be displayed correctly, the Wingdings font should be applied to the formula cells.
One you've inserted a formula in one cell, you can swiftly copy a tick to other cells like you usually copy formulas in Excel.
Tip. To get rid of the formulas, use the Paste Special feature to replace them with values: select the formula cell(s), press Ctrl+C to copy it, right-click the selected cell(s), and then click Paste Special > Values.
Another quick way to insert a check symbol in Excel is typing its character code directly in a cell while holding the Alt key. The detailed steps follow below:
|Tick in a box||Alt+0254|
|Cross in a box||Alt+0253|
As you may have noticed, the character codes are the same as the codes we used in the CHAR formulas but for leading zeros.
Note. For the character codes to work, make sure NUM LOCK is on, and use the numerical keypad rather than the numbers at the top of the keyboard.
If you do not particularly like the appearance of the four check symbols we have added so far, check out the following table for more variations:
|Shortcut||Tick symbol||Shortcut||Tick symbol|
|Shift + P||a|
|Shift + R||r|
|Shift + O|
|Shift + Q|
|Shift + S|
|Shift + T|
|Shift + V|
|Shift + U|
To get any of the above tick marks in your Excel, apply either Wingdings 2 or Webdings font to the cell(s) where you want to insert a tick, and press the corresponding keyboard shortcut.
The following screenshot shows the resulting checkmarks in Excel:
If you need to insert tick marks in your sheets on a daily basis, none of the above methods may seem fast enough. Luckily, Excel's AutoCorrect feature can automate the work for you. To set it up, perform the following steps:
Don't be discouraged by the appearance of the symbol in the formula bar, even if it looks differently from what you see in the screenshot above, it just means that you inserted a tick symbol using another character code.
Tip. Look at the Font box and make a good note of the font theme (Wingdings in this example), as you will need it later when "auto-inserting" a tick in other cells.
And now, whenever you want to put a tick in your Excel sheet, do the following:
The beauty of this method is that you have to configure the AutoCorrect option only once, and from now on Excel will be adding a tick for you automatically every time you type the associated word in a cell.
If you are going to print out your Excel file and want to add some exquisite check symbol to it, you can copy an image of that check symbol from an external source and paste it into the sheet.
For example, you can highlight one of the tick marks or cross marks below, press Crl + C to copy it, then open your worksheet, select the place where you want to put a tick, and press Ctrl+V to paste it. Alternatively, right-click a tick mark, and then click "Save image as…" to save it on your computer.
Tick marks Cross marks
Now that you know how to insert a tick in Excel, you may want to apply some formatting to it, or count cells containing the checkmarks. All that can be easily done as well.
Once a tick symbol is inserted in a cell, it behaves like any other text character, meaning that you can select a cell (or highlight only the check symbol if it's part of the cell contents), and format it to your liking. For example, you can make it bold and green like in the screenshot below:
If your cells do not contain any data other than a tick mark, you can create a conditional formatting rule that will apply the desired format to those cell automatically. A big advantage of this approach is that you will not have to re-format the cells manually when you delete a tick symbol.
To create a conditional formatting rule, perform the following steps:
Where B2 is the topmost cells that can potentially contain a tick, and 252 is the character code of the tick symbol inserted in your sheet.
In addition, you can conditionally format a column based on a tick mark in another cell in the same row. For example, we can select the task items range (A2:A10) and create one more rule with the strikethrough format using the same formula:
As the result, the completed tasks will be "crossed off", like shown in the screenshot below:
Experienced Excel users must have got the formula up and running already based on the information in the previous sections. Anyway, here's a hint - use the CHAR function to detect the cells containing a check symbol, and the COUNTIF function to count those cells:
Where B2:B10 is the range where you want to count check marks, and 252 is the check symbol's character code.
This is how you can insert, format and count tick symbols in Excel. No rocket science, huh? :) If you also want to learn how to make a tick box in Excel, be sure to check out the following resources. I thank you for reading and hope to see you on our blog next week.
Table of contents