Explanation

Data Validation controls what users can enter into a cell and helps prevent incorrect data.

Common Validation Types

Drop-down Example

Create a list:

Sirsa, Hisar, Fatehabad, Abohar

Then use:

Data → Data Validation → Allow: List

Practice

Create an Employee Entry Form with drop-downs for:

• Department
• City
• Employment Type