How to use the data validation feature

September 28, 2021
140 Views 0

Graphic skills

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.