Microsoft KB Archive/120869

= XL: AutoFilter Command Is Unavailable After Using the Hide All Objects Option =

Article ID: 120869

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q120869



SUMMARY
In Microsoft Excel, the AutoFilter Tool is unavailable.



CAUSE
This behavior occurs when you select the Hide All option, which hides all objects. To see the Hide All option, from the Tools menu, choose Options, and look under Objects on the View tab.

The drop-down arrows used in AutoFilter are objects that are hidden when the Hide All option is selected. Because Microsoft Excel is unable to display the arrows, the AutoFilter command is unavailable.

