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.

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.