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
- 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’.
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.