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.

Sie können eine Dropdownliste mit gültigen Einträgen (auch Dropdownmenü oder Dropdownfeld genannt) in Excel einfügen, um so die Dateneingabe zu erleichtern oder die Eingabe auf …

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.

Select the same number of cells above which you want to add the new ones. Right-click the selection, and then select Insert > Shift cells right or Shift cells down.

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 …

To create a form in Word that others can fill out, start with a template or document and add content controls. Content controls include things like check boxes, text boxes, and drop-down …

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

To add a new data connection, click Add, and then follow the instructions in the Data Connection Wizard. The entries in the list box must be associated with a particular repeating field or …

1. Click the arrow to display the drop-down list. 2. Click an option in the drop-down list. List boxes and combo boxes can be bound or unbound controls. These controls can look up values in a …

Under Insert controls in the Controls task pane, click Drop-Down List Box. When a user fills out a form that is based on your form template, the selection in this drop-down list box will determine …