How to highlight duplicates in a worksheet

September 28, 2021
5.6K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

1. Open the spreadsheet with WPS Spreadsheet.

2. Select a range of cells for operation.

3. Click the Data tab Highlight DuplicatesSet…

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.