How to add right symbol in excel?

• Word or Outlook: Insert, select. Symbols then. More Symbols.
• Excel: Insert, select. Symbols.
• PowerPoint: Insert, select. Symbols > Symbol.

Check marks have become a part of our task-oriented lives. If you use Excel to generate and execute lists (and you probably do), inserting an Excel check mark symbol will come in mighty handy. In this tutorial, we’ll show you how to insert a check mark in Excel.

A check mark or tick (✓) is a symbol that is universally associated with a positive response (for example, yes, completed, correct, etc.). The tick symbol in Excel is treated as text. This means that the color and size can be changed like any other text would be, and the location can be changed using the standard Copy and Paste commands.

Check marks are not the same as check boxes. A check box in Excel is an object which is placed on a worksheet. A check box that appears to be in a cell will not be deleted if that cell is deleted, because the check box is not actually a part of the cell. The location of a check box can be changed by dragging it as you would any other object.

There are multiple ways to insert a check mark in Excel. Five commonly-used methods are shown below.

A check mark is just another text character. If you can remember that SHIFT + P is that character, you can simply type an uppercase P in your desired cell, and change the font to Wingdings 2 as you would perform any regular font change. The Wingdings check mark will then be displayed in the worksheet.

You may also care to know that SHIFT + O in the Wingdings 2 font inserts the X symbol (×).

The Excel ribbon has an Insert tab, and from there a Symbol dropdown. Choose the Symbol command and you will find all the supported symbols in Excel.

In the Symbol dialog box, choose the Wingdings font option, and scroll down to find the check mark character.

Select the check mark and click the Insert button to place the check mark in the worksheet, then click Close to close the dialog window.

You can see in the above image that Excel stores recently used symbols toward the bottom of the Symbol dialog box to save time if you need to insert them again.

If you saw the character code 252 at the bottom of the dialog box in the previous method, this might be a good reminder of an Excel check mark shortcut.

You’ll need to change the font to Wingdings, then hold the ALT button while typing in 0252. Note that the numbers should be entered from the numeric pad on the keyboard, and not from the QWERTY numbers above the letters.

If you forgot to change the font to Wingdings before doing the ALT 0252 shortcut, you may see a character that looks like this: ü. No worries. Just change that cell to the Wingdings font and your check mark will be displayed.

Note: There is no such option on Mac devices.

A check mark can be inserted using a function? Yes, it can. UNICHAR is a text function that returns the character represented by the Unicode argument in parentheses. Remember that each character is assigned a special code within the computer’s memory. Once you know the code for the character you want to insert, you can use UNICHAR to insert it.

=UNICHAR(10003) inserts a check mark, and UNICHAR(10004) inserts a heavy check mark.

This method offers the advantage of not having to change to a special font. If you choose to use the UNICHAR function, bear in mind that the check mark has to be the only value in that cell.

UNICHAR(10007) and UNICHAR(10008) will insert the X and heavy X, respectively.

Conditional formatting tells cells how to behave if certain conditions are met. The Conditional Formatting feature can add icons into cells based on cell values, and you can use this feature to add a check mark in Excel.

For example, download the practice file and work along while we use conditional formatting to insert a check mark next to each month where the target of 500 unit sales per month was met, and an X next to the months where the target was not met.

To apply conditional formatting, follow the steps below:

By default, Excel places a check mark for values within the 67th percentile and higher, and an X for values below the 33rd percentile. For values between the 33rd and 66th percentiles, an exclamation symbol is the default.

You will now be able to tell at a glance whether the monthly target was met or not.

There is also the option of displaying the symbols only, without the associated number. Do this by returning to the Conditional Formatting Rules Manager, choosing Edit Rule, and then selecting the Show Icon Only checkbox.

When applied, the cells will now display the icons only.

Of course, since the check mark behaves just like a text character, you can make it bold, color it, increase the font size, change the alignment, and apply any other text formatting you like.

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.

If you are a beginner in Microsoft Excel then there are chances that you might get confused between a check mark and a checkbox. Both of these symbols look somewhat similar but they are inserted and used in excel in different ways. Inserting a check mark is very easy but first we will understand the difference between a check mark and a checkbox.

An object or that sits above your Excel worksheet is a checkbox. For example – Take a cell. Place a checkbox above that cell. Now, the checkbox is not a part of the cell but it is just an object over it. Now when you delete that cell, the checkbox won’t get deleted. It is not bound to a cell which is why you can easily drag and drop the checkbox anywhere.

A check mark is a symbol similar to some other text that you insert in a cell. When you will delete a cell in which a check mark was there, the symbol will get deleted too and if you will copy the content of a cell then this means that the check mark will be copied as well. Moreover, it is something that you can edit by changing the color and size of it jus t like plain text.

