Data Validation

You can create and apply validation rules to minimize the error in data, entered in a worksheet. A validation rules allows data to be entered in a cell, only when the data satisfies specified criteria.

To specifcy data validation

1. Click Data-Data Validation-Data Validation.
2. In each tab of the Data Validation dialog box, set validation conditions, messages, error messages. etc.
3. Click OK.

See Also

Data Validation, Mark Invalid Data, Clear Validation Marks, Fill, Filter, Formula

www.hancom.com