|
1. Select Insert > Form Control > Check Box from the Spreadsheet Editor menu.
2. Double click in the check box or select View > Shape Explorer.
3. Type the text that will appear to the right of the check box
4. Type the address of the cell that will be linked to the check box in the Cell Link text box.
5. Select the initial status of the check box (checked, unchecked, indeterminate).
Notes:
· If the check box is checked, the linked cell value will be TRUE and FALSE otherwise.
· Check box controls will be saved only if you save the workbook file in 97-2003 Excel© format (*.xls)
· To select a check box control, position the pointer over it and press the right mouse button.
Related topics:
Shape Explorer
.png)
Fig. 1: Check box control
|