Saturday, April 20, 2013

How to Make a Cell in Excel 2007 Act Like a Checkbox


1. Open the Excel worksheet you want to modify by adding in a check box. Navigate to the 'Developer' tab in the ribbon at the top of the window.
2. Click the 'Insert' icon in the 'Control' heading to bring up a drop-down menu. Select the 'Check Box' icon in the 'Form Controls' grouping.
3. Locate the cell that needs to act as a check box. Click the cell to create the new check box. Click the outline of the box and drag it to any other cell if you need to move it.
4. Highlight the text that reads 'Check Box 1' and press the 'Backspace' key. Type in the text you want to appear next to the check box. Click any other cell to save the check box and the new text.
5. Right-click the check box if you need to make any changes. Choose 'Edit Text' to change the text displayed next to the box or choose 'Cut' to delete the check box entirely.

Blogger news