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.

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 …

In Excel for the web, you can only edit a drop-down list where the source data has been entered manually. If the Source box contains drop-down entries separated by commas, then type new …

To remove a drop-down list, click the cell with the list, then click Data > Data Validation, and then on the Settings tab, click Clear All, then OK. A drop-down list is also known as a drop-down …

In the Multiple Selection List Box Properties dialog box, you can type the entries yourself or configure the multiple-selection list box to retrieve entries from a database or other data source.

For example, if you have a check box in cell A1, you can use a formula like =IF (A1, "Checked", "Unchecked") to display a custom message based on the check box's state.

A combo box is a text box with a list box attached. This type of control enables users to select a predefined value in a list or type their own value in the text box portion of the control.

In the Drop-Down List Box Properties dialog box, you can type the entries yourself or configure the drop-down list box to retrieve entries from a database or other data source.

Use the commands in the Filter drop-down list to quickly display a subset of names. Selecting each command toggles the filter operation on or off, making it easy to combine or remove …

To use the drop-down box or combo box, click any cell so that the object is not selected. When you click an item in the drop-down box or combo box, cell G1 is updated to a number that …