How to use the data validation feature

September 28, 2021

A free Office suite fully compatible with Microsoft Office

Free Download

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.

We can set the Validation Criteria in the Settings.

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.

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

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