WPS Data Validation on macOS FAQ

Common questions about Data Validation on macOS usually fall into 3 areas: rule sharing, batch updates, and invalid input handling.

FAQ

Do data validation rules apply to other collaborators too?

1. Data validation rules are saved in the spreadsheet file, not only in the current editing view.
2. When other collaborators open the same file and edit the same cells, the same rules still apply.
3. If you want consistent team input, set the rules for key columns before sharing the file.

How do I update an existing data validation rule for multiple cells?

1. Select the cell range that already uses data validation.
2. Open the Data Validation dialog and edit the source or restriction settings.
3. Select Apply these changes to all other cells with the same settings, then save the changes to update matching cells in batch.

What happens if someone enters data that does not match the rule?

1. If an error alert is configured, a prompt appears when the entered value does not match the rule.
2. The message content and alert style can be adjusted on the Error Alert tab.
3. To reduce confusion, it is helpful to use both input messages and error alerts together.

Glossary