INSERT CHECK MARK SYMBOL IN EXCEL

INTRODUCTION

Let us start another exciting session of Excel Tricks with gyankosh.netThis article will let you know how to insert CHECK MARK SYMBOL or TICK MARK SYMBOL in Excel.
These symbols are handy while making many reports but we find hard to find these symbols as these are not available on the keyboard.
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.
https://googleads.g.doubleclick.net/pagead/ads?us_privacy=1—&client=ca-pub-3894096195292173&output=html&h=280&adk=3840636199&adf=3326112819&pi=t.aa~a.131391915~rp.4&w=450&fwrn=4&fwrnh=100&lmt=1618254855&rafmt=1&to=qs&pwprc=2196269336&psa=1&format=450×280&url=https%3A%2F%2Fgyankosh.net%2Fexceltricks%2Finsert-check-mark-symbol-in-excel%2F&flash=0&fwr=0&pra=3&rpe=1&resp_fmts=3&wgl=1&fa=40&dt=1618254854255&bpp=5&bdt=4449&idt=-M&shv=r20210406&cbv=r20190131&ptt=9&saldr=aa&abxe=1&cookie=ID%3Db41a5cb189e66f3a-22460afed7c40041%3AT%3D1605880192%3ART%3D1605880192%3AR%3AS%3DALNI_MYRs0eKq0LSuIv_AMQC2BxdrJqY6g&prev_fmts=0x0%2C255x600%2C255x600%2C255x600%2C255x600%2C255x600&nras=2&correlator=7954707377962&frm=20&pv=1&ga_vid=117138297.1592477652&ga_sid=1618254854&ga_hid=1971149864&ga_fc=0&u_tz=330&u_his=1&u_java=0&u_h=936&u_w=1664&u_ah=895&u_aw=1664&u_cd=24&u_nplug=0&u_nmime=0&adx=824&ady=917&biw=1648&bih=765&scr_x=0&scr_y=0&eid=42530671%2C44739521%2C44740079%2C44739387&oid=3&psts=AGkb-H8n72SdH0d5ZBf1ba2clLm72i0aHxpG6wo0zmnKRw-ANhBUd7sn_HR4S1L8sTnZBjjLkDrH5uooZkJA7A%2CAGkb-H8ON25sWt5wOdjbEaodw1cy7v5HRaNkHCyTQHvQEH3Q2xQm8lX57S1KLsQ4VhPkg277PGEE1AuoFr8%2CAGkb-H_5LpMu7D92H95KCcY-XdWhC1r5HMKfL1X7HT3ndY1dcCv8Qv6kksLL8Bsd2toWT-9JsIXqevtXUTCX1g&pvsid=4065125558454523&pem=612&ref=https%3A%2F%2Fgyankosh.net%2Fexceltricks%2F&eae=0&fc=1920&brdim=-8%2C-8%2C-8%2C-8%2C1664%2C0%2C1691%2C917%2C1664%2C765&vis=1&rsz=%7C%7Cs%7C&abl=NS&fu=128&bc=31&ifi=7&uci=a!7&btvi=5&fsb=1&xpc=ORaF9XZJP2&p=https%3A//gyankosh.net&dtd=1040

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.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 SYMBOL

  1. USING GOOGLE
  2. USING IMAGE
  3. USING SYMBOL INSERTION
  4. USING FUNCTION
  5. 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.
EXCEL: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.

EXCEL: PASTING THE CHECK MARK SYMBOL IN THE EXCEL SHEET

