Create A Data Validation List In Excel. Go to the data tab on the ribbon then data validation. On the settings tab define the validation criteria according to your needs.
On the settings tab define the validation criteria according to your needs. 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. If you can t click data validation the worksheet might be protected or shared.
Select one or more cells to validate go to the data tab data tools group and.
Go to the data tab on the ribbon then data validation. You ll want to select list in the drop down menu under allow. The keyboard shortcut to open the data validation window is alt a v v. Unlock specific areas of a protected workbook or stop sharing the worksheet and then try step 3 again.
