How do I insert a check box in Excel Vista? I'm a novice

J

jimc

I would like to use a check box rather than inserting a symbol (tick) into
the cell. is this possible with Excel Vista? I'm not a programmer so the
solution needs to be simple!
 
J

Jacob Skaria

For XL2003..from menu View>Toolbars>Control Toolbox>Double click the
checkbox>click the worksheet>Click the toolbar checkbox>Close the toolbar

For XL2003..from menu View>Toolbars>Forms>Double click the checkbox>click
the worksheet>Click the toolbar checkbox>Close the toolbar

For XL2007..from the menu bar select Developer tab>then Insert and double
click the Checkbox in the Form Controls section or click and draw the box on
the sheet.

PS: If you cannot find the developer tab in 2007;
1. Click the Microsoft Office Button, and then click Excel Options
2. Click Popular, and then click Show Developer tab in the Ribbon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top