Data Validation Excel List. To create a drop down list start by going to the data tab on the ribbon and click the data validation button. In the example shown the data validation applied to c4 is.
Those that have used data validation will know that it is a very handy feature especially the list option. In the validation criteria section click the drop down arrow underneath allow and select 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.
On the data tab in the data tools group click data validation.
In the validation criteria section click the drop down arrow underneath allow and select list. Auto complete typing in an excel data validation list. In the validation criteria section click the drop down arrow underneath allow and select list. To create a drop down list start by going to the data tab on the ribbon and click the data validation button.
