Excel Data Validation Drop Down List. In the validation criteria section click the drop down arrow underneath allow and select list. Create the main drop down to make your primary drop down list configure an excel data validation rule in this way.
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. From the allow drop down list choose list click in the source box and type an equal sign and the list name for example. Create the main drop down to make your primary drop down list configure an excel data validation rule in this way.
In the validation criteria section click the drop down arrow underneath allow and select list.
Create the main drop down to make your primary drop down list configure an excel data validation rule in this way. You ll want to select list in the drop down menu under allow. Add a drop down list to the selected cells the data validation dialog box displays. On the settings tab in the allow box click list.
