Win7 the method of setting a repeating value in a wps table under the Prohibition cell input

WPS is an office software, some users need to often use WPS to make some data, such as school number, employee number and so on, and these data have the characteristics can not be repeated, then how to prohibit in the WPS table to enter duplicate values? In fact, as long as the simple set up on it, Let's bring it to you. Win7 the Set method for preventing cells from entering duplicate values in the WPS table is as follows.

1, first we open the Win7 system under the WPS software form software, and create a new form.

2. Select the row or column that you want to enter a numeric value in this small series to choose B as an example to explain. You can choose according to the needs of your form input.

3. Click on "Duplicate item" after selecting.

4, click on the mouse to "reject the entry of duplicates" above, and then to the right slide click "Settings";

Notice the expression in the circle: = $B: $B, which represents all the cells in column B of our choice. If we want to select another cell, you can drag the selection in the table by holding down the left mouse button, or you can enter the setting on the page. Click "OK" and then "OK" when you confirm it.

5, at this time we can try to enter a value in column B, when I entered the 1,2,3 without response, when I entered the 3 and then enter 2 o'clock the error prompted. Then click "No" to re-enter;

6, in addition, we can also set the numerical "validity" here to further settings. Select column B--click "validity";

7, "Allow" here click the next triangle to choose Custom, the circle formula on behalf of B column does not enter duplicates, we can also modify the formula according to their own needs.

7, click "Error Warning"--check--The next triangle Select Warning--Set the title and error message--"OK" complete. The number we entered is limited, and the error is prompted when you enter a duplicate value.

The above is about Win7 under the WPS table to prohibit the input of the repeated values of the Set method, users who need to collect the disease to learn, the above content by the Win7 of the small compiled release, prohibit plagiarism.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join