How Do You Insert a Check Box in an Excel Spreadsheet?

To insert a check box in an Excel spreadsheet, enable the Developer tab from Settings. Once the tab is visible, use it to drag and drop a check box.

  1. Enable Developer tab

    Microsoft Excel keeps the Developer tab hidden by default to keep the interface simpler for the user. To enable it, go to Excel Options by clicking the File menu. Once there, click on Customize Ribbon. On the right drop-down menu, select Main tabs. In the check boxes underneath, check Developer.

  2. Locate check boxes in the Developer tab

    When the “Developer” tab is visible, click on it to access its options. Next, click Insert, and in the drop-down menu, find Check Box (Form Control).

  3. Drag and drop the check box

    To implement the setting, simply apply drag and drop to the option in step two.