Click on a “blank column” where you want the unique entries to appear.This process records the column range for the next step. Open the “Sheets document” you wish to sort.If you are sure that your information is correct and would prefer to remove the duplicates instead, try the method below. This process delivers faster sorting and filtering. If you prefer to sort your raw data automatically, it is best to copy all unique cells rather than duplicates. Copy Unique Cells in Google Sheets for Easy Removal of Duplicates Finally, you can close the formatting menu and restore the standard color to your cells. Once you confirm the copycat cells that you do not need, delete them. They can be the same number for two different accounts, users, employees, etc. Make sure that any existing duplicates are correct, as some copies are not duplicates at all. Image #2: shows all duplicates while selecting row 1 cells as the first cells (A1 and B1): Image #1: shows missed duplicates when selecting row 2 cells as the first cells (A2 and B2): Once row 1 was added (A1:B9), it found all copies. It missed a couple of duplicates in the selected field (A2:B9). The formula does not like using row 2 as the first column. Note: It is best to highlight a column’s cells starting with row 1 rather than choosing cells in the middle. Your spreadsheet will now highlight your duplicate cells in the color you chose, and you can scan the selection for any duplicates. Click on “Done” to save changes, review your duplicates, and delete those you find as legitimate copies.
![excel find duplicates in multiple worksheets excel find duplicates in multiple worksheets](https://fiveminutelessons.com/files/excel-conditional-formatting-new-rule-highlight-duplicate-rows.png)
![excel find duplicates in multiple worksheets excel find duplicates in multiple worksheets](https://cdn.educba.com/academy/wp-content/uploads/2019/05/Pivot-Table-with-Multiple-Sheets-in-Excel.png)
![excel find duplicates in multiple worksheets excel find duplicates in multiple worksheets](https://d3mkpw26g447am.cloudfront.net/images/cac03deb5f42bcb988089117375be29a.gif)