New Excel Drop-Down Lists Excel’s dynamic, dependent drop-down lists are a fantastic solution for data management. These lists automatically adapt to your data, ensuring accuracy and efficiency.

Select where you want the drop-down list to appear. Click the Data tab and select Data Validation in the Data Tools group. A Data Validation dialog box will appear.