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 Fotolia.com)

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:
Easy

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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