How to check duplicate names in excel

How to check for duplicate names in excel: First, use the mouse to select the content you want to find; then click Conditional Formatting in the start options bar; then open duplicate values ​​in the highlighted cell rules; finally, select Fill in duplicate values Just format.

Recommended: "Excel Tutorial"

First use the mouse to select what you are looking for, here is an example .

Then click Conditional Formatting in the Home Options bar.

Then turn on duplicate values ​​in the highlighted cell rule.

Select the filling format for repeated values ​​and click OK.

Then duplicates will be marked.

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