WPS Data Validation on macOS FAQ

Last updated:July 16, 2026

When using WPS Data Validation, common questions usually involve prompt behavior, dropdown display, and invalid-input handling; this FAQ includes 3 frequent questions and a glossary.

FAQ

How can I show a prompt without blocking invalid input?

  1. Select the cell that already has, or will have, a data validation rule.
  2. Open the Validation settings window from the Data tab.
  3. In the error alert settings, choose a warning-style option that shows a prompt instead of fully stopping entry.
  4. Save the setting and test the input behavior again.

I set data validation, but I do not want to show the dropdown arrow. What should I do?

  1. Select the cell that contains the dropdown rule.
  2. Open the Validation settings window.
  3. Find the option related to showing the dropdown arrow.
  4. Clear that option and save the setting.

What should I do if the input says it does not meet the restriction conditions?

  1. Delete the current value that does not match the rule.
  2. Select the cell again and check whether it shows a dropdown option or input message.
  3. Open the Validation settings window and review the restriction condition.
  4. Enter a value that matches the rule and confirm the result.

Glossary

TermDefinition
Data ValidationA rule that limits what type of content, range, or source can be entered into a cell.
Input MessageA message shown when a user selects a cell, used to explain the expected input.
Error AlertA message shown when entered content does not match the rule, used to warn or stop invalid input.
Dropdown ListA preset list of options that users can choose from directly in a cell.
Circle Invalid DataA visual mark used to highlight cells whose values do not match the validation rule.