How To Find Duplicates In Excel

You will need to learn how to find duplicates in Excel when handling large amounts of data. Sometimes, duplicate data in Microsoft Excel is fine, other times it can really affect your data and be super annoying. You may be looking to find where data has been duplicated, but don;t worry, we’re here to help.

Find more of our Excel guides here

How To Find Duplicates In Excel

How To Find Duplicates In Excel
  • Step 1: Select all of the cells you want to check for duplicates on your sheet.
  • Step 2: Find the Home button on the toolbar and select it. Then select Conditional Formatting, then Highlight Cell Rules. Next, you will want to select Duplicate Values. All of these should be straightforward to find.
  • Step 3: You will next need to select the formatting you want to apply to the duplicate box next to Values With. This is what colours you want the duplicates to be highlighted in, so you can easily identify them. Then hit OK.

Your Excel sheet should now contain cells highlighted if they are exact duplicates. This does mean the words need to be exactly the same, or it will not be detected through Excel. You should be a pro in Excel in no time.

ADVERT

The fighting in Ukraine is causing families to flee their homes. Please give now to save lives and protect people in need. Donate today!

Keep the conversation going by heading over to our Facebook and Twitter pages. You can also find us on Instagram, TikTok, and YouTube. Be sure to also check out our friends over on GameByte and Sporf.

Along with the latest games, merch, and accessories, the GameByte Shop has an epic Loyalty Points Scheme – earning you points for every £1 you spend. Sign up to hear about exclusive deals, PS5 console drops, and more!

ADVERT

<div class=”klaviyo-form-VAkrCV”></div>

Featured Image Credit: Microsoft