Data Validation Drop Down In Excel. Or press the f3 key to see a list of names click on a name and click ok. Now click on data validation under the data tab.
Now click on data validation under the data tab. On the settings tab in the allow box click list. Or press the f3 key to see a list of names click on a name and click ok.
Click on the data validation tool from the data tab.
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. Click on data validation settings select list. Enter the values to show in the drop down list. From the allow drop down list choose list.
