Using Checkboxes in Excel - Microsoft Support
Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. To insert Checkboxes: Select the range where you want checkboxes. Select Insert > Checkbox. To remove checkboxes: Select the range of cells with the checkboxes you want to remove.
Add a check box, option, or Toggle button (ActiveX controls)
You can insert form controls like check boxes, option, or toggle buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice.
Overview of forms, Form controls, and ActiveX controls on a …
You can select more than one check box on a worksheet or in a group box. A check box can have one of three states: selected (turned on), cleared (turned off), and mixed, meaning a combination of on and off states (as in a multiple selection).
Group, copy, move, or align controls on a worksheet
After you add Form and ActiveX controls to a worksheet form, you may want to group, copy, move, or align controls to create a well designed, user friendly form. To perform any of the procedures in this article, if one or more controls is an ActiveX control, you must first make sure that the Developer tab is available. Display the Developer tab.
Form controls - Microsoft Support
You can insert form controls such as check boxes or option buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice.
Add a group box or frame control to a worksheet - Microsoft …
You can use a group box or a frame control to group related controls (such as option buttons, check boxes, or closely related contents) into one visual unit. Group boxes and frame controls are rectangular objects with optional labels.
Add a list box or combo box to a worksheet in Excel
You can make data entry easier by letting users choose a value from a combo box. A combo box combines a text box with a list box to create a drop-down list. You can add a Form Control or an ActiveX Control combo box. If you want to create a combo box that enables the user to edit the text in the text box, consider using the ActiveX Combo Box.
Edit text in a control on a worksheet - Microsoft Support
You can edit the text that is displayed in a Form control or ActiveX control, such as a label or help information, and you can edit the alternative text description for a control. What do you want to do? Select the Form control. For more information, see Select or deselect controls on a …
Create a drop-down list - Microsoft Support
You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
Use slicers to filter data - Microsoft Support
In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK. A slicer will be created for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable.
Track changes in a Shared Workbook - Microsoft Support
In the Share Workbook dialog box, on the Editing tab, select the Allow changes by more than one user at the same time check box. Click the Advanced tab. Under Track changes , click Keep change history for and, in the days box, type the number of days of …