Data Validation Excel Drop Down List. Create the drop down list select the cells in which you want the drop down list on the ribbon s data tab click data validation. Go to the worksheet and click in the cell where you want the drop down list to appear.
We are now going to tell excel to use the named range we created to populate the list. If you already made a table with the drop down entries click in the source box and then click and drag the cells that contain those entries. The data validation window will appear.
You can find my complete tutorial for setting up data validation lists here.
How to create drop down lists using data validation in microsoft excel create a data table and the list of options. It can be in the same worksheet or another one. We are now going to tell excel to use the named range we created to populate the list. On the data tab in the data tools group click data validation.