Inserting check marks in Excel is a part of a report whereas checkboxes are used by people in their interactive reports and dashboards. There are a handful of ways through which you can easily insert a checkmark in your report. A detailed description is given for each way and all of them are quick, easy, and work for almost every version of Microsoft Excel.

Know How to Insert Pictures into Excel Cell in easy steps.

Perchance, this is not the prevalent way of inserting a checkmark in Excel, however, if you are a person who likes formulas and equations then it can become your favorite way of inserting a tick mark. You should be familiar with the symbol codes for using this as a method of adding them. The formula that you can use for adding a check mark in a cell in your Excel worksheet is:

=CHAR(252)

But you need to make sure that for displaying these check marks correctly, you should apply the wingdings font to the formula cells. Once you are done inserting this symbol into one cell, you can easily copy and paste it to the other cells as required.

Using the symbol command is the most common way of inserting a check mark or a tick symbol as people call it. You have to follow the given set of steps for the same.

Step 1: Firstly, you need to select the cell where you want to insert a check mark .

Step 2: Now for the next step, go to the insert tab and click on the symbols group. Select “symbols”.

Step 3: A dialogue box will appear. Select wingdings in the drop down box that is next to the font box.

Step 4: You will find a few cross symbols and check mark symbols at the bottom of the given list. Select the relevant symbol that you want and then click on insert.

Step 5: At last, close the dialogue box by clicking on the close button.

When you are done selecting the symbol of your choice from the symbol dialogue box, Microsoft Excel will display the code of that symbol in a character code box that is present at the bottom. For example – the character code for a tick mark in excel is 252. When you know this code, you will easily be able to insert a check mark the next time.

You have no idea how wonderful the keyboard is. You can almost perform any function using just a few keys on your keyboard. The thing is – you have to remember them. In order to insert a checkmark using your keyboard, you just have to apply the font Webdings or Wingdings 2 to the cell where you would like to insert the symbol and then press the respective keyboard shortcuts to get them.

For Wingdings 2, the keyboard shortcut is Shift + P and for Webdings, the shortcut is a.

Another very easy way to insert a checkmark on your worksheet in excel is by using a CHAR code. All you have to do is just type the character code in the cell you want to insert this symbol directly. You will have to hold the Alt key alongside it though. The steps are:

Step 1: Select the cell where you would like to insert the check mark .

Step 2: Go to the home tab and then select the font group. Change it to wingdings.

Step 3: Now press and hold the Alt key while you type the character code on your numeric keypad. The character code for the check mark symbol is – Alt + 0252.

The character codes for check marks are just as same as the codes that are used in the CHAR formulas but for the leading zeros. If you want to ensure that these codes work, then switch Num Lock on and use the numerical keypad on your keyboard rather than the numbers that are present on the top.

Learn how to embed a PDF file in an excel worksheet here.

If you didn’t like any of the methods above for inserting a check mark or tick in your worksheet then you can use the autocorrect as well to do so. If you are a person who has to insert these ticks daily then this is the fastest way to do so. The use of autocorrect will automate your work and for setting it up, you will have to follow these given steps:

Step 1: First of all, select any one of the methods explained above and insert the check mark in any cell you want.

Step 2: Go to the formula bar and select that symbol. Copy it using Ctrl + C.

Step 3: Click on File > Options > Proofing and then select Autocorrect options.

Step 4: You will see an autocorrect dialogue box. There will be a replacement box. In that, you need to type a phrase or a word you like that you would want to associate with the tick mark. For example – TM.

Step 5: There will be a “with box” as well. Press Ctrl + V for pasting the symbol that was copied from the formula bar.

Step 6: Click on the add button and then click ok.

Now, whenever you feel like you need to add a checkmark in your worksheet, just type the initials TM (that we earlier associated with the check mark ) and then press enter. In this method, you have to configure your autocorrect only once and then you are all set to go. You will get your tick mark whenever you type “TM” in a cell.

Check out how to lock formulas in MS Excel here.

Below is the written tutorial, in case you prefer reading over watching the video.

In Excel, there are two kinds of tick marks (✓) that you can insert – a check mark and a checkbox.

And no… these are not the same.

Let me explain.

While a check mark and a checkbox may look somewhat similar, these two are very different in the way it can be inserted and used in Excel.

A check mark is a symbol that you can insert in a cell (just like any text that you type). This means that when you copy the cell, you also copy the check mark and when you delete the cell, you also delete the check mark. Just like regular text, you can format it by changing the color and font size.

A checkbox, on the other hand, is an object that sits above the worksheet. So when you place a checkbox above a cell, it’s not a part of the cell but is an object that is over it. This means that if you delete the cell, the checkbox may not get deleted. Also, you can select a checkbox and drag it anywhere in the worksheet (as it’s not bound to the cell).

You will find checkboxes being used in interactive reports and dashboards, while a checkmark is a symbol that you may want to include as a part of the report.

In this article, I will only be covering check marks. If you want to learn more about checkbox, here is a detailed tutorial.

