How to Insert a Check Box on an Excel Spreadsheet

By Carter McBride

Microsoft Excel is a great way to keep track of data and then manipulate and analyze the data. One way to input data is using a check box. Microsoft Excel can track data based on a user checking a box or not checking a box. You can have multiple options with check boxes. These boxes are particularly useful if you want to create a form and capture user submitted data from the form.

Step 1

Click the "Developer" tab.

Step 2

Click "Insert."

Step 3

Select "Check Box" under the Active X controls.

Step 4

Click where you want the check boxes to appear on the spreadsheet.

Step 5

Go back to the "Developer" tab and select "Design Mode." This allows you to design the check boxes.

Step 6

Go back to the "Developer" tab and select "Properties" to change any properties for the check boxes.