How to Use a Cell as a Checkbox in Excel 2007

If you want to create an electronic form used to check specific options, you can easily added checkboxes to the spreadsheet of your Microsoft Excel 2007 file. Using the Developer features, you can specify where you want the checkboxes to be added in your file and how you want users of your form to select them. Before you add your checkboxes, you can set up your worksheet with questions and a section heading to create your form.

...

Step

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.

Step

Click to select the box next to the “Show Developer tab in the Ribbon” field, then click “OK.”

Step

Click on the “Developer” tab, then click “Insert” in the “Controls” group. Select the “Check box” option from the “Form Controls” section.

Step

Use your mouse to select the cell in your worksheet in which you want the checkboxes to appear.

Step

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.

Step

Click “OK” and the checkboxes will be added to your worksheet.