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 highlight duplicates in a worksheet
February 13, 2023
13.7K
Views
52
1. Open the spreadsheet with WPS Spreadsheet.
2. Select a range of cells for operation.
3. Click the Data tab →Highlight Duplicates→Set…
4. Click OK in the popup “Highlight Duplicates” dialog.
WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables, and more. Includes advanced animation, slide transitions, and support for video, images, audio, and even Flash.