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 …

Drop-down list box Like any other list, a drop-down list box offers users a list of choices. However, with drop-down list boxes, the list entries are hidden until the user clicks 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.

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 …

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

On the Data tab, click Format. In the Display the date like this list box, in the Date format dialog box, click the display format that you want. Note: You can change the display format of the …

U kunt een vervolgkeuzelijst met geldige items (ook wel een vervolgkeuzemenu genoemd) invoegen in Excel om de gegevensinvoer te vereenvoudigen of om de invoer te beperken tot …