WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to use the data validation feature

February 13, 2023

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.