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


How to check for duplicates in WPS Office Excel sheets

March 4, 2022

We often need to compare two sets of data and check for duplicates at work, but it would be a waste of time to look for duplicates one by one. To solve this problem, WPS Office provides the Manage Duplicates function.

· Steps to check for duplicates with the Manage Duplicates function

Here we take two sheets as examples, which record the attendees of Conference 1 and Conference 2. To find out those who attended two conferences, we need to check for duplicates in these two sheets.

1. Head to the Data tab > Manage Duplicates.

There are four options: Highlight duplicates, Fetch duplicates, Highlight unique values and Fetch unique values.

2. Here we choose Highlight duplicates.

3. In the Mark duplicate rows in two worksheets dialog, choose Two Worksheets on the left, and check the two worksheets Conference 1 and Conference 2.

4. At Specify Color, choose the desired color to highlight the duplicates.

5. Click Confirm to Mark. Then the duplicates in these sheets are highlighted.

As you can see in the dialog, the data from different ranges, sheets and even workbooks can be managed with this function. You can explore more by clicking the following links to watch the free tutorials:

More features in Remove Duplicates | WPS Academy Free Office Courses

Compare two sheets for differences | WPS Academy Free Office Courses

Compare two excel files for differences | WPS Academy Free Office Courses

WPS Office is a free office software that is capable of creating and editing different file formats, including texts in Writer, Presentation, Spreadsheet, and PDF. No matter if you are a student or a business runner, WPS Office is a top choice. WPS Academy, along with WPS Office, offers free and useful tips to beginners who don't know where to start. In addition to the basic functions, WPS Academy can also take you to the more advanced world of office software.

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