WPS Table tips for finding duplicates and deleting them

Under normal circumstances, a lot of data, it is easy to make mistakes. In the WPS input data, sometimes repeated input, so that increased our workload, then WPS how to find duplicates and delete it?

1, first we open the WPS form, and then click the data = = Repeat key = = Highlight Duplicates = set.

2, you can see our wps table, the nineth to tenth line of content and the sixth to eighth line repeat. How do I delete the duplicate contents of the table in bulk?

3. Select the table range to find duplicates--click "Data" on the menu bar--click "Duplicates" in the format bar to remove duplicates.

4, click "Duplicates" in the Drop-down list to find "Delete duplicates"--open the "Delete duplicates" check box, in the check box you can set the scope to find duplicates: For example, I clicked "Select All". --Finally click on "Delete Duplicates" on the OK.

5, delete the duplicate item after there is no duplicates, I deal with the results here as follows: