Select the rule and then click Edit Rule. Leave Show formatting rules for CURRENT SELECTION at the top. How to remove duplicates in excel on a mac. How To Remove All Duplicates But Keep Only One In Excel Select a range of cells from which you want to remove repeated text.
Press Alt F8 to open the Macro dialog box.