How Do You Put a Tick in a Cell in Excel?

  axelbrora 14:46 PM 04 Jul 06

Anyone know how to put a tick in a cell in Excel.

A simple manual entry is all that is required. I am currently using the insert/symbol and selecting the square root sign which is the nearest thing I can find to a simple tick.

Is there a better way and something that looks closer? I would have thought that this should be a keyboard symbol.


  VoG II 14:49 PM 04 Jul 06

View > Toolbars > Forms and insert a CheckBox. Click it to tick/untick it.

  Belatucadrus 14:54 PM 04 Jul 06

There's a tick in Wingdings that you should be able to use with insert character.

  VoG II 14:55 PM 04 Jul 06

CheckBox with pictures click here#

  exdragon 18:45 PM 04 Jul 06

Thanks, VoG™ - that's going to be so handy!

  Simsy 08:15 AM 05 Jul 06

says Wingdings, he's nearly right...

the font is "Webdings", and it's the letter "a", (lower case)



  Belatucadrus 11:18 AM 05 Jul 06

No he's exactly right, Wingdings character code OxFC is a tick

  Simsy 22:39 PM 05 Jul 06

I didn't know it was there... but webdings "a" is easier!

How does one enter using the character code?



  VoG II 22:44 PM 05 Jul 06

It's much easier to enter a CheckBox. This is what MS intended and it can be acted on with simple formulas or code. How do you query a cell that contains a tick otherwise?

  GaT7 23:58 PM 05 Jul 06

If you don't need to query a cell, you can actually draw one using the Drawing Toolbar, then use copy+paste to replicate it. It's what I do anyway - click here. G

  casper69 07:42 AM 06 Jul 06

anyone know if the checkbox selection is on pocket pc excel mobile software cheers


This thread is now locked and can not be replied to.

Best Cyber Monday deals 2015 live blog: Best UK Cyber Monday tech deals, sales, discounts & offers

1995-2015: How technology has changed the world in 20 years

Harry Potter's graphic designers showcase magical props & posters in new exhibition

Apple rumours & predictions 2016: What to expect from Apple in 2016