Article ID: 123782
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 for Macintosh
- Microsoft Excel 5.0a for Macintosh
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 95a
- Microsoft Excel 97 Standard Edition
This article was previously published under Q123782
SYMPTOMS
When you use the AutoFilter feature on a list, and then use the Clear
command to remove information from the list, the rows that contained the
cleared information may be hidden (even though they no longer contain
information that is relevant to the list).
CAUSE
Each time you use the AutoFilter feature, the list that the filter applies
to is redetected. This behavior allows the filter to account for items you
may have added to the list. The size of the list can be expanded down and
to either side, but it cannot be reduced.
This behavior is by design of Microsoft Excel.
WORKAROUND
To work around this behavior, use either of the following methods.
Method 1
Remove information from the end of the list by clicking Delete (rather
than clear) on the Edit menu.
Method 2
Delete the information, remove, and then reapply the filter.
MORE INFORMATION
REFERENCES
Excel 97
For more information about using AutoFilter to filter a list, click the
Office Assistant, type
autofilter, click Search, and then click to view
"Display a subset of rows in a list by using filters."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office
Program or Component
Excel 5.0
For more information about using AutoFilter to filter a list, click the
Search button in Help and type:
Press ENTER and then double-click "Filtering a list using AutoFilter" to
go to that topic.
Additional query words: 5.00a 5.00c 7.00a 97 XL97 XL7 XL5
Keywords: kbprb KB123782