Microsoft Excel is a great way to keep track of data and then manipulate and analyse 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.
Click the "Developer" tab.
Select "Check Box" under the Active X controls.
Click where you want the check boxes to appear on the spreadsheet.
Go back to the "Developer" tab and select "Design Mode." This allows you to design the check boxes.
Go back to the "Developer" tab and select "Properties" to change any properties for the check boxes.