Step-by-Step Guide to Creating Drop Down Lists Using Data Validation Open your Excel workbook and select the cell where you want the drop-down list. Go to the “Data” tab on the Ribbon.

Learn how to create interactive Excel dashboards that transform raw data into actionable insights with this step-by-step guide.