https://googleads.g.doubleclick.net/pagead/ads?us_privacy=1—&client=ca-pub-3894096195292173&output=html&h=280&adk=609770309&adf=84056969&pi=t.aa~a.2466986641~rp.4&w=440&fwrn=4&fwrnh=100&lmt=1618254855&rafmt=1&to=qs&pwprc=2196269336&psa=1&format=440×280&url=https%3A%2F%2Fgyankosh.net%2Fexceltricks%2Finsert-check-mark-symbol-in-excel%2F&flash=0&fwr=0&pra=3&rpe=1&resp_fmts=3&wgl=1&fa=40&dt=1618254854255&bpp=4&bdt=4448&idt=-M&shv=r20210406&cbv=r20190131&ptt=9&saldr=aa&abxe=1&cookie=ID%3Db41a5cb189e66f3a-22460afed7c40041%3AT%3D1605880192%3ART%3D1605880192%3AR%3AS%3DALNI_MYRs0eKq0LSuIv_AMQC2BxdrJqY6g&prev_fmts=0x0%2C255x600%2C255x600%2C255x600%2C255x600%2C255x600%2C450x280&nras=3&correlator=7954707377962&frm=20&pv=1&ga_vid=117138297.1592477652&ga_sid=1618254854&ga_hid=1971149864&ga_fc=0&u_tz=330&u_his=1&u_java=0&u_h=936&u_w=1664&u_ah=895&u_aw=1664&u_cd=24&u_nplug=0&u_nmime=0&adx=824&ady=1227&biw=1648&bih=765&scr_x=0&scr_y=0&eid=42530671%2C44739521%2C44740079%2C44739387&oid=3&psts=AGkb-H8n72SdH0d5ZBf1ba2clLm72i0aHxpG6wo0zmnKRw-ANhBUd7sn_HR4S1L8sTnZBjjLkDrH5uooZkJA7A%2CAGkb-H8ON25sWt5wOdjbEaodw1cy7v5HRaNkHCyTQHvQEH3Q2xQm8lX57S1KLsQ4VhPkg277PGEE1AuoFr8%2CAGkb-H_5LpMu7D92H95KCcY-XdWhC1r5HMKfL1X7HT3ndY1dcCv8Qv6kksLL8Bsd2toWT-9JsIXqevtXUTCX1g&pvsid=4065125558454523&pem=612&ref=https%3A%2F%2Fgyankosh.net%2Fexceltricks%2F&eae=0&fc=1920&brdim=-8%2C-8%2C-8%2C-8%2C1664%2C0%2C1691%2C917%2C1664%2C765&vis=1&rsz=%7C%7Cs%7C&abl=NS&fu=128&bc=31&ifi=8&uci=a!8&btvi=6&fsb=1&xpc=ngPl0BbEdL&p=https%3A//gyankosh.net&dtd=1053

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.
EXCEL:CHOOSE THE IMAGE YOU LIKE
  • RIGHT CLICK the image you like and choose COPY IMAGE.
  • Paste the picture in the sheet.
EXCEL: PASTING THE CHECK MARK IMAGE IN THE EXCEL 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.

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 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.
EXCEL:OPEN SYMBOL DIALOG BOX
  • In the FONT DROP DOWN LIST choose WINGDINGS font.
  • Enter 0252 in the CHARACTER CODE. The Check Mark will be selected.
EXCEL: INSERT CHECK MARK FROM SYMBOL DIALOG BOX
  • 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

     =CHAR(252) and press ENTER. The symbol will be inserted.

EXCEL:INSERTING CHECK MARK CHARACTER USING 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.
EXCEL: OPENING SYMBOL CHOOSE BOX IN EXCEL
  • Now select the character whose ASCII CODE or CHARACTER CODE you want to know.
  • The character code window is shown below.
EXCEL: SEARCHING FOR CHARACTER CODE IN EXCEL

5.INSERT CHECK MARK SYMBOL IN EXCEL USING KEYBOARD

There is another very fast method of inserting any character or to be specific CHECK MARK SYMBOL in our case, in the sheet instantly.

KEYBOARD SHORTCUT TO INSERT CHECK MARK IN EXCEL

 Select the WINGDINGS font before using this method. The method is to press ALT and press the CHARACTER CODE WHILE THE ALT KEY IS PRESSED.But for our case, we need to first select the font and then press ALT and press 0252  WHILE ALT IS PRESSED.

EXCEL:CHECKMARK USING KEYBOARD

So these were a few methods of inserting check mark symbol in excel.
Although there can be a few more too but these are the most easiest and useful ones. Because after all, the main aim is to the work fast and efficiently.