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).
↑ Back to the top
Each time that you use the AutoFilter feature, the list that the filter applies to is redetected. This behavior allows the filter to account for items that 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.
↑ Back to the top
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, and then reapply the filter.
↑ Back to the top
For more information about using AutoFilter to filter a list and for an overview about using filters, click Microsoft Excel Help on the Help menu, type ways to find values in a list by using filters (overview) in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
↑ Back to the top