How to delete duplicates in Microsoft Excel

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. 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. Here, we show you how to easily remove any duplicate cells in your Microsoft Excel spreadsheet. See also: How to use Excel

Read next: How to find your lost Windows or Microsoft Office product key

In summary:

  • Select cell range
  • Click on Data tab and select Remove Duplicates
  • Check all boxes and click OK

How to delete duplicates in Excel

Let’s set the scene: You’ve got a Microsoft Excel spreadsheet, and you’d like to remove duplicated cells. 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). To remove duplicates in Excel, simply:  

1) Open your Excel spreadsheet and select the cell range that you want to analyse for duplicates. This can be one or two cells, or complete rows and columns.

2) Access the Data tab at the top of the page and click ‘Remove duplicates’.

If you only want to remove duplicate cells from specific rows or columns, deselect the columns you don’t want analysed in the ‘Remove duplicates’ pop-up menu. For example, if you wanted to only remove duplicates that had the same name, you’d deselect the Sales check box. It’s a fairly simple feature to use, but comes in handy – especially when dealing with huge amounts of data.

Top Christmas Deals

Only the best deals on the best products handpicked by our expert editors

< > Top Christmas Deals

Only the best deals on the best products handpicked by our expert editors

< >

Read next: Best laptops to buy in the UK in 2016 | How to get Microsoft Word free on Windows 10

About the Author

Leave a Reply

Your email address will not be published.

You may also like these