This can be one or two cells, or complete rows and columns.Ģ) Access the Data tab at the top of the page and click ‘Remove duplicates’.ģ) Make sure you’ve got all the check boxes ticked (they should be by default) and click OK to check your selection and automatically remove any duplicate cells. To remove duplicates in Excel, simply:ġ) Open your Excel spreadsheet and select the cell range that you want to analyse for duplicates. You can either manually go through each cell checking for duplicated data, which may take a while depending on the size and complexity of your spreadsheet, or you could follow the steps outlined below and have Excel do all the hard work for you while you sip on a Piña Colada (or whatever else you do instead of working on spreadsheets). Let’s set the scene: You’ve got a Microsoft Excel spreadsheet, and you’d like to remove duplicated cells. Click on Data tab and select Remove Duplicates.
#MS EXCEL FIND DUPLICATES HOW TO#
Read next: How to find your lost Windows or Microsoft Office product key In summary: Here, we show you how to easily remove any duplicate cells in your Microsoft Excel spreadsheet. Whether it’s learning how to handle cells in Excel with adding and deleting, formatting and locking cells or deleting duplicate cells, we’ve got you covered. Microsoft Excel is a hugely popular piece of software used by people all around the world – but that doesn’t mean it’s not complicated to use.