How to Insert a Check Mark Symbol in Excel

Majority of times, people prefer using Microsoft Excel for making checklists. For making a helpful checklist, the users should the way of adding tick-mark or check mark. Luckily, putting a tick mark is easy in Excel. There are plenty of ways of doing so.

The method of putting a check mark in Excel by using symbols

  1. Firstly, go to MS Excel.
  2. Next, choose the cell in which you wish to put the tick mark.
  3. Then, press on Insert.
  4. After that, choose Symbol.
  5. Next, by using the Font pull-down, choose  Segoe UI Symbol/ Wingdings.

Note: Every Font has its separate tick-mark symbol, so it really depends on the font you are using.

  • Then, choose the tick mark symbol that you would wish to use.
  • After that, remember the Character code number.

Note: Every font kind has a different character code for the tick mark symbol.

  • Next, choose Insert.
  • Then, choose the X option. It shall be towards the upper right-hand side for closing the Symbol window.

The method of putting a check mark by using a keyboard shortcut

  1. Firstly, choose the cell wherever you wish to put the tick-mark.
  2. Then, by using the Font pull-down menu, choose Windings 2.
  3. After that, choose the cell one more time and press the combination of Shift+P buttons.

The method of putting a tick-mark in Excel by using the character code

  1. Firstly, choose the cell in which you want to insert the tick-mark.
  2. Then, choose the Home tab.
  3. After that, by using the Font pull-down, choose the font kind tick-mark that you wish to use.
  4. As soon as you have chosen the Font, write ”=char(character code). “

Note: For Segoe UI Symbol you need to put  ”EOO1;” and for Winding, you have to place ”252.”

More To Read

The method of putting a tick-mark by using AutoCorrect

  1. Firstly, put a tick-mark by using the above-mentioned ways.
  2. Then, you need to copy the cell that has the tick-mark.
  3. After that, press on File.
  4. Next, click on Options.
  5. Then, press on Proofing.
  6. After that, click on AutoCorrect Options.
  7. Go to the ‘Replace’ text area, put the text that you wish to get replaced by the tick-mark symbol.
  8. Then, put the value of the copied cell in the ‘With’ text area.
  9. After that, choose Add.
  10. Next, press on ‘OK’.
  11. Lastly, write the text that has been put in point 4 under the cell wherever you want to place the tick-mark and modify the Font kind that has been mentioned in point 2.

Billy Mark is a self-professed security expert; he has been making the people aware of the security threats. His passion is to write about Cyber security, cryptography, malware, social engineering, internet and new media. He writes for Norton security products at norton.com/setup.