Explanation

You can modify or remove validation rules whenever required.

Go to:

Data → Data Validation

To remove a rule:

Data Validation → Clear All

Important Tools

  • Circle Invalid Data
  • Clear Validation
  • Edit Validation Rules
  • Copy validation to other cells

Example

If the Department validation is applied to B2:B100, you can copy the validation to another employee-entry section.

Practice

Create validation for an employee form, then:

  1. Edit one rule.
  2. Copy validation.
  3. Find invalid data.
  4. Remove validation from one field.
PreviousNext