MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Doug on February 04, 2002 11:23 AM

In my sppreadsheets I use a lot of filters. In most of the spreadsheets when I filter a column I get a total number of filtered items in the lower left hand corner. This is as i expect it to be. In two of my spreadsheets when I filter, I do not get the totaled number but it just shows as "Filter Mode". How can I get these spreadsheets back to showing the totaled number of filtered items?

Thanks for any help you can provide.

Posted by Chris D on February 04, 2002 1:18 PM

It seems to me that whilst you perform your filtering, it will tell you the pertinent records found.... ie 5 of 399 records found.

As soon as you exit your filtering chores and perform another task / function etc etc it will display "in filter mode" maybe to remind you that there is a certain range which is filtered and not an entire range of contiguous rows (ie in case you copy down or copy paste or whatever)

looks like it's just a reminder to you whislt it recognises you are not filtering any more

try picking a spreadhseet that you thought looked odd and just double click a spare cell into edit mode - the narrative should switch to that reminder "filter mode".... now switch back to your filtered columns, pick a column and select "filter : all" you will see ti changes back to something like 45 records from 2,785 as it knows you know the filter mode is on so turns off the reminder to a more useful results narrative



Posted by Doug on February 04, 2002 3:15 PM

Thanks for the response Chris but in all my spreadsheets with the exception of two, the filtered number of items shows (i.e., 5 of 3495) but in the other two spreadsheets the total does not show up. It stated "calculating cells = 100%" then goes directly to the "filter mode" without identifying the total filtered items. Thus my delema.


Posted by Mark W. on February 04, 2002 4:57 PM

Here's what's happening in a flash! After applying
a filter the "# of ## records found" is displayed
on the Status bar. Then your worksheet is
re-calculated replacing the above message with
"Calculated Cells %". Once re-calculation is
complete the "Filter Mode" message is displayed.

If you want the "# of ## records found" message
to be preserved set your calculation mode to

Posted by Doug on February 05, 2002 10:12 AM

Thanks Mark. We will see what happens but, why would, in the auto mode, the # of #### show when filtering in some columns but yet not show when filtering in other columns?