Auto Filter in Excel
 

When using auto filter in excel how do I premantly see the number of records
found. It usually appears in the bottom left corner. Some of my worksheets
show it some don't. I want to be able to see the records all the time when I
filter.

Never noticed or forgot about that, thanks for the information,
I guess after seeing Debra's sight the reason I never paid much
attention to it..

As Jason Morin point out in your other post see
Debra Dalgleish's page for more insight.
http://www.contextures.com/xlautofilter02.html#Count

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"cduckett" wrote in message ...
When using auto filter in excel how do I premantly see the number of records
found. It usually appears in the bottom left corner. Some of my worksheets
show it some don't. I want to be able to see the records all the time when I
filter.