- You use data validation to control the type of data or the values that users enter into a cell.
Feb 27 2014 08:58 PM
- Data Validation is used to check whether data entered is acceptable/ reasonable/ within a given range of values.
- For example, you may want to restrict data entry to a
- certain range of dates,
- limit choices by using a list,
- make sure that only positive whole numbers are entered,
- create a drop down list of items in a cell,
- create custom rules for what can be entered