# How to Find Duplicates in Microsoft Excel

> To find duplicates in Microsoft Excel, highlight all cells at the top left corner, navigate to Conditional Formatting in the ribbon, select Highlight Cells Rules, and click Duplicate Values to highlight entries.

Canonical: https://livedemo.ai/tutorials/how-to-find-duplicates-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3e25ab56e05a00fe5ee6/preview?step=1

## Steps

1. Open Microsoft Excel and click on the highlight all cell at the top left corner of the table.
2. Go to the Excel ribbon and click on "Conditional Formatting."
3. Select "Highlight Cells Rules."
4. Click "Duplicate Values."
5. Excel will highlight the duplicate entries as shown below.