How to Insert a Check Box on an Excel Spreadsheet

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Insert a Check Box on an Excel Spreadsheet
Use check boxes to help organise data collection in Excel. (laptop image by Angie Lingnau from

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.

Skill level:


  1. 1

    Click the "Developer" tab.

  2. 2

    Click "Insert."

  3. 3

    Select "Check Box" under the Active X controls.

  4. 4

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

  5. 5

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

  6. 6

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

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.