There is a high probability that your workbook might have duplicate data or ... individual columns and rows, you can simply ...

Excel will only remove exact duplicates. In this example ... In addition to the three rows that had the same shape/color combination, this time you also removed the value "Rectangle" from Column ...