Data Validity

Data Validity helps you restrict and standardize cell input in WPS Sheets collaboration mode to prevent incorrect data entry. It provides the tools you need to apply validation rules to selected cells or ranges and remove those rules when needed, making your work more efficient and helping you accomplish tasks with ease. With Data Validity, you can set rules for any value, integer, decimal, list, date, time, text length, or custom conditions, then apply them to a cell or range. You can also clear all existing validation rules from selected cells or ranges. Whether you're controlling allowed input, testing whether a rule works, or checking alerts when entered content violates a rule, Data Validity helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.