Here is a tutorial on how you can insert the tick (✓) symbol in Excel.
Here in Excel, you can insert two types of tick marks: the Check Box and the Check Mark. These two are not the same.
Check Box vs Check Mark
Even if the Check Box and the Check Mark may appear the same, these two are so different in how you can use and insert them in Excel.
A Check Box is an object that you can find above the worksheet.
Whenever a Check Box gets placed above the cell, it will not be a part of the cell but a thing over it.
Because of that, whenever the cell gets deleted, the Check Box won’t get deleted.
Besides that, you can choose a Check Box and have it dragged anywhere in the worksheet because it doesn’t bound to the cell.
You will see that the Check Mark symbol is what you want to become included in a report, while Check Boxes are used in dashboards and interactive reports.
The symbol Check Mark is what you can insert inside a cell, similar to any text you type.
It means that whenever the cell is copied, you can also have the Check Mark copied.
Every time you have a cell deleted, the Check Mark will also get deleted.
Similar to regular text, you can have it formatted by changing the font size and the color.
A Check Mark is an object that you can place above the cells or a symbol in a Check Box and cell.
Here, we will discuss Check Marks. Here are the ways you can have the Check Mark symbol inserted in Excel:
Inserting the Check Mark Symbol in Excel
We are going to discuss the methods that you can use to insert the Check Mark Symbol.
With these, you will learn how to become dependent on how you would like to use the Check Mark in your work.
Use Keyboard Shortcuts
When it comes to using keyboard shortcuts, you need to change the cells’ font to Wingdings or Wingdings 2 based on the keyboard shortcut you use.
Here are the shortcuts that can help you insert the cross symbol or Check Mark in the cells.
If you want to use these shortcuts, the font needs to get changed to Wingdings 2.
These are the keyboard shortcuts that you can use whenever you want to insert Cross Symbols and Check Marks.
If you’re going to use these shortcuts, the font needs to get changed to Wingdings.
It would be best suited to use this method whenever you want to put a Check Mark in the cell.
This method requires people to have the font changed to Wingdings or Wingdings 2.
It wouldn’t be helpful to have other numbers or text in the same cell with the Cross Mark or the Check Mark.
Have the Check Mark Copied and Pasted
Begin with the easiest one.
Since you’re reading this article, you can copy this Check Mark (✓) and have it pasted in Excel.
Do this by copying the Check Mark and going to the cell where you would like to copy it.
Then, you can press the F2 key or double-click on the cell so you will get to the edit mode.
After that, paste the Check Mark by pressing Ctrl and V.
Once you get the Check Mark in Excel, you can have it copied and pasted as much as you want.
It would be suited to do this whenever you want to have the Check Mark copied and pasted in certain places.
Since manually doing things is involved here, it may not be meant for any extensive report wherein you need to have Check Mark inserted for so many cells that could reach up to a thousand based on that criteria.
In this case, we recommend using a formula which we will show in this tutorial.
Use of the Double-Click (VBA)
With just some VBA code, you can make great functionality to insert a Check Mark whenever you double click a cell.
If you double click once more, it will remove it.
Here, the double click is indicated by the red ripple:
If you want to do this, you have to use the simple VBA code and the double-click VBA event.
However, before we can provide the complete code that will allow you to use the double click, we will first explain how the VBA can insert the Check Mark.
The code below would have the Check Mark inserted in cell A1, and it will have the font changed to Wingdings so that you can surely see that the check symbol is used.
Range(“A1”).Font.Name = “Wingdings”
Range(“A1”).Value = “ü”
The same concept will be what you will use to have a Check Mark inserted on a double click.
Here is the code on how you can do this:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 2 Then
Cancel = True
Target.Font.Name = “Wingdings”
If Target.Value = “” Then
Target.Value = “ü”
Target.Value = “”
Here is the code that you would have to copy and paste in the worksheet’s code window.
On the tabs’ sheet name, left-click and select “View Code.”
This method is excellent whenever you have to scan a list manually and have Check Marks inserted.
It can be easy to do this with just a double click. With this, the best use case is when you go through a task list that you have to mark as completed or not.
Use of the CHAR Formula
You can use the CHAR function if you want to have a Cross Mark or Check Mark returned.
The formula below will have the Check Mark symbol returned in the cell.
If you want this to work, you need to have the font changed to Wingdings. Using the CHAR(252) formula can give you the ANSI character that is ü.
Once the font is modified to Wingdings, it will convert into a Check Mark.
If you want a different format of the Cross Mark or the Check Mark, you can use the same CHAR formulas with varying number codes.
Whenever it gets used with the other formulas, using a formula has the real benefit of returning a Cross Mark or a Check Mark as a result.
As an example, assume that you have this dataset:
If you want to get a Cross Mark every time the sale value is less than 5000 and the Check Mark if the sale value is above 5000, use the IF Formula below:
Just remember to have the column font converted into Wingdings, as this can make your reports appear more visual.
It can also work well with any printed report.
Whenever you want to remove the formula and retain the values, have the cell copied and pasted as a value.
Do this by right-clicking the mouse, choosing the Paste Special, and clicking on the icon Paste and Values.
It would be great to use this method whenever you want to depend on the cell values every time you insert a Check Mark.
Since the formula is used here, you can utilize it even if the cells are in hundreds or thousands.
Besides that, since you have to change the cells’ font to Wingdings, the cells don’t have anything else but symbols.
Use the Symbols Dialog Box
The other way you can have a Check Mark symbol (or any symbol) inserted in Excel is through the Symbol dialog box.
These are the steps on how you can use the Symbol dialog box to insert the tick mark or Check Mark:
- Select the cell you want to place the check mark symbol.
- Click on the ribbon’s Insert tab.
- Click on the Symbol icon.
- It will open the Symbol dialog box. Choose the font ‘Segoe UI Symbol.’
- Continue scrolling down until you see the Check Mark symbol and then click on Insert or double click on it.
Use Conditional Formatting to Insert A Check Mark
Conditional formatting is what you can use to have a Cross Mark or Check Mark inserted based on the cell’s value.
As an example, assume having the data set below.
You want to have a Cross Mark inserted when the value is less than 5000 and a Check Mark whenever the value exceeds 5000.
You can do this through conditional formatting in the following steps:
- Enter =A2 in cell B2. Have this formula copied for all of the cells. With this, you can make sure that the adjacent cell has the same value, and changing the value in column A will automatically change what is in column B.
- Choose all of column B’sB’s cells where you want to insert the Check Mark.
- Click the Home tab.
- Click on Conditional Formatting.
- Click on New Rule.
- In the dialog box “New Formatting Rule,” click on the drop-down “Format Style” and select “Icon Sets.”
- At the drop-down “Icon Style,” choose the Cross Mark and the Check Mark style.
- Check the box “Show Icon only” to ensure that the numbers are hidden, and the icons are visible.
- In the Icon settings, have “percent” changed to “number” and implement the following settings:
- Click on OK.
These steps will allow for the insertion of a red Check Mark when the value is less than 5000 and a green Check Mark every time the value is more than or equal to 5000.
Here, these are the icons that we only used. However, if needed, you can have the yellow exclamation mark used as well.
One of the great features of Excel is that it is capable of automatically correcting any misspelled words.
For example, in Excel, whenever you type words with a wrong spelling like “fornt,” it will have it automatically corrected to the word “front.”
It occurs whenever there is a list of expected misspelled words that you may likely type in Excel that automatically corrects them for you.
With these steps, you can use autocorrect whenever you want to have the delta symbol inserted:
- Check out the File tab.
- Choose Options.
- Select Proofing in the Options dialogue box.
- Tap on the button ‘AutoCorrect Options.’
- In the Autocorrect dialogue box have CMARK replaced with this:
- 6. Click on Add and then choose OK.
- By this time, whenever the words CMARK get typed in an Excel cell, it can have it changed automatically into a Check Mark.
Here are the things that you have to know whenever you use the method Autocorrect:
- You can apply this change applied to every Microsoft application like PowerPoint and MS Word. Ensure that you are cautious and select the keyword that you are unlikely to use in other applications.
- There are times when there is a number or text after or before the CMARK. Here, it won’t get converted into the Check Mark symbol. For example, it will not convert “38%CMARK,” but it can convert “38% CMARK” to “38%.”
- It can be case sensitive, so entering “cmark” will not convert into a Check Mark symbol. What you need to enter is CMARK.
It would be best to use this method whenever you need a ready reference for the Check Mark that you regularly use in your work.
Instead of using the symbols dialog box or remembering shortcuts, you can immediately use the shortcode name you made for any other symbol like the Check Mark.
Have the Cross Mark or Check Mark Formatted with the Use of Conditional Formatting
Using conditional formatting, you can have the cells formatted based on the type of symbol. Here is an example:
The CHAR function is what Column B uses, so it can return a Cross Mark every time the value is less than 5000 and a Check Mark whenever the value is higher than 5000.
Columns C and D use conditional formatting to look so much better because it uses colors to improve the visual representation.
Here is how you can implement this.
We have below a dataset wherein the CHAR function is used to get the Cross Mark or Check Mark based on the cell’s value.
Here are the steps that can help in coloring the cells according to the symbol that it has:
- Choose the cells with the Cross-Mark or Check Mark symbols.
- Click on the Home tab.
- Choose Conditional Formatting.
- Tap on “New Rule.”
- Determine the cells to format by choosing the “Use a formula” in the New Formatting Rule dialog box.
- Have the following formula: =B2=CHAR(252) entered in the formula field.
- Click on the button “Format.”
- In the dialog box of “Format Cells,” go to the tab Fill tab and choose the green color.
- At the Font tab, select the color white o make sure that your Check Mark will appear great whenever the cell has a background color of green.
- Click on OK.
Once you complete these steps, the data will appear similar to what is shown below.
Every cell that has the Check Mark will have the color green with white font.
You have to repeat these steps so you can have the cells formatted with a Cross Mark.
Change the formatting in step 9 and step 6, have the formula changed to =B2=char(251).
Count the Check Marks
Whenever you want to have the total number of Cross Marks or Check Marks counted, you can do this by combining CHAR and COUNTIF.
As an example, assume that you have this data set and want to know how many stores in total could achieve their sales targets.
Here is the formula that can provide you the total amount of Check Marks that column C has:
Take note that this formula relies on the use of the 252 ANSI code to have the Check Mark. It can work whenever you use the formula =Char(252) or have used the ALT 0252 keyboard shortcut. It can also work if you had the Check Mark made through these methods copied and pasted. Whenever this may not be the case, the COUNTIF function will not work.
Formatting of the Check Mark Symbol
The Check Mark is the same as any other symbol or text that you use.
With this, you can easily have the size and color changed.
You have to choose the cells with the symbol and have formatting like font color, bold, font size, etc., applied.
This manual way of formatting symbols is best whenever there are several symbols you can format.
In case there are so many of these, it would be best to have conditional formatting used to have these formatted.
With the steps that we mentioned, you can have a Check Mark inserted in the chosen cell.
In case you want more, copy the one that is already inserted and use it.
Take note that you need to use the “Segoe UI Symbol” so you can regularly use the Check Mark in Excel like Verdana, Calibri, Time Now, and Arial.
You can have the size and shape adjusted a bit based on the font. It even means that you can have a number or text with the Check Mark that is in the same cell.
Even if this method may be a bit longer, you don’t need to know the CHAR code or shortcut.
Once it gets used in inserting symbols, you can have it reused through copy-pasting it.
Get to Know How You Can Insert a Tick Symbol or Check Mark (✓) in Excel with ExcelMaster
Make yourself an Excel expert with us!
Allow yourself to become sufficiently knowledgeable on how you can insert a tick symbol or Check Mark (✓) in Excel with ExcelMaster NOW!