Data Validation [Microsoft Word] – to be able to prevent invalid data from being entered into a cell.
Data Validation is only one of the wonderful functionalities of Microsoft Excel 2007. Data Validation allows the creator of an Excel file to limit the values that may be entered into any cell.
The Data Validation function is found in the Data Ribbon of any Excel 2007 workbook. Once in the Data Ribbon, look in the Data Tools group to find Data Validation.
