Data Validation

Data validation feature available in Microsoft Excel is used to prevent invalid entry by user. Data validation is used in the Excel cells.

Learn Data Validation in 10 Chapters with step-by-step example:

Data Validation Chapters:

  1. Whole Number Validation
  2. Decimal Number Validation
  3. List (Drop down) Creation
  4. Date Validation
  5. Time Validation
  6. Text Length Validation
  7. Custom (Formula) Validation
  8. Input Message
  9. Error Alert (Stop,Warning and Information)
  10. Circle Invalid Data

Download the Data validation examples

Click to Start Tutorial