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


Set input conditions and drop-down menus

Uploaded time: September 18, 2021 Difficulty Beginner

Set input conditions and drop-down menus

Set input conditions and drop-down menus

The Data Validation feature of the WPS Spreadsheet can help us quickly complete the setting of input conditions and drop-down menus, thereby improving the accuracy of our input data.

Take this form as an example. Now we need to enter a 9-digit US passport number in column C. We can use Data Validation to improve the accuracy of our input data.

1. Select the cell range, then click the Data tab.

2. Click the Validation drop-down button.

3. Now select the Validation option in the drop-down menu. Here we can set the required type of input data.

4. Click the Settings button.

5. Select Text length in the Allow option.

6. Select equal to in the Data tab, and enter 9 in Value.

We now enter the value in the set cell area. When the value length is not equal to 9, it will prompt an error message. Therefore, we can effectively avoid entering the wrong data.

We can also use the data validity feature to make a drop-down menu and enter the data. In the Insurance purchased column, we need to fill in the YES and NO information.

1. Select the cell area, then click the Validation drop-down button.

2. In the popup Data Validation dialog box, click the Settings button and select List in the Allow option.

3. Enter YES and NO in the Source edit box, separated them by commas, and click OK.

In this way, when inputting status information, we can directly select the input content. If we want to cancel, just click Clear All in the Data Validation dialog box.

These are some skills in setting input conditions and drop-down menus. Did you get it?

To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

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