Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Remove Duplicates in Excel 2013

In this video you’ll learn how to remove duplicates in Excel. In long tables such as this one, finding and removing identical cells you may have entered twice by mistake manually can take a long time. Luckily, Excel has a function to remove repeated cells quickly and easily.

To start with, click on any single cell in your worksheet.
Go to the Data tab and click Remove Duplicates.
Choose which column contains duplicates. Click OK.
Excel will now remove all identical rows. Note that identical rows are ones in which all columns are the same.
Please note that this technique only works for lists and tables of data in Excel. If you want to remove identical cells that aren’t part of a list or table, the method won’t work.
Note that If you select a single cell, Excel will try to guess where your list or table is. Therefore, if your data list includes blank rows, it may only detect your list up to the first blank row. If your data has a lot of gaps, you will need to select everything before removing duplicates.