How do I show the results of filter?

[Guest]

I'm using Excel 2000. I have a worksheet that gives me the right filtered
records. The problem that I'm having is that I do not see the number of
records that meet the filtered condition. I thought this feature can be
turned on by by right-clicking over the Filter Mode text on the bar at the
bottom of Excel. That hasn't work. So, how do I get the results of a filter
to show?

 

[Ron de Bruin]

Hi Bob

See Debra's page about this
http://www.contextures.com/xlautofilter02.html#Count