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 or remove items from an existing drop-down list (also called a drop-down menu or drop-down box).

Create a drop-down list. Add or remove items from a drop-down list. Remove a drop-down list. Lock cells to protect them

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 …

Like a multiple-selection list box, a list box displays all of the items in the list by default. Drop-down list box Like any other list, a drop-down list box offers users a list of choices. However, …

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 …

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

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.

Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list. Examples of controls are list boxes, combo boxes, spin buttons, and scroll bars.

Manage all your mailing addresses in an Excel spreadsheet. When it's saved to your OneDrive, your family and friends can coauthor it, and add or edit entries. Watch the next video to see …