Key Takeaways. Open your Excel spreadsheet and select the cell where you want the drop-down list. Go to the “Data” tab on the Ribbon. Click on “Data Validation” in the Data Tools group.

Changes to the source list will not automatically reflect in the drop-down list — it must be manually updated in the Data Validation box. Also, if the Ignore blank option is left unchecked, it ...

To create a drop-down list in Excel, follow these steps-Select a cell where you want to show the drop-down menu. Go to Data > Data Validation. Select the List from the Allow menu.

How to base a data validation dropdown on an array in Excel Now we’re ready to create the data validation dropdown that will display the unique list in column H. To begin, select J2 and then do ...

In the Data Tools group, click Data Validation, and then click Data Validation from the dropdown. From the Allow dropdown, choose List. For Source, enter =Animals_List, as shown in Figure C. Click OK.

To insert a drop-down list using data validation, follow these steps: Navigate to the “Data” tab: Select the cell where you want the drop-down list to appear.