How to highlight duplicates in a worksheet

September 28, 2021
90 Views 0

Graphic skills

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

How to highlight duplicates in a worksheet (1).gif



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.