In Excel, you will find that there are two types of tick marks (✓) that you can insert- a check mark and a checkbox.
Don’t be confuse, these two are not same.
Let me differentiate them for you J
Check Mark Vs Check Box:
At first glance you might find a check mark and a check box similar but these are not similar , both of them are very different they way we insert and used in excel.
A Check Mark is just like a symbol that you can insert in a cell, just like any other text that you insert in cell. As check mark is the part of the cell like any other text, so when you delete the cell or copy it check mark also get copied or get deleted.
You can also change check marks design by changing the font and size.
A Check Box, is basically an object which placed on the cell when you insert. Which means if you delete the cell, the checkbox may not be deleted. As I said check box is just an object which means you can drag it anywhere in the sheet as per your needs.
You can easily find check boxes being used in many excel reports and dashboards, and check mark is simple symbol that can be part of your report.
I am sure now you clearly know the difference between check box and check marks, but in this article I am only covering only check marks. You can learn more about check box here in complete guide.
As we discussed that check mark is just an symbol, there are few ways that you can use to insert a check box in your excel sheet.
Inserting Check Mark Symbol in Excel
In this article, I will be showing you all the methods that I know.
The method you choose would be completely depend on how you want to use the check mark in your work.
Let’s jump in!
Copy and Paste the Check Mark in Excel
One of the easiest method to insert a check mark in excel, just copy the below check mark symbol and paste it in your excel cell.
There are two ways through which you can paste check mark in excel cell, first double click the cell and paste it. Second, press F2 on the cell and paste the symbol.
Once you have the check mark symbol, you can copy and paste it as many cell as you want.
Note: As I told you that, this is one of the easiest method and can be use in small task or in small data set reporting. If you want to use check marks in big reports then I would highly recommend to use formulas.
Keyboard Shortcuts to insert Check marks(tick marks
) in excel:
You can use Keyboard shortcuts to insert check marks in excel, you might have to adjust the font size by your own. Let see the short cuts now.
Below are the two examples of keyboard shortcuts to insert check marks and cross symbol in excel sheet.
There are some more keyboard shortcuts through which you can insert check marks, checkbox and cross marks in your excel sheet file.
Using the Symbols Dialog Box to insert Check marks(tick marks ) in excel:
There is another way to insert a check mark symbol in Excel is using the Symbol dialog box which is already available in excel.
Here are the simple steps to insert the check mark (tick mark) using the Symbol dialog box in excel sheet:
- Select the cell in which you want the check mark symbol.
- Click the Insert tab in the ribbon.
- Click on the Symbol icon
- In the Symbol dialog box that opens, select ‘Segoe UI Symbol’ as the font or any other which you like the most.
- Scroll down till you find the check mark symbol and the double click on it (or click on Insert).
The above steps would insert only one check mark in the selected cell, you can late insert it in multiple cells as per your needs.
I know this method is quite long but you don’t need know any shortcut to perform this. Once you have one symbol, then you can just copy it and paste it in multiple cells.
Using the CHAR Formula to insert Check marks in excel:
You can use CHAR formula to return a check mark in your excel.
If you use this formula (=CHAR(252)) then you will see check mark symbol in your excel sheet cell.
Important: When you use CHAR(252), you will see ANSI character in return so to get the desired results you need to change the font family to Wingdings.
You insert Check boxes, check marks and cross marks using CHAR formulas.
The best benefit that I see to use CHAR formula is that you can use it with other formula’s to get the desired results for your table.
For example, suppose you have a dataset as shown below:
You can use the below IF formula to get a check mark if the sale value is more than 5000 and a cross mark if it’s less than 5000.
Just copy the below formula in your cell and you will get the tick mark or check mark in your excel cell.
NOTE: you need to convert the column font to Wingdings.
If you want to remove the formula and only want to keep the values, copy the cell and paste it as value. Follow this simple step:
- Choose the Paste Special then.
- Click on Paste and Values icon.
You can use this formula when you have thousands of cell to work on.
Using Auto correct to insert Check marks(tick marks ) in excel:
I am sure that many of you were not aware about the auto correct feature of excel. Actually excel auto correct the misspelled word automatically J
In excel there is a pre-made list of misspelled words and when you type them it got automatically auto correct.
Here are the steps to use auto correct to insert the delta symbol:
- Click on the File tab.
- Click on Options.
- In the Options dialogue box, select Proofing.
- Click on the ‘Auto Correct Options’ button.
- In the Auto correct dialogue box, enter the following:
- Replace: CMARK With:
- ✔ (you can copy and paste this)
Now whenever you type the words CMARK in a cell in Excel, it will automatically change it to a check mark symbol in your excel sheet.
Important: When you apply this change in your excel file, it will reflect on other application too like Word, Power Point etc.. so make sure you choose the word correctly and will be unique.