View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
rrcd124 rrcd124 is offline
external usenet poster
 
Posts: 6
Default Filter doesn't show record count

Over to the Right side of the screen same level as "filter mode" you'll see
light shaded blocks......right mouse click and select "count" vs Sum....etc.
But then you'll have to highlight what you want to count after it is
filtered...hope this helps

Peter

"Eric_NY" wrote:

As I recall, Filter used to show a count of records at the bottom of the
screen after applying a new filter value. But now it doesn't - all I see is
the legend "Filter mode".

How can I see the record count?

I'm using Excel 2003.

Thanks.