How to highlight duplicates in a worksheet
September 28, 2021
5.6K
Views
0
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 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.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to add text to beginning or end of all cells in Excel
- 6. How to compare two excel sheets and highlight differences