How to set data validation in WPS Spreadsheet

To set data validation in WPS Spreadsheet, perform the following steps:

1. Select the cell for which you want to set data validation in the data table, and tap the toolbar in the lower-left corner.

2. In the expanded toolbar, tap Data, and then tap Data Validation.

3. On the Data Validation page, Validation Type defaults to Any Value. Tap the right-side drop-down arrow.

4. In the expanded Validation Type list, tap a type based on your business requirements. In this example, tap List.

5. In the list that appears, set options to values of the list that you want to manage. In this example, set options to 1, 2, and 3. Then, tap OK in the upper-right corner.

6. After data validation is set successfully, an error message appears if you input values other than 1, 2, and 3 in the cell. Only 1, 2, and 3 can be input in the cell.