Comments on: 6 ways to insert a tick symbol and cross mark in Excel

The tutorial shows 6 different ways to insert a tick in Excel and explains how to format and count cells containing checkmarks. Continue reading →

Table of contents

Comments page 2. Total comments: 46

  1. HI FRIEND
    PLS HELP
    WHAT IS THE NAME OF ONE CELL AND MANY THINGS SELECTABLE EXAMPLE (BIKE,CAR,BUS,TRAIN)ETC

  2. good

  3. i am trying to put a check mark to a cell with a value ranging from 50 to 74. exampla 63, a check mark should be placed because it is between 50 to 74. How can I do it. I already know how to put a check mark for a value greater than or less than a single value not not value in range like 50 to 74. kindly help on this. Thank you

  4. So glad. This site is very useful.

  5. How to remove tick from the excel?

    1. Hi Priya,

      Like any other character, a tick symbol can be deleted with the Delete key. If it is a checkbox you want to remove, then click on the checkbox while holding the Ctrl key to select it, and then press Delete.

  6. I am not getting proper symbols of tick mark and cross.
    I am getting P and O in validation drop down list.

    Can any one help?

  7. very nice

  8. Hi help pls. Given that there are already checkboxes. How can i put a check symbol to any of those boxes if I just simply click on the box. TIA

  9. Hello,

    I need to tick anyone column based on condition ....
    for example : Status column contains two sub columns Active and On-Hold
    I need to check anyone of those two columns.
    If one is checked user should not be able to check/tick other sub-column.
    That two columns should accept only tick symbol.
    Please help me

    Thanks in prior..:)

    1. Hello, Tharun,

      since the checkboxes don't exclude one another by default, you will most likely need to use some VBA code. Feel free to ask around MR Excel forum for that.
      You can also try to modify this one for your needs.

      Hope this helps!

  10. This is really helpful

  11. If I have inserted a lot of symbols, what is the easiest way to remove or delete these symbols.

    For now have to remove 1 by by.

    Please advice. Thank you.

  12. I really appreciate your support in this thread.

  13. I need to make a tick mark or check mark that consists of dots. In other words the check is made with small dots (a broken line). Do you have any suggestions?

    Thanks!
    Cheryl

    1. HI
      YOU CAN USE THIS : Alt+7

  14. try

    =VLOOKUP() on the side of your form

  15. Hello,

    I see all you are very supportive, Pls help to solve this.
    i have a data,
    Column A Column B Column C Column D Column E
    FFA Exp Gain 1 Gain 2 Evoporate
    1 125 98% 1% 1%
    2 200 96% 2.5% 1.5%
    3 235 95% 3% 2%
    4 345 93% 5% 2%
    5 430 92% 5.5% 2%
    6 510 90% 8% 1%
    7 740 87% 10% 2%
    so on

    i want when i enter 1,2,3..... in a box my below mention results from above data shows to me, is it possible???
    Exp 125
    Gain 1 98%
    Gain 2 1%
    Evoporate 1%

    Regards,

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)