Category Archives: Excel

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 change the background color.

Posted in Excel | Leave a comment