How to insert Checkbox in excel to simply click and tick it?
If you're using Excel 2007, you need to have access to the Developer Tab - in
Office button/Excel Options/Popular, the 3rd checkbox is Developer tab. Once
you see the tab, in the Controls group, you'll see Insert dropdown - the top
section is your forms controls (including checkbox) and the bottom section is
your activeX controls (including checkbox). I recommend forms control
checkbox.
By the way, to know if it's clicked or not, you should use the format
control & assign the checkbox to a cell; then if it's checked, the cell will
have TRUE, else it'll have FALSE.
"Keegan" wrote:
I just wanted to know how I can create a Check Box in Excel where I can
simply chick the box and it gets Ticked.
|