 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Filter mode
Hello All I have a worksheet with autofilter set to on. In the bar just above the taskbar, on the far left, I notice that it says "Filter mode", and if I right-click on that I can select options Average, Count, etc. BUT: whichever option I select seems to have no effect - it always says "Filter mode"! Is there another setting that needs to be set somewhere? Hope someone can help. Many thanks Leslie Isaacs When your list has many formulas, or if a cell in the list is changed after an AutoFilter has been applied, the Status Bar may show "Filter Mode" instead of a count of the visible records. The following MSKB article has information: The AutoFilter status bar displays the "Filter Mode" message in Excel http://support.microsoft.com/default.aspx?id=213886 And there are a couple of workarounds here: http://www.contextures.com/xlautofilter02.html#Count > Hello All > [quoted text clipped - 10 lines] > Many thanks > Leslie Isaacs  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.