Knowledge Base

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

Article ID: 120869

Article Last Modified on 8/15/2005

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.

REFERENCES

"User's Guide " version 5.0, Chapter 21, "Sorting and Filtering Data in a List", page 393

For more information about Filtering a List Using Autofilter, choose the Search button in Help and type:

AutoFilter

Additional query words: Autofilter Hide All Objects Data dim dimmed grey gray

Keywords: KB120869