Data validation is the foundation of creating drop-down lists in Excel. By setting up data validation rules, you can create lists that automatically update as your data changes.

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.

Set data validation If you want to insert different task priorities (High, Medium, or Low) and Status (Pending, Ongoing, Skipped, Completed) in your Excel sheet, you need to use Data validation ...