How to use the data validation feature

September 28, 2021
901 Views 0

We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Since this feature is quite complicated, we only briefly introduce some basic usages here. If you want to learn more, you may feel free to watch more related videos in our WPS Academy.

First, select the cell range where we want to fill data, and click the Data tab → the Validation button in the upper menu bar. At this time, the data validation box will pop up.

validation 1.gif

We can set the Validation Criteria in the Settings.

validation 2.gif

We can also choose the Style, Title and Error message in Error Alert. These will be the content of the warning message when invalid data is entered in the error warning area.

validation 3.gif

In this way, when we input invalid data, this feature will automatically remind us of the input errors, thereby improving the accuracy of the data entered.

validation 4.gif

This skill could be also used in Microsoft Office Excel and Openoffice.

Was this helpful?