Info disapeared

[Gordon]

Hi...

My status bar is in view, but when filtering a
spreadsheet no filter total appears on the status bar
anymore. Help?

Cheers

Gordon.

 

[Jason Morin]

One possibility...

http://www.contextures.com/xlautofilter02.html#Count

HTH
Jason
Atlanta, GA

 

[Debra Dalgleish]

The row count is usually displayed in the Status Bar, at the lower left
of the screen. However, when your list has many formulas, the Status Bar
may show "Filter Mode" instead of a count of the visible records. You
can use the Subtotal function to count the visible rows.

The following MSKB article has some information:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode"
http://support.microsoft.com/default.aspx?id=213886

And there are a couple of workarounds here:
http://www.contextures.com/xlautofilter02.html#Count