Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter status
Dear All,
I have auto filtered my list. Whenever I apply a particular filter to a list, it gives me ## of ## records found on the status bar. But this is not the case always. Sometimes it gives the 'Filter Mode' as the status. This is happening for some sheets. Why this may happen? Any settings to do? Please explain. -Sameer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter status
Debra Dalgleish explains it and gives some alternatives:
http://contextures.com/xlautofilter02.html#Count Sameer wrote: Dear All, I have auto filtered my list. Whenever I apply a particular filter to a list, it gives me ## of ## records found on the status bar. But this is not the case always. Sometimes it gives the 'Filter Mode' as the status. This is happening for some sheets. Why this may happen? Any settings to do? Please explain. -Sameer -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter and Status Bar | Excel Discussion (Misc queries) | |||
When in filter mode status bar doesn't show range of cells filted | Excel Worksheet Functions | |||
Filter info in Status bar - Other workaround? | Excel Discussion (Misc queries) | |||
Status bar does not display filter mode | Excel Discussion (Misc queries) | |||
How do I stop Filter Mode from appearing in the status bar | Excel Discussion (Misc queries) |