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
View > Toolbars > Forms and insert a CheckBox. Click it to tick/untick it.
There's a tick in Wingdings that you should be able to use with insert character.
CheckBox with pictures click here#
Thanks, VoG™ - that's going to be so handy!
says Wingdings, he's nearly right...the font is "Webdings", and it's the letter "a", (lower case)Regards,Simsy
No he's exactly right, Wingdings character code OxFC is a tick
I didn't know it was there... but webdings "a" is easier!How does one enter using the character code? Regards,Simsy
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?
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
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 phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.