How do I add a check box to an Excel spreadsheet?

cwoody
cwoody used Ask the Experts™
on
How do I add a check box to an Excel spreadsheet?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006

Commented:
Hello Cwoody,

you can try

-on the toolbar rightclick
-choose forms or controltoolbox
-there's a checkbox on both
-you can click it and place on your sheet

HAGD:O)Bruintje
Hey Cwoody,

Follow the instructions above but when you finally get the checkbox to appear you will then have to set it up to work.  Make sure the little pencil and ruler icon is clicked, right click the checkbox and select properties.  These are very important to understand.  For this type of box the main properties will be the caption on the box and the linked cell.  The linked cell is the cell that will receive the data.  You can than analyse the data from that cell however you may desire.  Most people place the box where they want and make the linked cell whatever cell the box covers.  

Hope this helps!

Bill
Hi cwoody,
No comment has been added lately (118 days) and it's time to clean up this Topic Area.
If this question isn't revived and no action is taken I will leave a recommendation in the Cleanup topic area that this question is:

RECOMMENDATION: Award points to billpolnick

Please leave any comments here within the next seven days.
This will be finalized by a moderator and he will use those comments to make his final decision.

-- PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER ! --

Paulo
Cleanup Volunteer
Per recommendation

RotaredoM
CS Mod @ EE

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial