How to Insert a Tick into a Google Spreadsheet

Want to insert a tick mark, like this ✓, into a Google Spreadsheet?

It’s easy, just copy this tick ✓ and paste it into a cell. Or if you’d prefer it heavy, copy this check mark ✔.

Sometimes such simple things can be deceptively difficult. I hope this helps others.

Advertisements

About Brent

Born to code.
This entry was posted in Blogdex and tagged , , , . Bookmark the permalink.

24 Responses to How to Insert a Tick into a Google Spreadsheet

  1. colin says:

    Guys … you need the Wingding font, which isn’t on Chrome. Reports are that it is on IE … but I couldn’t find it on my version. I even tried the process above – doesn’t work for me.

    But … if you go to Word or maybe even the tick above and copy then go to the Google docs spreadsheet & type a character in the cell you want (lets say ‘1’), then go to Find & Replace in the Edit menu of Google docs spreadsheet and Find ‘1’ & Replace with (paste tick into the box) … press Replace/Replace All & … Hey Presto! it works.

    Life would be easier if Google just added the Wingding font!

    Hope this helps.

    Colin

    • Brent says:

      Thanks Colin. I would have thought Chrome used any fonts available on the Operating System, so if Wingding’s was available to IE it should be available to Chrome. But perhaps there is something funny going on…

  2. Fare says:

    the copy/paste worked perfectly for me! thank you

  3. Kat says:

    thank you

  4. Romi Chakraborty says:

    I type option v to insert tick. See if this works.

  5. Sophie says:

    What about an x ?

  6. Cory says:

    Is there a way to add a value to an empty cell, so that on a tablet i can touch the empty box and put a check mark in it?

  7. joseph001 says:

    Thank you! Just spent an hour on this. Bought a new chromebook, uploaded an xls to google sheets. Google HELP has instructions that are incorrect. “insert” “equation”

    or “view” “equation bar”

    neither exists in my version of google sheets

    thanks again

  8. Joe Loth says:

    We were easily able to add the check mark(thank you/with copy and paste from here)- however when we added the lightening bolt or bomb symbol – it changes the entire font within the cell- this did not happen with checkmark- any advice

  9. Guy Balzac says:

    Thanks!

  10. Clifford says:

    Try out
    =char(10003) and
    =char(10005)

  11. ARB says:

    enter =char(10004) into the cell.

  12. =char(10006) is a big ✕ cool 😉

  13. Ken Seehart says:

    I’ve set up my spreadsheet to convert a singleton “/” to “✓”. So if the user enters a “/” into a cell, it instantly turns into “✓”. Of course you could set this up to work with any character you want.

    function onEdit(e) {
    if (e.value == “/”) e.range.setValue(“✓”) // e.value is only set when a single cell was edited
    }

    • Ken Seehart says:

      BTW, that’s a unicode ✓
      There are various ways to find unicode characters like this:
      1. You can copy the character from here, or wherever you see it,
      2. You can search for it on google (in this case, “unicode tick” or “unicode check mark”)

    • Noel says:

      Could you please in detail, where do you enter that script in google spreadsheet?

  14. James says:

    Ha, the first thing I did when I saw this brilliant creative solution was: LOL! So plain and simple, but apparently too hard for Google to implement.

  15. ceinwen says:

    Thank you! I felt like an idiot, but I also feel great that it was so easy and now I can tick off the things on my to-do list. Brilliant.

  16. anomie2 says:

    Thank you for mentioning it is Unicode!
    Here is your unicode star! ★

  17. prada cosmetic bag
    I drop a leave a response when I appreciate a
    article on a site or if I have something to contribute to the conversation.
    It’s caused by the sincerness displayed in the post I
    looked at. And on this post How to Insert a Tick into a Google Spreadsheet | i blog.
    I was moved enough to drop a thought 😉 I do have 2 questions for you if you don’t mind.

    Could it be just me or do a few of these responses look like they are coming from brain dead
    visitors? 😛 And, if you are posting at other online social sites, I would like to
    follow everything new you have to post. Would you make a list every one of
    your shared sites like your linkedin profile, Facebook page or
    twitter feed?

  18. duettists says:

    But, once you nail it, photographing your items will be a quick and
    painless task. Digital photography is an psychological and user-friendly procedure for me.
    As I got older I really wanted a nicer camera so I bought one and couldn’t
    wait to get the pictures developed asap.

  19. There’s definately а lot to know about this toρic. I like
    all of the points you made.

Comments are closed.