HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: How To Hide Duplicate Records in a Spreadsheet

Excel 2007: How To Hide Duplicate Records in a Spreadsheet

If you have a large spreadsheet that contains duplicate entries (customer names, class subjects, etc.) and you want to view only the unique records in the list, you can filter out the duplicates.


1. Click in a cell in the desired spreadsheet.

2. Go to the Ribbon and select the Data tab.

3. Go to the Sort & Filter section and click Advanced.

4. Click and drag to select the desired cell range. Check the Unique Records Only checkbox.

5. Click OK.

To return the data view back to its original state with the duplicate records intact, go to the Ribbon, select the Data tab and click Clear.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android