Shortcut keys
WindowsAlt → A → M
MacNo direct shortcut
Ribbon path
Data → Remove Duplicates
What it does
Scan selected columns for duplicate rows and remove them, keeping only the first occurrence. Choose which columns to check.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for remove duplicates?
On Windows, use Alt → A → M. On Mac, use No direct shortcut.
Where is remove duplicates in the Excel Ribbon?
The Ribbon path is Data → Remove Duplicates.
What does remove duplicates do in Excel?
Scan selected columns for duplicate rows and remove them, keeping only the first occurrence. Choose which columns to check.