How to find duplicate rows in Excel

Choose Home→Styles→Conditional Formatting→Highlight Cells Rules→Duplicate Values. When the Duplicate Values dialog box appears, choose the type of formatting you'd like to use to highlight repeated values. People often choose to…