You can insert form controls like check boxes, option, or toggle buttons to make data entry easier.

To add an option button, select the Developer tab, select Insert, and under Form Controls, select . Click in the cell where you want to add the check box or option button control.

In the Number of option buttons to insert box, in the Insert Option Buttons dialog box, enter the number of options that you want to insert, and then click OK. To change the value that is …

To add a combo box, click the Developer tab, click Insert, and then click Combo Box under Form Controls. Click the worksheet location where you want the upper-left corner of the combo box …

In the sections below, learn how to add a macro to a button in Excel—for Windows or the Mac. Note: ActiveX controls are not supported on the Mac.

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.

If you don't want the formatting to be applied, you can select the Insert Options button after you insert, and choose from one of the options as follows: If the Insert Options button isn't visible, …

Unlike multiple-selection list boxes, users can select only one option from a group of option buttons. In addition, with option buttons, users click a small circle to make a choice instead of …

Add a list box to your Excel worksheet from which users can choose a value. Make data entry easier by letting users choose a value from a combo box. A combo box combines a text box …

Check boxes 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. Insert check boxes Select the range …