
Create a drop-down list - Microsoft Support
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 a drop-down list - Microsoft Support
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.
Insert a multiple-selection list box - Microsoft Support
After you insert a multiple-selection list box on your form template, you must specify the values that you want to appear in it. Otherwise, users will see an empty box when they open a form that is based on …
Remove a drop-down list - Microsoft Support
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 box or drop …
Insert a drop-down list box - Microsoft Support
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.
Erstellen von Dropdownlisten - Microsoft-Support
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 bestimmte, …
Add a list box or combo box to a worksheet in Excel
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 …
Create a cascading list box - Microsoft Support
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 the …
How to use the forms controls on a worksheet in Excel
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 indicates the …
Menu Shapes - Microsoft Support
New, Open, and Save As are examples of drop-down menu items. They are connected to each other to create a column of commands when the user clicks the top-level menu item.