Why don't my filter results always appear on the bottom left?

[pjfilter]

Sometimes when I do auto filter, the count or number of rows found in my
search appear on the bottom left corner as filter results. Other times, even
though I think I'm doing the same thing, the results don't show. How can I
get them all the time?

 

[Gord Dibben]

From Debra Dalgleish comes this info..................

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

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode" Q213886)
XL: AutoFilter Status Bar Message Shows "Filter Mode" (Q189479)


The Status Bar will also show "Filter Mode" if anything is changed in the list,
after a filter has been applied. For example, if you format a cell, or type a
number in one of the records, the 'Filter Mode' message will appear in the
Status Bar.

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


Gord Dibben MS Excel MVP