Return to site

Excel remove duplicates leave one excel for mac 2016

broken image
broken image

In this case, we do not have any headers since the table starts at “Row 1.” We will deselect the “My data has headers” box. The reason for this is that the “My data has headers” box is ticked.

broken image
broken image

You will notice that the first row has automatically been deselected. Once you have clicked on it, a small dialog box will appear.