A dynamic drop down list in Microsoft ExcelÂ is a convenient way of selecting data without making changes to the source. ... Data Validation is used for restricting what type of data should or can be entered into a range.