Sunday, January 13, 2013

How to Use a Cell as a Checkbox in Excel 2007


1. Open the Microsoft Excel 2007 file to which you want to add checkboxes, then click on the “Microsoft Office” button. Click on “Excel Options” at the bottom of the window.
2. Click to select the box next to the “Show Developer tab in the Ribbon” field, then click “OK.”
3. Click on the “Developer” tab, then click “Insert” in the “Controls” group. Select the “Check box” option from the “Form Controls” section.
4. Use your mouse to select the cell in your worksheet in which you want the checkboxes to appear.
5. Click the “Developer” tab again and select “Properties.” Click the box next to the “Checked” field to make sure a check mark can be displayed in your added checkboxes.
6. Click “OK” and the checkboxes will be added to your worksheet.

Blogger news