A dynamic dropdown list in Excel is a dropdown that ... the options in the second dropdown based on your choice. Dynamic dropdowns make Excel smarter by improving data accuracy and user-friendliness.