To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...
You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.