Autofilter number of records

T

Thore

Working with Excel 2000.

Hi all,

normally when I apply an autofilter it shows in the bottom
left corner something like "2 out of 334 records found".
However, on some worksheets it just says "filter mode",
which is not really helpful. How can I get this fixed?

Rgds,
Thore
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel, How do I get AutoFilter to provide# of records found? 1
autofilter count 1
How can I ensure #records in a selected set always shows in Excel 1
Bottom left corner of the screen stops displaying number of record 1
How to show the figure of the filtered records ? 1
How do I count the number of records autofilter is showing in Exce 3
Autofill doesn't give the number of records filtered any more 6
how to display the count of lines found by autofilter? 1

Top