Microsoft Office Tutorials and References
In Depth Information
Excel filters the
duplicate records.
You can tell the
duplicate records are
hidden because the row
numbers are not
continuous.
l
8
8
Click the Data tab.
9
9
Click Clear.
l The duplicate records display.
Did You Know?
If you want to retain you unfiltered list, you can place
your filtered list in another area of you worksheet. In
the Advanced Filter dialog box, click Copy To Another
Location ( changes to ) and then enter the
location where you want to place your filtered list in
the Copy To field.
Did You Know?
Filtering duplicate records temporarily removes them
from view. If you want to delete duplicate records
permanently, select your list, click the Data tab, and
then in the Data Tools group click Remove Duplicates.
The Remove Duplicates dialog box appears. If your
list has headers, click My Data Has Headers
( changes to ). Select the columns you want to
check for duplicates and then click OK. Excel deletes
the duplicate records.
Chapter 4: Manipulate Records
85
 
Search JabSto ::




Custom Search