How to Find Duplicates in Excel Spreadsheet

How to Find Duplicates in Excel Spreadsheet

If you want to find all the duplicates in one Microsoft Excel spreadsheet or only in certain rows or columns, this is easy to do. In this way, all cells that contain duplicates will receive special formatting, which you can configure yourself.

Check out our video tutorial where we show you how to find duplicates in Excel spreadsheet using Windows 10.

Video transcript:

  1. How to Find Duplicates in Excel Spreadsheet
  2. Select cells where you want to find duplicates
  3. Click on Conditional Formatting
  4. Click on Highlight Cells Rules and then on Duplicate Values…
  5. All duplicates will be marked. From the drop-down list, select the Unique option and then the unique values will be highlighted.
  6. In the drop-down list next to values with, you can adjust the formatting of the cells
  7. When you’re done, click on OK


1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Share: Share to Facebook to Facebook Share to LinkedIn to LinkedIn Share to Twitter to Twitter

Send: Send to Viber to Viber Send to WhatsApp to WhatsApp Send to Telegram to Telegram Send to Facebook Messenger to Messenger Send to Email to Email

If you enjoyed this article, you might also like...

Leave a Reply

Your email address will not be published. Required fields are marked *