|
- 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
If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you To add an item, go to the end of the list and type the new item
- 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 drop-down list You can add a Form Control or an ActiveX Control combo box
- Insert a multiple-selection list box - Microsoft Support
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, with drop-down list boxes, the list entries are hidden until the user clicks the control Users can select only one item from a drop-down list
- 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, von Ihnen definierte Einträge zu beschränken
- Insert a drop-down list box - Microsoft Support
Under Insert controls, click Drop-Down List Box If you cleared the Automatically create data source check box in step 3, select a field in the Drop-Down List Box Binding dialog box to which you want to bind the list box To add a label to the control, type text above or to the left of the control, followed by a colon (:)
- Sort data using a custom list - Microsoft Support
From the Order drop-down, select Custom List In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet Create your own custom list Follow these steps to create your own custom list for sorting: In a column of a worksheet, type the values to sort by
- Apply data validation to cells - Microsoft Support
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 more in this video
|
|
|