Remove Duplicates based on all the tables

Hi,     I need to remove duplicates for the entire table as in Excel. Is it possible? I tried removed duplicates, selecting the entire table       Hower, then it shows in red.   Also i...