How To Insert Checkbox in MS Excel
Checkboxes are the buttons that allow us to select one or multiple options available for a given data. Checkboxes are the type of form controls used for making data entry easy. These checkboxes are good for creating a form with several options. For adding a checkbox in the excel worksheet, just need to follow some guided steps.
For inserting a checkbox in a worksheet, we need to enable the Developer options in MS Excel. The steps may vary as per the MS Excel versions . There are the following steps one need to use for adding a checkbox in the worksheet in MS Excel 2010 on Windows 10:
Step 1: Open [MS Excel] on your computer system by simply searching on the search tab or by directly clicking on the MS Excel icon (if present on the desktop), as you can see in the below snapshot:
Step 2: The first thing is to enable the Developer option in the Excel worksheet, and for doing so, follow these steps:
- Click on File , and under Help , click on ‘Options’ as shown in the below snapshot:
- A window will open from which select and click on Customize Ribbon as shown in the below snapshot:
- Under Main Tabs , you will notice all the checkboxes would be selected already except the Developer checkbox, as you can show in the below snapshot:
- Click on the Developer checkbox and press OK .
Step 3: The Developer tab is enabled. Click on the Developer tab on the toolbar, which is next to View , as you can see in the below snapshot:
Step 4: In the Developer tab, you will see the Insert option, as you can see in the below snapshot:
Step 4: Under Insert , click on Form Controls and click on the Checkbox symbol, as you can see in the below snapshot:
Step 5: Now, choose the cell in which you want to add the checkbox, and the checkbox will get inserted in the cell as shown in the below snapshot:
Step 6: But one should know that we can add only one checkbox at a time. For adding more checkboxes, copy the existing checkbox and paste it to the other cell and continue till you fulfill your need.
Step 7: If you want to edit or delete the default text for a control, click the control and update the text.
Note: One should know that a user cannot edit the size of the control and its distance from the text.
Formatting Options
We can edit and customize the checkbox and make it as per our requirement by following the below-described steps:
Step 1: Move the cursor on the checkbox, and right-click on it, and a list of options will be displayed, as you can see in the below snapshot:
Step 2: Then click on the Format Control , and the Format Control dialog box will open as shown in the below snapshot:
Step 3: Under the Format Control dialog box, click on the Control tab (the last option), as you can see in the below snapshot:
Step 4: The Control tab allows the following modifications:
- Checked: It displays the selected option button.
- Unchecked: It displays the cleared option button.
- Cell Link: It takes a cell reference that carries the current state of the option button.
- 3-D Shading: The option is used for applying 3D effects to the inserted checkbox/checkboxes.
Step 5: After applying formatting, click OK .
Other modifications a user can make as per the presentation and appearance the user needs.