Excel 2000

[Kathy A. Smith]

when I filter data in excel, the number of items being
filtered does not show on the status bar.

Thanks in advance,
Kathy, HQMC

 

[Gord Dibben]

Kathy

From Debra Dalgleish.................

Normally, after you have applied an AutoFilter, the Status Bar shows a count
of visible records. Sometimes it just says, "Filter Mode." This happens when
your list has many formulas. There are articles in the Microsoft KnowledgeBase
that explain:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213886
XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode" Q213886)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q189479
XL: AutoFilter Status Bar Message Shows "Filter Mode" (Q189479)

End Debra.........................................

For more on Auto-filters see Debra's site.

http://www.contextures.on.ca/xlautofilter02.html

Gord Dibben Excel MVP