Tick box or symbol`

  • Thread starter Thread starter NicKC
  • Start date Start date
N

NicKC

Hi

Is it possible to insert a standard tick in an excel cell?
Better still, is it possible to have tick boxes?
I know there are special fonts with them but the spreadsheet I am working on
will be used by many different peolpe who may not have strange fonts.

Thanks for any help.

Nick
 
Hi Nick

No. Those objects float above the spreadsheet on the so called "drawing
layer".
 
Hi

Try Wingdings2 font and the letter P This is a fairly standard font, so
shouldn't cause too many problems.

Andy.
 
Nick, tick boxes (I call them "check boxes") are on the Forms toolbar. As
Harald pointed out in his reply, a check box does float above the worksheet
but you can tie it to a cell by right-clicking it and selecting Format
Control. On the Control tab, enter a cell address in the Cell Link field.
Result: When the user checks the box, linked cell says "TRUE;" otherwise it
says "FALSE."

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com
 
Back
Top