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 list gives us the option of putting an input message for the ease of the user. Here are the steps to add an input message.
This helps the user to know what is to be done in the particular cell.
Now we have another option of setting an error alert. If we want to set it , go to next tab named ERROR ALERT or press OK , if we don’t want to set an error alert.
Although , this option is not directly applicable to the drop down list as we have already given the choices, but even then if any error occurs, its always a good practice to keep some error catching system in our work.
Here are the steps to use the ERROR ALERT for the list.
After putting the input message, go to the next tab “ERROR ALERT”.
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