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.

After you create a drop-down list, you might want to add more items or delete items. In this article, we'll show you how to do that depending on how the list was created.

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 …

Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). …

A multiple-selection list box is list of choices that looks like a scrollable list of check boxes instead of a typical list box. Users can select as many check boxes as necessary from the list.

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 …

Enable users to enter dates of their choice on a form, such as start and end dates for a particular project. Use the today and now functions to show today's date and time on a form.

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 …

Drop-down list box Like a combo box, a drop-down list box enables users to select a value in a list that is hidden on the form by default. However, with a drop-down list box, users cannot add …

You can use Formula AutoComplete in the middle of an existing nested function or formula. The text immediately before the insertion point is used to display values in the drop-down list, and …