How to use the duplicate check function in excel

How to use the duplicate check function in Excel: first open the software and select all the data; then select "Conditional Formatting-Highlight Cell Rules (H)-Duplicate Values" in the "Start" option; then Click OK; all duplicate cells will turn light red.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to use the duplicate check function in excel:

1. First open the Excel software, select to create a new workbook in the main interface and enter the data, then select the box All data;

2. Next, select "Conditional Formatting" in the "Start" option above and click "Highlight Cell Rules (H)" , "Duplicate value";

3. A small window will pop up, you can select the background color of the repeated data, etc., click "OK";

4. Finally, click OK and you will find that all cells with duplicate items have turned light red, making it easier to see duplicate items.

Related learning recommendations: excel tutorial

The above is the detailed content of How to use the duplicate check function in excel. For more information, please follow other related articles on the PHP Chinese website!