Data validation is a feature provided by MS Excel 2007. It helps users in maintaining the integrity of data in a worksheet. Data validation can be configured by clicking the Data Validation option in the Data Tools group on the Data tab.
In many worksheets created, different users enter data on it to get the desired calculations and results. The owner of the worksheet must ensure valid data entry for maintaining integrity of data. He can restrict data entry to a certain range of dates, limit choices by using a list, or make sure that only positive whole numbers are entered. The data validation feature provides immediate help to instruct users and displays clear messages when invalid data is entered.
