How do I get Auto filter to report number of records filtered?

W

Walldorc

How do I get Auto filter to report number of records filtered in bottom left
hand corner of screen. I have seen this before but the spread sheet I am
using at the moment just changes from ready to filter mode?
 
Top