02Dec2014

How to create dynamic dropdown list in Excel?

Dynamic dropdown list in Excel: Dynamic dropdown list in excel falls under Data Validation. This can be accessible in Data Tools section in Data tab in excel ribbon as shown in the image below. Data Validation picks from a list of rules to limit the type of data that can be entered in a cell.