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.

Microsoft Surface Pro 4 review: Hands-on with the new generation of Surface

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

Crowdfunding for world’s first 3D camera-computer found in 30 hours

2015 iMac release date rumours, specs, price & features: new 21in 4K Retina iMacs coming next week