Setting the method for setting the repeat value of cell input in the wps table under Win7

Wps is an office software. Some users need to use wps to make some data, such as student number, employee number, etc., and these data have the characteristics of not repeating. How to prohibit the input of duplicates in the wps table? What about the value? In fact, as long as you can simply set it up, let's take the following steps to set the repeat value of the cell in the wps table under Win7.

1. First, we open the WPS software form software under win7 system and create a new form.

2, select the row or column that needs to enter the value, in this small series to select the B column as an example to explain. You can choose according to the needs of your own form input.

3. After clicking, click “duplicate";

4. Click and mouse over to “reject duplicates & rdquo; Above, then swipe right to click "Settings"

Note the expression in the circle: =$B:$B, which represents the B we chose All cells in the column. If we want to select another cell, you can drag the selection by holding down the left mouse button in the table, or you can enter the settings on this page. After confirming, click “OK”, then “OK”

5, at this time we can try to enter the value in column B cell, when I input 1, 2, 3 continuously, there is no response, when I enter 2 under 3 An error message appears. At this time, click “No”; re-enter;

6. In addition, we can also set further values ​​by setting the value “validity”. Select column B ——click “validity';

7. "Allow" and click on the lower triangle to select custom, the formula in the circle represents column B. Without entering duplicates, we can also modify the formula to suit our needs.

7. Click on “Error Warning”——Check ——Lower triangle selection warning ——Set title and error message——&ldquo ; OK & rdquo; completed. At this time, the value we entered is limited, and an error message will appear when you enter a duplicate value.

The above is about the setting method for prohibiting the input of duplicate values ​​in the wps table under Win7. Users who need it can collect the disease and learn it. The above content is compiled by win7 home. Released, plagiarism is prohibited.

Note: For more exciting tutorials, please pay attention to the computer tutorial section, computer office group: 189034526 welcomes you to join