0Many times while working you would require to create drop down values in excel.
Many people get stuck at this point and think it is very difficult to create dropdowns or maybe macro is required to create a dropdown.
The answer is - it is neither difficult nor any macro is required. You can use the in-built Excel function called Data Validation.
This function allows you to create a list of drop-down values. You can also write a customised formula in the data validation tab to create dynamic drop-down lists.
