- 1). Open the spreadsheet in Excel.
- 2). Click the top left cell and drag a selection to the bottom right.
- 3). Click "Data" from the menu at the top of the screen. Click "Filter" then "Advanced Filter."
- 4). Click "Filter The List, In Place" option and check the "Unique Records Only" box. Click "OK."
- 5). Excel will filter the document and hide duplicate rows.
- 6). Click "Edit" then "Office Clipboard."
- 7). Excel will display the Office Clipboard screen.
- 8). Make sure the filtered list from step 5 is still selected and then click the "Copy" icon from the toolbar. The icon is an image of two pieces of paper next to each other.
- 9). Click "Data" from the main menu bar. Then click "Filter" then "Show All."
- 10
Press the "Delete" key on the keyboard. - 11
Click the filtered item list from the clipboard menu opened in step 7. - 12
Excel will place the filtered list in the same location as the original list.
previous post