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.
this is 
i blog 
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
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…
the copy/paste worked perfectly for me! thank you
thank you
I type option v to insert tick. See if this works.
What about an x ?
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?
Hi Cory, this template is the closest thing I’ve found for being able to do that.
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
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
Thanks!
Try out
=char(10003) and
=char(10005)
enter =char(10004) into the cell.
=char(10006) is a big ✕ cool 😉
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
}
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”)
Thanks for sharing Ken! 🙂
Could you please in detail, where do you enter that script in google spreadsheet?
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.
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.
Thank you for mentioning it is Unicode!
Here is your unicode star! ★
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?
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.
There’s definately а lot to know about this toρic. I like
all of the points you made.