Sunday, October 14, 2012

How to Put a Check Box in Excel 2003


1. Open the specific Excel 2003 worksheet that needs to have a check box added. Locate the 'Forms' toolbar at the top of the screen, which shows a series of boxes corresponding to different forms available to be created.
2. Click the 'Check Box' icon in the 'Forms' toolbar, which shows a square blue box with a black check mark. Click the starting point anywhere inside the spreadsheet where you want the check box to appear. Drag your pointer down and toward the right to set the borders of the check box. Release your mouse button to create the check box.
3. Click the 'Check Box 1' text appearing next to the box and type whatever label you'd like to use for the box. Click the 'Control Properties' icon located in the 'Forms' toolbar to open a new window containing the check box's properties.
4. Navigate to the 'Control' tab. Type the name of the cell that should correspond to the check box in the 'Cell Link' box. For instance, if you want the box to be checked in correlation to data stored in cell 'A4,' type 'A4' in the box. Click the 'Checked' or 'Unchecked' radio button to change whether the box should check or uncheck when data is entered into the corresponding cell.
5. Click 'OK' to save your changes. If you need to make changes to the check box in the future, click the box and then click the 'Control Properties' button.

Blogger news