Learn how to insert tick mark in Excel in this article along with other details about it.
Microsoft’s Excel spreadsheet program is a part of the Office suite of business software applications. Users can format, arrange, and compute data in a spreadsheet using Microsoft Excel.
Microsoft Excel can be used for a variety of tasks such as calculating the average, data filtering, enabling macros, and more.
If you are wondering how to insert tick marks in Excel, well there are a lot of ways to do so. Different ways used will depend on how you want the checkmark in your work.
Table of Contents
How To Insert Tick Mark In Excel
Let us learn how to put a tick mark in Excel.
Copy and Paste the Check Mark
This is the easiest way to do so.
Simply copy the check mark and go to the cell where you want to copy it. Now either double-click on the cell or press the F2 key. This will take you to edit mode.
Simply paste the check mark (Control + V).
Use the Keyboard Shortcuts
For this, you will have to change the font of the cells to Wingdings 2 (or Wingdings based on the keyboard shortcut you’re using).
Below are the shortcuts for inserting a check mark or a cross symbol in cells. To use the below shortcuts, you need to change the font to Wingdings 2.
Below are some more keyboard shortcuts that you can use to insert check marks and cross symbols. To use the below shortcuts, you need to change the font to Wingdings (without the 2).
Also Read
How to add row and column in Excel
How to add drop down in Excel
Using the Symbols Dialog Box
Another way to insert a checkmark symbol (or any symbol for that matter) in Microsoft Excel is using the Symbol dialogue box.
Here are the steps on how to put a tick mark using the Symbols Dialog box:
- Select the cell in which you want the check mark symbol.
- Click the Insert tab in the ribbon.
- Click on the Symbol icon.
4. In the Symbol dialogue box that opens, select ‘Segoe UI Symbol’ as the font.
5. Scroll down till you find the check mark symbol and double-click on it (or click on Insert).
The above steps would insert one checkmark in the selected cell.
Also Read
How to separate text in Excel
How to remove space in Excel
Using Autocorrect
Excel has a feature where it can autocorrect misspelt words automatically.
Here are the steps to use autocorrect to insert the delta symbol:
- Click on the File tab.
- Click on Options.
- In the Options dialogue box, select Proofing.
- Click on the ‘AutoCorrect Options button.
5. In the Autocorrect dialogue box, enter the following:
Replace: CMARK
With: (you can copy and paste this)
6. Click Add and then OK.
CONCLUSION
MS Excel is a Microsoft software program that uses spreadsheets to organize numbers and data using formulas and functions. Excel analysis is used by businesses of all sizes to perform financial analysis all over the world.
Ordinary people can use Microsoft Excel for simple tasks like calculating addition and using pivot tables, as well as more complex ones like concatenation in Excel.
Easysheet is a blog where you can find incredible Excel hacks, tips, and tricks. Our goal is to make Excel more accessible to beginners and to provide them with the EasySheet as a resource for all of their questions.
We are the best place to go for anyone who needs assistance with Microsoft Office applications such as Excel, Word, PowerPoint, Publisher, and more!