Prev: Subtotals in Excel 2007 TABLES
Next: Formula mismatch in Excel 2003 & 2007
From: jimc on 16 Dec 2009 23:15
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!
From: Jacob Skaria on 16 Dec 2009 23:23
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

--
Jacob


"jimc" wrote:

> 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!
 | 
Pages: 1
Prev: Subtotals in Excel 2007 TABLES
Next: Formula mismatch in Excel 2003 & 2007