This is where Excel's New Window tool—accessed via the View tab on the ribbon—comes in handy. When you click this icon, an exact duplicate of your workbook opens in a new window. Any changes ...

1. Click "Data" in the top menu of the Excel window to open the Data menu ribbon. 2. Click on "Remove Duplicates." 3. A window will pop up. If your column includes a header, make sure the box next ...