How to Use a Cell as a Checkbox in Excel 2007

By Greg Lindberg

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 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.

Step 2

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

Step 3

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

Step 4

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

Step 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.

Step 6

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