To remove the circle from a single cell, enter valid data in the cell. On the Data tab, in the Data Tools group, click the arrow next to Data Validation, and then click Clear Validation Circles.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.