Remove Duplicates
Windows
Deletes repeated rows from the selected range.
Excel Remove Duplicates Shortcut for Windows, Mac & Web
Deletes repeated rows from the selected range. Here's the keyboard shortcut for every version of Excel, plus other ways to do it.
Quick Answer
- Windows
- Data → Remove Duplicates
- Mac
- Data → Remove Duplicates
- Web
- Data → Data Cleanup → Remove Duplicates
How to remove duplicates in Excel with the keyboard
- Open Excel and go to where you want to remove duplicates.
- Use the menu route shown below — there's no direct key.
Excel Remove Duplicates Shortcut for Windows
There's no direct shortcut. Use Data → Remove Duplicates.
Excel Remove Duplicates Shortcut for Mac
There's no direct shortcut. Use Data → Remove Duplicates.
Excel Remove Duplicates Shortcut for Excel Web
There's no direct shortcut. Use Data → Data Cleanup → Remove Duplicates.
Alternative ways to remove duplicates
- Windows: Data → Remove Duplicates
- Mac: Data → Remove Duplicates
- Web: Data → Data Cleanup → Remove Duplicates
Related Shortcuts
Frequently asked questions
What is the Excel remove duplicates shortcut?
There's no direct keyboard shortcut. Use Data → Remove Duplicates.
Is there a Mac shortcut to remove duplicates in Excel?
There's no direct key we've confirmed. Use Data → Remove Duplicates.
Does it work in Excel for the web?
Use Data → Data Cleanup → Remove Duplicates.
Not yet verified · Last reviewed: not yet reviewed · Microsoft's official shortcut list