| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Filter Subtotal
When your list has many formulas, the Status Bar may show "Filter Mode"
instead of a count of the visible records. There are articles in the Microsoft KnowledgeBase that explain: XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode" http://support.microsoft.com/default.aspx?id=213886 XL: AutoFilter Status Bar Message Shows "Filter Mode" http://support.microsoft.com/default.aspx?id=189479 And a couple of workarounds: http://www.contextures.com/xlautofilter02.html#Count Jason wrote: When using the Auto Filter feature, when you select an item to filter by, on some of my documents it will give me a subtotal at the bottom left hand corner. (5 of 25) I have one document that does not pop up with this subtotal it only says (Ready). Does anyone know how to reactivate the subtotal for filtering? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal and Auto-filter | Excel Worksheet Functions | |||
| SUBTOTAL and FILTER | Excel Worksheet Functions | |||
| Auto Filter + subtotal | Excel Discussion (Misc queries) | |||
| Auto Filter + subtotal | Excel Worksheet Functions | |||
| Auto Filter Subtotal | Excel Programming | |||
Threaded Mode
