One of the most common data validation uses is to create a drop-down list. 1] Enter Data Validation Details Open the Microsoft Excel file, select the cells you would like to limit.