Read next: How to find your lost Windows or Microsoft Office product key
In summary:
Select cell rangeClick on Data tab and select Remove DuplicatesCheck 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’.
3) 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.
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. Read next: Best laptops to buy in the UK in 2016 | How to get Microsoft Word free on Windows 10 Lewis Painter is a Senior Staff Writer at Tech Advisor. Our resident Apple expert, Lewis covers everything from iPhone to AirPods, plus a range of smartphones, tablets, laptops and gaming hardware. You’ll also find him on the Tech Advisor YouTube channel.
