PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
INSERT CHECK MARK SYMBOL IN EXCEL
INTRODUCTION
ADD A CHECK MARK SYMBOL IN EXCEL
There can be different ways of creating a check mark or tick mark symbol in your sheet in Excel.
DIFFERENT METHODS OF ADDING A CHECK MARK SYMBOL
- USING GOOGLE
- USING IMAGE
- USING SYMBOL INSERTION
- USING FUNCTION
- USING KEYBOARD
1.INSERT CHECK MARK SYMBOL IN EXCEL USING GOOGLE
We all have such a vast data in our brains like work, life, society this and that what, we all do. 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.
- 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.
2.INSERT CHECK MARK SYMBOL IN EXCEL 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 searchbox check mark symbol. (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.
- RIGHT CLICK the image you like and choose COPY IMAGE.
- Paste the picture in the sheet.
- Select the picture and resize it with the help of small circles shown in the picture.
- Play with the picture till we get the image which we want.
- Take care of the picture copyrights. Use free pictures only.
- Its better if we want, we can create our own picture in the Excel 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.
3.INSERT CHECK MARK SYMBOL IN EXCEL USING SYMBOLS
The other method of inserting a copyright symbol is using the SYMBOL INSERTION FACILITY.
There is a complete table in the MICROSOFT EXCEL having a full fledged list of a big number of symbols from where we can choose the symbols we like. Follow the following steps to insert the symbol in the Excel using symbol dialog box. But we have a problem with the CHECK MARK symbol.
It wasn’t the part of standard characters from 0 to 255. So it is available in few fonts only such as WINGDINGS and SEOGE UI SYMBOL. So we’ll need to use these fonts to install a CORRECT TICK MARK in our sheet. The steps to insert them follows.
STEPS
- Open the Excel software.
- Go to INSERT TAB and CLICK SYMBOL or Press ALT+N+U to open the SYMBOL DIALOG BOX directly.
- In the FONT DROP DOWN LIST choose WINGDINGS font.
- Enter 0252 in the CHARACTER CODE. The Check Mark will be selected.
- Press INSERT and it’ll be inserted in the cell chosen.
4.INSERT CHECK MARK SYMBOL IN EXCEL USING CHAR FUNCTION
We already learnt to insert a CHECK MARK SYMBOL using the google , image and symbol dialog box. Now if we remember the ASCII code for the CHECKMARK SYMBOL, we have an option of inserting the symbol directly into the spreadsheet. This is the fastest method as it is directly applied in the sheet. Let us learn this.
STEPS
- Open the Excel software.
- Select the font “WINGDINGS”.
- Select the cell where you want to insert the copyright symbol.
- Enter the following function
Now we have inserted the CHECKMARK symbol. But you must be wondering where to get the code 252.
These are ASCII codes given to different characters. It is a one time job and we can find it from the SYMBOLS DIALOG BOX itself. Here are the steps to find out the ASCII codes of the characters.
STEPS TO KNOW THE ASCII CODES OF SPECIAL CHARACTERS:
- Go to INSERT TAB and click symbols.
- The following screen will open.
- Now select the character whose ASCII CODE or CHARACTER CODE you want to know.
- The character code window is shown below.
5.INSERT CHECK MARK SYMBOL IN EXCEL USING KEYBOARD
KEYBOARD SHORTCUT TO INSERT CHECK MARK IN EXCEL
