How To Use Data Validation in MS Excel
Now we will see that how we can use data validation in MS Excel.
Suppose if we want to make any column with some particular validation, that is data which needs to be entered in should have some limitations.
For that we will use 'Data Validation' option from our DATA tab. It picks from a list of rules to limit the type of data that can be entered in a cell.
When we use that option we can see a dialogue box opened in front of our screen, which asks to allow certain things to enter in cell like numbers, or alphabets only, or date etc... Also we can mention the length of our data which needs to be entered.
We can also add one input message when we try to write in that particular cell. We can also add error alert style or any title with error message.
Now whenever we will try to enter any data in that particular cell we will be first given a warning that 'Data allowed to enter is characters' or anything we set up. And then suppose if we add something lesser than the character length mentioned it will show our error message asking the user to retry or cancel.
So this is how we can valid any data in our M S Excel worksheet.
Share a personalized message with your friends.