Checkbox in excel is a very handy tool for creating the checklist or simple user forms. There is no need of any Excel VBA knowledge to insert Checkbox into a excel sheet. This is increase the speed at which user enters data as well as it reduces the chances of misspellings which will give trouble in formulas or pivot tables. So lets start learning how to insert Checkbox in Excel.
Step to Add Check box to Excel Sheet
1. To use Checkbox, you need add it to your ribbon, if it is not already available. To Do this, Go to File->Excel Options->Select Show Developer tab in the Ribbon option if you are using excel 2007. If you are using Excel 201o, then go to File->Options->Customize Ribbon. In the list of main tabs select the Developer check box. Choose Ok to close the Options Dialog Box. This works work well for Excel 2o13 on enabling the developer tab in ribbon.
2. Once Developer Tab is enabled, go to Developer->Selects Chekbox under form controls.
3. Now you can place the Check box where ever you want in your excel sheet.
4. Once you placed the Check-box, left click on your mouse and choose Format Control option.
5. Go to Control Tab. Here you can choose the default value of the check box whether it is Unchecked or Checked or Mixed. If it is checked the output will true and if it is unchecked the output will be False.
6. The Cell Link refers to the cell on which you want the output to displayed(True or False).
Leave a Reply