Click in the cell where you want to insert the first checkbox (B2 in this example).On the Developer tab, in the Controls group, click Insert, and select Check Box under Form Controls.To insert a checkbox in Excel, execute these steps: The preparation steps are completed, and now we are getting to the main part - add checkboxes to our Party Planning list. If you are creating an Excel checklist or to-do list, the first step is to make a list of tasks or other items for which the check boxes will be inserted.įor this example, I've created the following Party Planning Checklist: Now, with the Developer tab in place, you get access to a host of interactive controls, including Check Box. Under Customize the Ribbon, select Main Tabs (usually it is selected by default), check the Developer box, and click OK.Right-click anywhere on the ribbon, and then click Customize the Ribbon… Or, click File > Options > Customize Ribbon. To add the Developer tab to the Excel ribbon, do the following: Like all other Form controls, the Check Box control resides on the Developer tab, which does not appear on the Excel ribbon by default.
0 Comments
Leave a Reply. |