ADVERTISEMENT
How to Create Drop Down list in Excel | Dependent Drop Down list | List In Excel
Description
Using drop-down lists to restrict what users can enter in cells makes data entry faster and more accurate. When someone selects a cell, a dropdown list down arrow appears that they can click to select.
Steps:
1. Select Cell or Range where you want to add dropdown list.
2. Goto Data Tab > click on Data Validation
3. You will see data validation dialig box
4. Click on Allow dropdown list and select List
5. In Source Filed you can type text with comma (,) separator.
Also you can select Cells range from a sheet.
6. Click on ok.
Done.
Now when you select any cell which were you sected at the time of data validation. you will see dropdown icon with cell, just click on that it will show you a list of entered items.
