How to add Drop Down List In Excel - Excel Drop Down List - Data Validation in Excel cell
How to Create a Data Validation List in Excel.
1. First type all the List which you want to make a data validation List.2. Now Select the entire list.3. Go to Data Tab in the Menu.4. Select Data Validation in the Data menu.5. After Selecting Data Validation Menu, A Pop Up windows opens.6. In theat windows you can see any value in the settings tab by default.7. Now you select list in place of any value.8. Then click ok and close the window.
For Example Check Out this Video.