0801 Data Validation - Drop Down List Using Hard Coded Text and Pre-defined Range

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.21
You save:  د.إ146.92
List Price:  A$189.27
You save:  A$54.08
List Price:  ৳11,874.45
You save:  ৳3,392.94
List Price:  CA$174.19
You save:  CA$49.77
CHF 90.63
List Price:  CHF 126.88
You save:  CHF 36.25
List Price:  kr876.09
You save:  kr250.33
List Price:  €117.79
You save:  €33.65
List Price:  £100.24
You save:  £28.64
List Price:  HK$1,087.91
You save:  HK$310.85
List Price:  ₹10,396.08
You save:  ₹2,970.52
List Price:  RM592.78
You save:  RM169.38
List Price:  ₦57,615.03
You save:  ₦16,462.61
List Price:  kr1,223.76
You save:  kr349.67
List Price:  NZ$199.75
You save:  NZ$57.07
List Price:  ₱7,023.18
You save:  ₱2,006.76
List Price:  ₨22,717.01
You save:  ₨6,491.03
List Price:  S$189.41
You save:  S$54.12
List Price:  ฿4,598.67
You save:  ฿1,314
List Price:  ₺1,183.81
You save:  ₺338.25
List Price:  B$707.83
You save:  B$202.25
List Price:  R2,037.17
You save:  R582.09
List Price:  Лв230.32
You save:  Лв65.81
List Price:  ₩160,005.91
You save:  ₩45,719.24
List Price:  ₪453.71
You save:  ₪129.64
Already have an account? Log In


Hi there. In this video, we will learn how to create a drop down list which is often used to create forms and for accurate user input. For example, I wish to have a drop down which should have these three values accepted rejected or under review, any invoice which may be submitted for payment. It may be accepted, it may be rejected, or it may be under review. So this kind of a drop down, let's see how to populate one. First I choose a cell, I go to data.

Within data tab, I look for data validation. Within data validation, I choose the first option which says data validation. Okay. Now, by default, it says validation criteria. Now your question could be why is it called validation in the first place? Let me tell you why.

Let's assume in this drop down cell, I wish to give a word yes and I will press enter. Notice it is prompting you that this particular input is in valid not valid. So, you wish to try and correct that or you wish to cancel that. So this is validating the user's input and hence called validation. So, I go to Data tab, I go back to data validation and then I say, Please allow not any value allow a list. Now when I choose list, it says source that means what are the values which are going to be there in the drop down list?

What is the source of those values? Now, there are a few ways in which the source can be populated. One way is you can write by hand in words, so accepted, comma rejected. And if I just put into values, let's see what happens as I press OK. Aha, I have accepted I have reject. Now, there's another way I choose the next cell data. Data Validation.

This is the second approach with which a dropdown can be generated. So I go to allow I say list and in the source. Instead of typing those things in, I choose the values directly from these three cells. What does it say? It says a two colon a four, signifying the rain selection as a press OK. Notice it's taking all the three values. And just one thing, in case you delete any one of the cell values from the given list, you notice the drop down also shows a blank since it is directly correlated with the cell value, which you have posted here.

Now Apart from this, there is one more way which I believe is the most efficient way and I'll show that in the next video.

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.