Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hello:
I'm using Excel 2003. Up until recently, whenever I apply an autofilter, my status bar would display the number of rows returned, e.g.: "25 of 100 records found". For some reason it has stopped doing that, and now just says "Filter Mode". I right clicked on the status bar, and chose "Count". It didn't help. Right now I have it on "None", which is what it was on when the row count was displaying before. I don't believe I turned anything off, but I'd sure like to have that feature back. OBTW: I had this problem a month or so ago and fixed it somehow, but I can't remember what I did. Any suggestions? Thanks in advance, MARTY |
#2
![]() |
|||
|
|||
![]()
See:
http://www.contextures.com/xlautofilter02.html#Count Regards, Peo Sjoblom "Marty" wrote: Hello: I'm using Excel 2003. Up until recently, whenever I apply an autofilter, my status bar would display the number of rows returned, e.g.: "25 of 100 records found". For some reason it has stopped doing that, and now just says "Filter Mode". I right clicked on the status bar, and chose "Count". It didn't help. Right now I have it on "None", which is what it was on when the row count was displaying before. I don't believe I turned anything off, but I'd sure like to have that feature back. OBTW: I had this problem a month or so ago and fixed it somehow, but I can't remember what I did. Any suggestions? Thanks in advance, MARTY |
#3
![]() |
|||
|
|||
![]()
Thank you.
"Peo Sjoblom" wrote: See: http://www.contextures.com/xlautofilter02.html#Count Regards, Peo Sjoblom "Marty" wrote: Hello: I'm using Excel 2003. Up until recently, whenever I apply an autofilter, my status bar would display the number of rows returned, e.g.: "25 of 100 records found". For some reason it has stopped doing that, and now just says "Filter Mode". I right clicked on the status bar, and chose "Count". It didn't help. Right now I have it on "None", which is what it was on when the row count was displaying before. I don't believe I turned anything off, but I'd sure like to have that feature back. OBTW: I had this problem a month or so ago and fixed it somehow, but I can't remember what I did. Any suggestions? Thanks in advance, MARTY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
Display selected rows from one worksheet to another | Excel Worksheet Functions |