DISCOVER
×

How to Insert a Check Box on an Excel Spreadsheet

Updated March 23, 2017

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.

Click "Insert."

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.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Carter McBride started writing in 2007 with CMBA's IP section. He has written for Bureau of National Affairs, Inc and various websites. He received a CALI Award for The Actual Impact of MasterCard's Initial Public Offering in 2008. McBride is an attorney with a Juris Doctor from Case Western Reserve University and a Master of Science in accounting from the University of Connecticut.