Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why don't my filter results always appear on the bottom left?
Sometimes when I do auto filter, the count or number of rows found in my
search appear on the bottom left corner as filter results. Other times, even though I think I'm doing the same thing, the results don't show. How can I get them all the time? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why don't my filter results always appear on the bottom left?
From Debra Dalgleish comes this info..................
Normally, after you have applied an AutoFilter, the Status Bar shows a count of visible records. Sometimes it just says, "Filter Mode." This can happen when your list has many formulas. There are articles in the Microsoft KnowledgeBase that explain: XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode" Q213886) XL: AutoFilter Status Bar Message Shows "Filter Mode" (Q189479) The Status Bar will also show "Filter Mode" if anything is changed in the list, after a filter has been applied. For example, if you format a cell, or type a number in one of the records, the 'Filter Mode' message will appear in the Status Bar. End Debra........................... Gord Dibben MS Excel MVP On Mon, 21 Jan 2008 10:44:02 -0800, pjfilter wrote: Sometimes when I do auto filter, the count or number of rows found in my search appear on the bottom left corner as filter results. Other times, even though I think I'm doing the same thing, the results don't show. How can I get them all the time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate in bottom left hand corner in Excel 2007 | Excel Discussion (Misc queries) | |||
Lost bottom toolbar and gray panel appeared at left | Excel Discussion (Misc queries) | |||
Losing count on bottom left hand side when filtering - HELP!!! | Excel Discussion (Misc queries) | |||
No filter results in bottom left hand corner | Excel Discussion (Misc queries) | |||
Sorting in reverse (from right-to-left and from top-to-bottom) | Excel Discussion (Misc queries) |