insert a check box...how?

  • Thread starter Thread starter Tangy
  • Start date Start date
T

Tangy

I want to insert some check boxes in a spread sheet. I just want to be able
to click on the box and have the check appear and click on it again to have
it disappear. I don't want any data related to this box...can this be done?

Thanks
 
View|toolbars|
show the forms toolbar
There's a checkbox on that toolbar.
click on it once

draw a little rectangle where you want the checkbox.

(If you double click on the checkbox, you can draw multiple checkboxes. Click
on that icon or hit the escape key to stop.)

If you hold the alt key while positioning the checkbox, it'll snap-to the cell's
edge.

(experiment with the shift key, too. And ctrl-dragging will copy the checkbox.)
 
Don't think you can.

How about an alternative?

Select your cells that should contain checkboxes:
(click on the first area, ctrl-click on subsequent)

format|cells|number tab|custom category
In the "type:" box, put this:

alt-0252;alt-0252;alt-0252;alt-0252

But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.

It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)

And format that range of cells as Wingdings.

And then use whatever font color you want.

alt-251, alt-252, alt-253, and alt-254 all are different "styles" of checkboxes.

Then to check the box, just hit the spacebar (or any character).
 
Back
Top