Posted on Tuesday, 28/12/2021 Show the cells to be removed by Remove Duplicates in Excel A formula-based Conditional Format Excel has a Remove Duplicates option in the Data ribbon. It keeps the first item and removes any further items that match.