Microsoft KB Archive/214013

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

Article ID: 214013

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214013





SYMPTOMS
When you point to Filter on the Data menu, the AutoFilter command is unavailable (appears dimmed).



CAUSE
This behavior occurs when you select the Hide all option, which hides all objects. (To see the Hide all option, click Options on the Tools menu, and then click the View tab. Hide all is under Objects.)

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.



RESOLUTION
To resolve this problem, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) On the View tab, under Objects, click Show all.

