Excel will only remove exact duplicates. In this example, the second Square is misspelled as Squarre, so after duplicates are removed, both spellings of Square remain. 6. You can also highlight a ...