How To Insert Tick Mark In Excel

H

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. 

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.

Tick mark

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.

Shortcuts for inserting a check mark or a cross symbol in cells.

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).

More shortcuts that you can use to insert check marks and cross symbols

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:

  1. Select the cell in which you want the check mark symbol.
  2. Click the Insert tab in the ribbon.
Click the insert tab in the ribbon
  1. Click on the Symbol icon.
click the symbol icon

4. In the Symbol dialogue box that opens, select ‘Segoe UI Symbol’ as the font.

Select Segoe Symbol in symbol dialog box

5. Scroll down till you find the check mark symbol and double-click on it (or click on Insert).

Select the check mark symbol that you want to 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:

  1. Click on the File tab.
File Tab in Ribbon
  1. Click on Options.
Click on Options
  1. In the Options dialogue box, select Proofing.Click on Proofing option
  2. Click on the ‘AutoCorrect Options button.Click on the Autocorect Button

5. In the Autocorrect dialogue box, enter the following:

Replace: CMARK

With: (you can copy and paste this)

Autocorrect dilaog box to give check mark a code

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!

About the author

Gaurav Singh Rawat

Add comment