Data Validation List Excel. The data validation window will appear. You ll want to select list in the drop down menu under allow.
Data validation rules are triggered when a user adds or changes a cell value. From the allow drop down list choose list click in the source box and type an equal sign and the list name for example. The keyboard shortcut to open the data validation window is alt a v v.
On the settings tab you can have excel restrict entries in the selected cells to dates numbers decimals times or a certain length.
On the settings tab in the allow box select list. On the settings tab you can have excel restrict entries in the selected cells to dates numbers decimals times or a certain length. On the data tab in the data tools group click data validation. For the dependent lists you can create ranges with one word names such as yofruit.
