Excel 2000

  • Thread starter Thread starter Kathy A. Smith
  • Start date Start date
K

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
 
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
 
Back
Top