Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Marty
 
Posts: n/a
Default Display No. of Rows in Status Bar

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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
Marty
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
Display specific rows from table on other worksheet Bruno G. Excel Discussion (Misc queries) 2 January 20th 05 11:22 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM
Data Filter - Not all rows in spreadsheet will display in Autofilt Excel Help Excel Worksheet Functions 1 November 17th 04 05:40 PM
Display selected rows from one worksheet to another Brian Excel Worksheet Functions 5 October 29th 04 12:26 PM


All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"