Data Validity

Data Validity helps you control and standardize cell input in WPS Sheets. It provides the tools you need to restrict input ranges, create drop-down lists, and set input prompts and error alerts, making data entry more efficient and helping prevent invalid values at the source. With Data Validity, you can define allowed input types and conditions for selected cells, customize prompts and alerts, circle cells that do not comply with validation rules, clear validation circles without changing the underlying data, and remove validation rules when they are no longer needed. Whether you're checking entries against set conditions, guiding users on what to enter, or reviewing and correcting invalid data, Data Validity helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53