HOW TO INSERT CHECK MARK OR TICK MARK 🗸🗸 SYMBOL IN GOOGLE SHEETS

Table of Contents

INTRODUCTION

Let us start another exciting session of LEARNING GOOGLE SHEETS with gyankosh.net

This article will let you know how to insert CHECK MARK SYMBOL or TICK MARK SYMBOL in GOOGLE SHEETS.


These symbols are handy while making many reports but we find hard to find these symbols as these are not available on the keyboard or there are no direct input methods available to use them.


The symbols present on the keyboard can be easily found but not these and especially the CHECK MARK symbol as it is available for specific fonts only.


So we’ll  check the main and easy methods only to insert them.The methods, which are easy and you won’t forget easily.Let us start.

WHAT IS A CHECK MARK SYMBOL ?

A check mark symbol looks like 🗸.

In addition to check mark this symbol is also frequently called as a tick mark symbol or correct symbol or right symbol.

The check mark symbol denotes a CHECK or CORRECT or the presence of any item.

TYPE A CHECK MARK OR TICK MARK SYMBOL IN GOOGLE SHEETS

There can be different ways of creating a check mark or tick mark symbol in your sheet in GOOGLE SHEETS.

We’ll go through each of the method one by one to search out the options for finding out the ways to add checkmark symbol.

DIFFERENT METHODS OF ADDING A CHECK MARK OR TICK MARK SYMBOL

  1. DELIVERY DESK
  2. USING GOOGLE
  3. USING IMAGE
  4. USING SYMBOL INSERTION [FROM GOOGLE DOCS]
  5. USING FUNCTION

1.DELIVERY DESK- COPY PASTE CHECK MARK SYMBOL

Here is a list of the CHECK MARK SYMBOLS ready to use.

FOLLOW THE STEPS TO COPY CHECK MARK SYMBOL FROM THE LIST.

1. Select any symbol of your choice.

2. Right Click and select Copy or Select and press CTRL+C.

3. Open the GOOGLE SHEETS.

4. Paste the symbol anywhere , where it is needed. 

The List of the symbols: 

  •  ☑
  •  ✅
  •  ✓
  •  ✔
  •  🗸
  •  🗹

2. INSERT CHECK MARK SYMBOL IN GOOGLE SHEETS USING GOOGLE OR ANY SEARCH ENGINE

We all have such a vast data in our brains like work, life, society this and that. But what happens when we don’t use some special knowledge for a long time, we start forgetting it.

This is a case with each one of us. So we should always learn such methods, which go deep inside the brain and has less to remember.

So we have not filled our list with n number of options but just the needed ones which will make us go and we won’t forget either.

So let us first learn how we can get the check mark symbol from google or by copying it from somewhere.

Here are the steps.

  •  Open google.com or your favorite search engine in your browser.
  • Type in the searchbox check mark symbol. (no need to ask for the procedure)
  • The following picture will appear on the screen. There can be a bit difference too due to region etc. but the thing which we are finding, we’ll definitely get it.

GOOGLE SHEETS :SEARCHING THE SYMBOL IN GOOGLE AND COPYING IT

  • Now look at the page and search for a CHECK MARK SYMBOL but mind it, we don’t want an image.
  • Most of the bigger pictures are images, we want text, so select the one which is shown in the picture as selected and copy it. [For copying select the symbol and press CTRL+C or use RIGHT CLICK and choose COPY]
  • Paste it anywhere in the sheet. [Select the cell and press CTRL+V or RIGHT CLICK and choose PASTE]
  • The copied symbol will respond to font size as well as to font.

NOTE: Don’t copy the image by change. Image is tough to handle and won’t respond to the font and text size.

PASTE THE COPIED CHECK MARK IN GOOGLE SHEETS

3. INSERT CHECK MARK SYMBOL IN GOOGLE SHEETS USING IMAGE

We just discussed how we can find copy and insert a symbol by searching it in google. Now let us move to next method.

If we need not to change any font etc. of the check mark , we can find, copy and insert an image too.

STEPS

  • Open google.com or any other search engine in your browser.
  • Type in the search box “check mark symbol image” . (no need to ask for the procedure, just type the word)
  • The following picture will appear on the screen. There can be a bit difference too due to region etc. but the thing which we are finding, we’ll definitely get it.
  • We’ll get a few pictures of the check mark, few as the text. Using the text we already learnt.
GOOGLE SHEETS :CHOOSE THE IMAGE YOU LIKE

  • RIGHT CLICK the image you like and choose COPY IMAGE.
  • Paste the picture in the sheet.
PRESS CTRL+V TO PASTE THE IMAGE

  • The image is quite big as we can see in the picture above.
  • Hold any small square at any corner and resize the picture to make it usable.
  • We can copy and paste it again to use at different parts in our sheet.

RESIZE THE IMAGE TO SUIT OUR NEED

BUT ALWAYS BE CAREFUL ABOUT FEW THINGS.

  • Take care of the picture copyrights. Use free pictures only.
  • Its better if we want, we can create our own picture in the GOOGLE SHEETS as well as Paint which both are with us.
  • The font of the image check mark won’t change with the change in the font of the text.

4.INSERT CHECK MARK SYMBOL IN GOOGLE SHEETS USING SYMBOLS

