Thread: How to add Checkbox in Microsoft Excel

Microsoft Excel has a lot of great features which we are don’t know. You can add check boxes in Excel. Check boxes can be utilized to specify an opposite and choice. You can check over one check box at a time in an Excel sheet to show the options.
To add check boxes in your Excel sheets, follow the given steps:

1. Open Microsoft Excel 2007. Firstly, we have to add the Developer tab show in Excel 2007. If it’s not enabled, click on the Office button.

2. after that, go to Excel Options.

3. In the Popular tab, check Show Developer tab in Ribbon checkbox and click OK.

4. Then Go to the Developer tab, click on Insert and in Form Controls, you will see a checkbox icon.

5. Once you click the check box icon and then Click where you want to add the checkbox.

6. Now, right click on the control and go to Format Control

7. Under Value, choose the initial state of the check box.

7. In Cell Link, choose the cell in which you would like to show the status of checkbox and click Ok.


9. Keep in mind, when the checkbox is chosen, the linked cell shows a TRUE value. Then again, if it’s cleared, it will show a FALSE value.

10. Right click on the checkbox and click Edit Text to change the text of the check box.

so complex