Data Validation Option in MS Excel

Data Validation Option in MS Excel 

 Step 1 : First we select or click on cell where we want to drag down data from data validation given below 

Step 2 : Go to Data (Ribbon) + Click on Data Validation + Allow + List 

Step 3 : Click on Source and Select your data which you want to implement on your selected cell

Step : Now check your cell :)