In this tutorial you will learn the use of data validation in excel. It is very useful and time saving in excel because the chance of error decrease. It also increase the convenience for the data entry because the chance of flaw be decrease.
use data validation in excel example:-
You have the record sheet of the students and having fields like student name, DOB and class as like this sheet.
In DOB column need only the insert the date so apply the validation rule for the DOB must be date so this can apply by selection of validation. So click on the data menu and visit the data tool panel and find the data validation option.
Click on data validation and dropdown list of options appear as like following.
Click on data validation option and data validation dialog box appear in front of you.
In validation criteria select the date option form the allow dropdown menu.
In data select the date greater than and select the start date criteria as like following.
You can type the input message which is shown on the selection of given cell. Type title of message and type the message like as following sheet.
Select the next tab named as error alert and select style warning and type tile and message in the text boxes same as following sheet.
Now click on OK button and you see on selected cell the the input message appear same as following sheet.
Type the date in the cell as 1/2/1992 same like as following sheet.
Press enter key and error message show like as sheet which is given below.
Click on button which caption is No and type date 1/1/1995 like as following.
Hence you had learn the data validation in excel and input and error messages of the validation.