Friday, October 28, 2011

How to Convert True


1. Click the 'Developer' tab at the top of an Excel worksheet. Then click the 'Insert' drop-down menu in the 'Controls' group.
2. Click the check box image in the 'Form Controls' section of the drop-down menu. This changes your mouse pointer to a cross.
3. Click anywhere in the worksheet to insert the check box with a description next to it.
4. Right-click the description next to the check box, then left-click the description until you see a blinking text cursor.
5. Press 'Backspace' or 'Delete' to erase the description that is automatically shown. Then type your own description. Click outside the description area in a blank cell when you are finished. For example, type 'Sales quota met?' as a description.
6. Right-click the check box, and click 'Format Control' on the pop-up menu to bring up a 'Format Control' window.
7. Click the 'Control' tab at the top of the window.
8. Click in the 'Cell link' text box and type the cell to which you want to link the check box. For example, click in the cell link text box and type 'A1.' Cell A1 will now show either 'TRUE' or 'FALSE' depending on whether the check box is checked or unchecked.
9. Click 'OK' to close the 'Format Control' window.

Blogger news