Create Drop-Down List in Excel Using Data from Cells
Suppose you have a column of cells as displayed below:
Here are the steps toward making an Excel Drop Down List:
Step 1: Select the Cell
Select Cell where you need to make the drop-down list.
Step 2: Go to the Data Tab and Select Data Validation in Data Tools Group
Go to Data –> Data Tools –> Data Validation.
Step 3: Select List as the Validation Model
In the Data Validation popup, inside the Settings tab, select List as the Validation Criteria.
- When you select List, the Source field shows up.
- In the source field, enter =$A$2:$A$6, or essentially click in the Source field and select the cells utilizing the mouse and snap OK.
- This will then embed a drop-down list.
Step 4: Preview the Drop-Down List in Excel
Ensure that the In-cell dropdown choice is checked (which is checked, by default). On the off chance that this choice is uncontrolled, the cell doesn’t show a drop-down. In any case, you can physically enter the qualities in the rundown.
How to Create a Drop-Down List in Excel
A drop-down list offers users a selection from predefined options, commonly used on sites/applications for easy navigation. Dynamic arrays in Excel 365 allow us to create drop-down lists quickly, without complex setups.