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

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.

ADD 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 copyright 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 [GOOGLE DOCS]
  5. USING FUNCTION

1.DELIVERY DESK

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

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 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 copyright 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]

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 CHECK MARK FROM SYMBOL DIALOG BOX
  • Select the appropriate 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 CHECK MARK 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.

4.INSERT CHECK MARK SYMBOL IN GOOGLE SHEETS USING SYMBOLS

The other method of inserting a copyright 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]

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.
CLICK SPECIAL CHARACTERS TO OPEN THE CHARACTER MAP

  • 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 CHECK MARK FROM SYMBOL DIALOG BOX
  • Select the appropriate 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 CHECK MARK 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

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 article as there is description of the UNICODES 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 UNICODES 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

SUGGESTED READINGS:

 

Leave a Reply

Your email address will not be published. Required fields are marked *