Data validation means to check the data before entry. It gives us the power to condition the values which can be entered and rejected into any cell.
The data validation is a very important aspect of any data filling job. Many a times we have fields which have limited type of entries and which can’t be given to the user for manual entry.
PROBLEM WITH MANUAL ENTRY
If we have to work on the manual entries after the data has been filled , it can cause so much trouble for us if the data is not in the perfect format. If we keep the field just open for the entry, if there are a number of people fillling up that data , there are bright chances of format problems.
Now imagine if we have a 1000 rows and there are slight differences in the format of the entry, no matter it was done by different people, we ‘ll never be able to work on that and we might end up in correcting all the data wasting our time and resources.
SO, FOR SUCH CASES WE ALWAYS PREFER CREATING A LIST FOR A FIRM FORMAT AND CONTROLLING THE ENTRY OF THE DATA.
You must have seen this a lot when we are filling up any form online. We are given either the options of lists to choose from.
So , the same option we have in the EXCEL too. Let us try to create a simple DROP DOWN LIST.
We’ll create a small form with a name and country.
The country part will be selected from a drop down to understand the way we can set up a drop down list.
The scenario is clear from the picture given below.
The first requirement for creating a list is the data which should be kept in a list.
The data can be in the same sheet, where we are creating a list or we can keep it in another sheet
to avoid any mess in the same sheet. We can hide the sheet too or lock it with a password
if we need security too.
The following picture shows a list of countries which we will be using to create a drop down list.
THE VALIDATION HELP TEXT OR INPUT TEXT IS THE TEXT WHICH WOULD BE SHOWN WHEN WE SELECT THE CELL CONTAINING THE DROPDOWN LIST FOR THE HELP OF THE USER.
We can understand this as a help text for the user.
Suppose we have a drop down list of countries.
We can enter the help text as CHOOSE YOUR COUNTRY.
When the user selects the cell, GOOGLE SHEETS will prompt , CHOOSE YOUR COUNTRY.
The option is present in the DATA VALIDATION DIALOG BOX as shown in the picture below.
The elaborated process is already discussed. Only the brief process and the step of adding thevalidation text is being discussed here.
We can see the example is having two entries one for the name and
other one is the list.
We can choose the country from the list.
We have created the list as we desired.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE