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

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?

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

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

On Mon, 21 Jan 2008 10:44:02 -0800, pjfilter
wrote:

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?