A dynamic dropdown list in Excel is a dropdown that provides options ... In our example, we will create a dependent dropdown that allows you to select an employee based on the department selected.