If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

Prevent duplicates before they happen by combining a simple function with data validation.