Data Validation List Excel. On the settings tab select list in the allow in the source box type the items of your excel validation list separated. For example your choices are red fruit green fruit and yellow orange fruit.
In this formula the if function is configured to test the value in cell c4. On the data tab in the data tools group click data validation. Open the data validation dialog box data tab data validation.
It is now time to set up the data validation list.
On the data tab in the data tools group click data validation. And in the data validation dialog box click settings tab and choose list option from the allow drop down list and then click to select the list values that you want to use. You may need items in the first excel data validation drop down list that contain characters not allowed in range names such as the ampersand. Go to the worksheet and click in the cell where you want the drop down list to appear.
