Data Validation Excel List. In the validation criteria section click the drop down arrow underneath allow and select list. On the data tab in the data tools group click data validation.
To allow a user to switch between two or more lists you can use the if function to test for a value and conditionally return a list of values based on the result. Open the data validation dialog box data tab data validation. The list option allows us to have a cell show a drop down arrow which the user can then select from.
To allow a user to switch between two or more lists you can use the if function to test for a value and conditionally return a list of values based on the result.
To add a drop down list of items to a cell or a group of cells select the target cells and do the following. Go to the worksheet and click in the cell where you want the drop down list to appear. Auto complete typing in an excel data validation list. If c4 see full list long list short list.
