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 with a list box to …

Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list.

Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a …

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.

When you want to display a list of values that users can choose from, add a list box to your worksheet. Create a list of items that you want to displayed in your list box like in this picture. Click Developer > …

To add a list of numbers, select the cell below a column of numbers, and then click AutoSum.

Add a bullet to a cell in a worksheet using character codes or symbols. In addition to a round bullet, you can choose to add a checkbox or other symbol.

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). Watch …