
Add or remove items from a drop-down list - Microsoft Support
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 entries …
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.
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 …
Add a list box or combo box to a worksheet in Excel
Right-click the combo box and pick Properties, click Alphabetic, and change any property setting that you want. Here's how to set properties for the combo box in this picture:
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 …
Add, edit, or delete list items - Microsoft Support
Select the circle next to the item you want to edit, right click, and then select in the dropdown. If you want to edit multiple items, select the circle for both items.
Filter data in a range or table in Excel - Microsoft Support
How to use AutoFilter in Excel to find and work with a subset of data in a range of cells or table.
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 …
Insert a multiple-selection list box - Microsoft Support
To change the width of several multiple-selection list boxes at once, select the multiple-selection list boxes whose size you want to change, press ALT+ENTER, click the Size tab, and then in the Width …
Sort data using a custom list - Microsoft Support
Sort a list by days of the week or months of the year or sort by priorities in Excel. Or you can create your own custom list for items that don't sort well alphabetically.