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

  axelbrora 14:46 04 Jul 06
Locked

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.

Axel

  VoG II 14:49 04 Jul 06

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

  Belatucadrus 14:54 04 Jul 06

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

  VoG II 14:55 04 Jul 06

CheckBox with pictures click here#

  exdragon 18:45 04 Jul 06

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

  Simsy 08:15 05 Jul 06

says Wingdings, he's nearly right...

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

Regards,

Simsy

  Belatucadrus 11:18 05 Jul 06

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

  Simsy 22:39 05 Jul 06

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

How does one enter using the character code?

Regards,

Simsy

  VoG II 22:44 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 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 06 Jul 06

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

Advertisement

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

Should I upgrade to Windows 10? Why upgrade to Windows 10? Is Windows 10 good? The pros and cons of!…

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

Illustrator Rachel Lillie discusses how she draws, and the beauty of quietness

macOS Sierra vs Windows 10 comparison: Apple and Microsoft's latest OS releases go head to head |…