It's not a setting you can change.
Debra Dalgleish explains the problem and provides a work-around.
http://contextures.com/xlautofilter02.html#Count
Well, you do have to have the statusbar visible.
In xl2003 menus:
Tools|Options|View Tab|check status bar (near the top).
Vera wrote:
I have forgotten what how to set a worksheet so that when I filter data, the
resulting count shows in the bottom left corner. Please help!
Thank you.
--
Dave Peterson