Make sure the items are.
How to create drop down list in excel from a table. Web for example, in cell c2, the data validation formula would be: Web how to create a dropdown list there are several ways to populate list. Select one or more cells.
Web on the data tab, in the sort & filter group, click advanced. Select the range of cells, and. Web list the items for the dependent list, and then select the cells.