We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

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


axelbrora

Likes # 0

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

Like this post
VoG II

Likes # 0

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

Like this post
Belatucadrus

Likes # 0

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

Like this post
VoG II

Likes # 0

CheckBox with pictures click here#

Like this post
exmpdragon

Likes # 0

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

Like this post
Simsy

Likes # 0

says Wingdings, he's nearly right...

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

Regards,

Simsy

Like this post
Belatucadrus

Likes # 0

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

Like this post
Simsy

Likes # 0

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

How does one enter using the character code?

Regards,

Simsy

Like this post
VoG II

Likes # 0

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?

Like this post
Crossbow7

Likes # 0

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

Like this post
casper69

Likes # 0

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

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

45 Best Android games: top Android games for your smartphone or tablet in 2014 (24 are free!)

IDG UK Sites

How Apple, Adobe, Microsoft and others have let us down over UltraHD and hiDPI screens

IDG UK Sites

Do you have the X-Factor too? Mix Off app puts fans in the frame

IDG UK Sites

iPad Pro release date, rumours and leaked images - 12.9 screen 'coming in 2015'