The other method of inserting a CHECKMARK symbol is using the SPECIAL CHARACTERS OPTION .

But we have a problem that SPECIAL CHARACTER MAP option is not present in GOOGLE SHEETS but present in GOOGLE DOCS.

As Google Docs is available free of cost, we are mentioning this method also.

Open Google Docs by clicking here. [DOCS.GOOGLE.COM] [If you are logged in for GOOGLE SHEETS, you’ll simply reach the page from where you can open the google docs.]

Click on ADD NEW DOCUMENT by clicking BLANK under START A NEW DOCUMENT.

It’ll open a new document.

STEPS TO INSERT A CHECK MARK IN GOOGLE DOC FOR COPYING PURPOSE

  • In the blank document, go to INSERT MENU and click SPECIAL CHARACTERS.
  • As we click SPECIAL CHARACTERS , INSERT SPECIAL CHARACTERS dialog box opens up as shown in the picture below.
  • Put CHECK MARK in the search box or we can draw the character in the given space. [ MARKED IN THE PICTURE ].
  • The matching options will be enlisted in the left area as shown in the picture.
SEARCH THE CHARACTER AND CHOOSE FROM THE RESULTS
  • Select the appropriate symbol by clicking it.
  • It’ll be inserted in the doc.
GOOGLE SHEETS: INSERT CHECKMARK FROM SYMBOL DIALOG BOX
  • Select the CHECKMARK symbol by clicking it.
  • It’ll be inserted in the doc.
  • Now, select the character and press CTRL+C. [ You can also Right Click > Copy ].
GOOGLE SHEETS : INSERT CHECKMARK FROM SYMBOL DIALOG BOX
  • Now, the check mark is already copied.
  • Paste the symbol by pressing CTRL+V for pasting the symbol in GOOGLE SHEETS.
GOOGLE SHEETS: INSERT CHECK MARK FROM SYMBOL DIALOG BOX
  • Press INSERT and it’ll be inserted in the cell chosen.

5.INSERT CHECK MARK SYMBOL IN GOOGLE SHEETS USING UNICHAR FUNCTION

For the use of this option, we need to understand the UNICODEs.

We made use of this option extensively in the article HOW TO ADD SUBSCRIPT IN GOOGLE SHEETS and HOW TO ADD SUPERSCRIPT IN GOOGLE SHEETS.

If time allows, kindly visit any of the articles as there is a description of the UNICODE which we are going to use in this method.

Various kinds of checkmarks are provided by the UNICODE ORG to be used as the characters.

UNICHAR function helps us to show the characters given by the specific codes.

To insert the check marks, we’ll find out the UNICODE for all the checkmarks available and use unichar function to insert them.

The following table shows the UNICODES of different check marks available.

SYMBOLHEX CODEDECIMAL CODE
   
☑26119745
✅27059989
✓271310003
✔271410004
🗸1F5F8128504
🗹1F5F9128505

STEPS TO INSERT CHECKMARK USING UNICHAR FUNCTION IN GOOGLE SHEETS

  • Select the cell where checkmark is needed.
  • Enter the formula as =UNICHAR( CODE IN DECIMAL ).
  • For example, the first check box, having the decimal code 9745, we’ll use the formula as =UNICHAR(9745) and press enter.
  • The output will appear.
  • The following picture shows the output of various unicodes available.
CHECKMARK USING UNICHAR FUNCTION

FAQs

WHAT IS CHARACTER CODE OF CHECKMARK OR TICKMARK SYMBOL IN GOOGLE SHEETS?

The Check Mark symbol is not present in the ASCII but in Unicode. So the character code of the CHECKMARK SYMBOL is 2713.

In addition to this, there are a few more Unicode for the different types of checkmark or tickmark symbols. You can have a look at the picture below.

SYMBOLHEX CODEDECIMAL CODE
   
☑26119745
✅27059989
✓271310003
✔271410004
🗸1F5F8128504
🗹1F5F9128505



WHAT IS THE ALT CODE OF CHECKMARK SYMBOL IN GOOGLE SHEETS?

There is no universal ALT CODE assigned to Check Mark Symbol in Google Sheets. But yes an ALT CODE does exist for the checkmark symbol if we make use of the MICROSOFT EXCEL, WORD, or POWERPOINT.

You can refer here INSERT CHECK MARK OR TICK MARK SYMBOL IN EXCEL 🗸🗸🗸.

Briefly, you can use the FONT WINGDINGS and click ALT+0252.

OR

You can also use the decimal Unicode by simply pressing the ALT e.g. ALT+10003 will also type CHECKMARK SYMBOL but only MS WORD provides this option.

IS CHECK MARK OR TICK MARK SYMBOL SAME?

Yes, these names are for the same sign and can be used interchangeably. The CORRECT symbol is also the same.

WHAT IS THE DIFFERENCE BETWEEN A CHECKBOX AND CHECKMARK SYMBOL ?

A Checkbox and a Checkmark are completely different from each other.

A checkmark symbol is simply a tickmark or right symbol as and looks like 🗸 whereas a checkbox is a box in which we can check.

It means the checkbox is an active entity and is not a symbol.

A checkmark has no state [CHECKED OR UNCHECKED ] whereas the checkbox has a state of true and false showing if it is checked or not.



SUGGESTED READINGS:

 

Leave a Reply

Your email address will not be published.