Data Validation

You can use Data validation to define what data is valid for individual cells or cell ranges; restricts the data entry to a particular type, such as whole numbers, decimal numbers, or text; and sets limits on the valid entries.

a. First select the Cells or Cell Range to validate and go to Data - Validation

b. Then type the Validation Criteria , Input Message and Error Alert (Style ,Title and Message) and finally click Ok


Post a Comment