Tag: excel checkmark

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.

Use the
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.

About Deepak Jha

I am a Marketer & passionate Excel practitioner. I am using MS excel from past 6 years in my daily routine work, I have tried many things to automate my excel work so i thought why not I help others to automate their work through excel so I started You Learn Excel blog. Just to make things easier for others.