If you Right-click anywhere on the Status Bar, you should be able to choose a
Function. the result of the Function will display when you select more the
one cell. It appears toward the right side of the screen on the Status Bar.
It will look something like this:
Count=6

tj

"hako" wrote:

I am using Excel 2000 at home and 2003 at work. The workaround works, but
can you tell me where exactly your Excel 2003 tells you the number of records
found? Because as I previously wrote, my status bar only reads 'Filter Mode'.

"tjtjjtjt" wrote:

Which version do you mean by "New Version"? I'm using Excel 2003, and it
tells me the number of Records found.
Not that this solves your problem ...

A workaround would be to select down a column of your Filtered Data and then
Display the Count of the selected cells.
You can do this by Right-Clicking on the Status Bar. This won't work if
there are Blanks in the Selection.

tj

"hako" wrote:

Old versions of Excel used to indicate it on status bar, but the new versions
just indicate 'Filter Mode' on status bar when you apply an autofilter.