Data Validation List Excel. Go to the worksheet and click in the cell where you want the drop down list to appear. In this formula the if function is configured to test the value in cell c4.
This formula takes advantage of this behavior to provide a clever way for the user to switch between a short list of cities and a longer list of cities. For example your choices are red fruit green fruit and yellow orange fruit. On the data tab in the data tools group click data validation.
Go to the worksheet and click in the cell where you want the drop down list to appear.
Click data data validation data validation see screenshot. From the allow drop down list choose list click in the source box and type an equal sign and the list name for example. This formula takes advantage of this behavior to provide a clever way for the user to switch between a short list of cities and a longer list of cities. When c4 is empty or contains any value except see full list the user sees a short list of cities provided in the named range short list e6 e13.