There are quite a few ways that you can use to insert a check mark symbol in Excel.

Click here to download the example file and follow along

In this article, I will show you all the methods I know.

The method you use would be dependent on how you want to use the check mark in your work (as you’ll see later in this tutorial).

Let’s get started!

Starting with the easiest one.

Since you’re already reading this article, you can copy the below check mark and paste it in Excel.

To do this, 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 the edit mode.

Simply paste the check mark (Control + V).

Once you have the check mark in Excel, you can copy it and paste it as many times as you want.

For using the keyboard shortcuts, 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 mark and cross symbols. To use the below shortcuts, you need to change the font to Wingdings (without the 2).

Another way to insert a check mark symbol (or any symbol for that matter) in Excel is using the Symbol dialog box.

Here are the steps to insert the check mark (tick mark) using the Symbol dialog box:

The above steps would insert one check mark in the selected cell.

If you want more, simply copy the already inserted one and use it.

Note that using ‘Segoe UI Symbol’ allows you to use the check mark in any regularly used font in Excel (such as Arial, Time Now, Calibri, or Verdana). The shape and size may adjust a little based on the font. This also means that you can have text/number along with the check mark in the same cell.

You can use the CHAR function to return a check mark (or a cross mark).

The below formula would return a check mark symbol in the cell.

For this to work, you need to convert the font to Wingdings

Why?

Because when you use the CHAR(252) formula, it would give you the ANSI character (ü), and then when you change the font to Wingdings, it is converted to a check mark.

You can use similar CHAR formulas (with different code number) to get another format of the check mark or the cross mark.

The real benefit of using a formula is when you use it with other formulas and return the check mark or the cross mark as the result.

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.

Remember, you need to convert the column font to Wingdings.

This helps you make your reports a little more visual. It also works well with printed reports.

If you want to remove the formula and only keep the values, copy the cell and paste it as value (right-click and choose the Paste Special and then click on Paste and Values icon).

Excel has a feature where it can autocorrect misspelled words automatically.

For example, type the word ‘bcak’ in a cell in Excel and see what happens. It will automatically correct it to the word ‘back’.

This happens as there is already a pre-made list of expected misspelled words you’re likely to type and Excel automatically corrects it for you.

Here are the steps to use autocorrect to insert the delta symbol:

Now whenever you type the words CMARK in a cell in Excel, it will automatically change it to a check mark.

Here are a few things you need to know when using the Autocorrect method:

Related Tutorial: Excel Autocorrect

Click here to download the example file and follow along

You can use conditional formatting to insert a check mark or a cross mark based on the cell value.

For example, suppose you have the data set as shown below and you want to insert a check mark if the value is more than 5000 and a cross mark if it’s less than 5000.

Here are the steps to do this using conditional formatting:

The above steps will insert a green check mark whenever the value is more than or equal to 5000 and a red cross mark whenever the value is less than 5000.

In this case, I have only used these two icons, but you can also use the yellow exclamation mark as well if you want.

With a little bit of VBA code, you can create an awesome functionality – where it inserts a check mark as soon as you double click on a cell, and removes it if you double click again.

Something as shown below (the red ripple indicates a double click):

To do this, you need to use the VBA double-click event and a simple VBA code.

But before I give you the full code to enable double click, let me quickly explain what how VBA can insert a check mark. The below code would insert a check mark in cell A1 and change the font to Wingdings to make sure you see the check symbol.

Now I will use the same concept to insert a check mark on double click.

Below is the code to do this:

You need to copy and paste this code in the code window of the worksheet in which you need this functionality. To open the worksheet code window, left-click on the sheet name in the tabs and click on ‘View Code’

Click here to download the example file and follow along

A check mark is just like any other text or symbol that you use.

This means that you can easily change its color and size.

All you need to do is select the cells that have the symbol and apply the formatting such as font size, font color, and bold etc.

With conditional formatting, you can format the cells based on what type of symbol it has.

Below is an example:

Column B uses the CHAR function to return a check mark if the value is more than 5000 and a cross mark if the value is less than 5000.

The ones in column C and D uses conditional formatting and look way better as it improves visual representation using colors.

Let’s see how you can do this.

Below is a dataset where I have used the CHAR function to get the check mark or cross mark based on the cell value.

Below are the steps to color the cells based on the symbol it has:

After the above steps, the data is going to look as shown below. All the cells that have the check mark will be colored in green with white font.

You need to repeat the same steps to now format the cells with a cross mark. Change the formula to =B2=char(251) in step 6 and formatting in step 9.

If you want to count the total number of check marks (or cross marks), you can do that using a combination of COUNTIF and CHAR.

For example, suppose you have the data set as shown below and you want to find out the total number of stores that have achieved the sales target.

Below is the formula that will give you the total number of check marks in column C

You May Also like the following Excel tutorials: