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
0
Marty (99)
1/24/2005 8:56:39 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
462 Views

Similar Articles

[PageSpeed] 36

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
0
PeoSjoblom (789)
1/24/2005 9:33:09 PM
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
0
Marty (99)
1/24/2005 10:29:06 PM
Reply:

Similar Artilces:

All Task bars gone How do I get them back?
All of a sudden the other day everything at the top of my screen disappeared. I can load my word documents by searching my files and double clicking on the name but I can not Open a document inside word. I have never seen anything like this where all the buttons for using Word are gone. How do I get them back. http://www.gmayor.com/my_toolbars_are_missing.htm or http://word.mvps.org/FAQs/AppErrors/MissingMenusEtc.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP ...

Display As = File as & (address in parens)
I just moved all my contacts into a new .pst file (I'm using OL 2003) and something changed. I USED TO have "Display As" show only the person's name, and not the person's name PLUS the email address in parens as the default does. In other words, default would show "JOHN SMITH (johnsmith@aol.com)". But when I created all those entries, I changed them to show only "JOHN SMITH". In my new file, Outlook has changed all my "Display As" entries to the default: name AND email address. It's not how I want it, so I'm hoping there'...

Highlighting the active row with special colour
Hi there Is there a macro that highlights the whole active row (not only the active cell) that the cursor is in, in an Excel worksheet? Thanks Raj Highlight it in a particular colour, I meant... that would move along when I would move the cursor onto another row.... "Raj Mazumdar" wrote: > Hi there > > Is there a macro that highlights the whole active row (not only the active > cell) that the cursor is in, in an Excel worksheet? > > Thanks > > Raj Try this '---------------------------------------------------------------- Private Sub Workshe...

Messages stuck in Queue with status Active and eventually fail.
I have an exchange 2000 server with SP3. The scenario is this; Everything has been functioning great except emailing to AOL, so I setup a smart host to use our ISP's smtp server. Well, they are getting flagged as open relay and the mail is rejected. So I had them setup a reverse dns lookup for our IP so I could send mail directly. I found a site that allows me to check RBL's and we came up good on about 25 of them, so we aren't black listed. Now we can email aol users without any problems, but all of a sudden, I can't get the server to deliver mail to other exchang...

Money 2006 Investment Account balance display
I have two Investment Accounts (401k) in Money 2006 Deluxe. For some reason, Money stopped displaying the account totals on the Account List page. It used to show the account balances and the subtotal for all of my investment accounts. Additionally, I now notice that each account now has a second account with the same name, but has the word "Contributions" added in parenthesis. This seems to be new as well. The data in the accounts still seems alright. My investment subtotal on the Account list page shows a zero balance and there is no balance listed for the accounts the...

more than 65,536 rows
Hi Is it possible to have more than 65,653 rows on a worksheet? The data I have does not fit on a normal sheet Harald Harald, Unfortunately, the maximum number of rows on a worksheet is 65,536 rows and cannot be increased. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com chip@cpearson.com "Harald Bock" <anonymous@discussions.microsoft.com> wrote in message news:D6E9402F-92F4-4649-A72C-BC38BE6C89EB@microsoft.com... > Hi, > > Is it possible to have more than 65,653 rows on a worksheet? The data I have does not...

Tool bar anomaly
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel My customized toolbar has a 'close' button that is 3 times the size of the button on other toolbars. Also, the left-hand shaded column for grabbing moving the toolbar has a colon (:) below the button. I don't know that get there. The toolbar works but it should look the others. <br><br>Any ideas? <br><br>Ronben The toolbars you create yourself do have a larger close button. I assume that's to help distinguish them from the built-in bars. Likewise, the dots you see are act...

Rows and Columns Settings Problem
How do you set rows and columns in a way that when you scrol down/column you can always see a certain row(s)/column(s) -- Message posted from http://www.ExcelForum.com Check out XL Help for "Freeze Panes" In article <JMorgan.1ad5vf@excelforum-nospam.com>, JMorgan <<JMorgan.1ad5vf@excelforum-nospam.com>> wrote: > How do you set rows and columns in a way that when you scroll > down/column you can always see a certain row(s)/column(s). Thank -- Message posted from http://www.ExcelForum.com ...

Project status roll down to budget status should be more flexible
It was suggested by support that I mention this to see if others would benefit. We use Project Accounting and have templates that contain as many as 150 cost categories. When users change the status of the project from "estimate" to "open", the application automatically opens all cost categories in the budget. The users would like to be prompted for this roll down so that they can only open the cost categories being used in the template. We want to avoid using more templates because of the complexity that it creates. It helps our end users when they go to the Busines...

Minimizing Rows of with similar data
I am using Excel 2007. I have 3 columns A, B, and C such as below: TU10-10 TU10 Tungsten Satin Wedding Band TU10-10.5 TU10 Tungsten Satin Wedding Band TU10-11 TU10 Tungsten Satin Wedding Band TU10-11.5 TU10 Tungsten Satin Wedding Band TU10-12 TU10 Tungsten Satin Wedding Band TU10-12.5 TU10 Tungsten Satin Wedding Band TU10-13 TU10 Tungsten Satin Wedding Band TU10-6 TU10 Tungsten Satin Wedding Band TU10-6.5 TU10 Tungsten Satin Wedding Band TU10-7 TU10 Tungsten Satin Wedding Band TU10-7.5 TU10 Tungsten Satin Wedding Band TU10-8 TU10 Tungsten Satin Wedding Band TU10-8.5 TU10 Tung...

Outlook Shortcut Bar
How can I create a 'Grocery List' shortcut on the shortcut bar (left side of Outlook window) that will open a blank list similar to 'Tasks'? I can create the actual shortcut, but it's nothing but a duplicate of my 'Tasks' list named 'Grocery List'. I went into the 'Grocery List' list, selected all, and deleted 'em - and there went my entire 'Tasks' list, too. I'd also like to set up other shortcuts, like separate 'Tasks' for home and work, or 'Parts Inventory' (maybe linked directly to Excel). I can't...

Outlook 2000
I'm having a strange Outlook issue and cannot figure it out for the life of me. Our mail server is Exchange 5.5 (can't recall the SP right now), and the Client is Outlook 2000 SR-1. The user can view his primary email box without any troubles, but also has access to another Exchange email box. He can view every folder in it except the Sent Items. The error it returns is "Unable to display the folder". What's strange is he can view the subfolder in Sent Items, no problem. I've configured his email on a different PC, and everything shows up fine, so I know ...

How do I filter rows based upon a column value
I have a spreadsheet that contains multiple agency id's in a column. When generating reports, I would like to filter per agency and display only the rows associated with that agency. Is there a tutorial or sample on how to do this? Hi It sounds like you are looking for Data / Filter / AutoFilter. Have a look here for some basics: http://www.contextures.com/xlautofilter01.html -- Andy. "Jack" <nfr@nospam.com> wrote in message news:eqiU08TVEHA.2988@TK2MSFTNGP10.phx.gbl... > I have a spreadsheet that contains multiple agency id's in a column. When > generati...

List all row source for all forms, reports etc.
Hi I'm doing some work cleaning out old unused forms, reports and queries. I have been going through each report in a database (There are A LOT), determining its row source query, then marking it for deletion. I will eventually end up going through and deleting all the unused queries. As you can imagine this is time consuming, and I was thinkg 'there must be a FASTER way" Does anyone have a suggestion, or link to a pre-built function or model that could assist me? Regards Darragh On Thu, 17 Jan 2008 22:14:18 -0800 (PST), Darragh <darragh.murray@gmail.com> wrote: >Hi...

Returning Data from a third cell in same row that meets two other
I'm looking for a formula that will return a result from a cell on a same row as two other cells that meet certain criteria. I'm sure there is a way to do this but i am a novice at this kind of stuff and can't seem to figure it out. For example i want a cell to = what is in column E when column A="36751" and when column B="Total Returns" The spreadsheet has 55000 rows. there will only be one instance where both these criteria are met. i want to use this to create a seperate spreadsheet with just info i need and can update on a daily basis. thanks in ...

Viewing multiple excell spreadsheets on the task bar
Why is it that when I have 3 or more excell spreadsheets open they are not all listed on my task bar the only way I can get to them is by going to the window button and selecting the one I want to see, I want to be able to ALT TAB between them and they are not listing them for me in the task bar only the current one I have open? Are you using XP? Sounds like that feature of XP which groups several windows of one application into one spot on the task bar. There may be a way to shut this off in taskbar properties. Click on the task bar and select properties. "Megan" wrote: ...

Embedded Pictures received from Others do not display in outlook.
I recently switched to Outlook from Outlook Express. When e-mails are received with embedded pictures, they display properly in Outlook Express but do not display at all in Outlook. Is this related to a security setting in Outlook that I can change to allow these pictures to be displayed? PLEASE HELP!!!! Jim <Jim@discussions.microsoft.com> wrote: > I recently switched to Outlook from Outlook Express. When e-mails are > received with embedded pictures, they display properly in Outlook > Express but do not display at all in Outlook. > > Is this related to a securi...

How to get Row # in formula?
I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave You may not be able to drag it, but if you copy row13 formula and go to row 20 it updates does it not? -- HTH Bob "DaveR" <DaveR@discussions.microsoft.com> wrote ...

count rows
Hi I have two worksheets - sheet1 and sheet2. Sheet1 is my main data which contains 7 colums (A-G) and number of rows varies depend on data. In sheet2 I have formula in Row1 (A1:G1) and I need to copy down the formula to exactly the same number of rows in Sheet1. (For eg: if my sheet1 has 15 rows, I need to copy the formula in A1:G1 of sheet2 till A15:G15). Hope someone help me Thanks in advance Toms --- Message posted from http://www.ExcelForum.com/ Toms You could add an unused row with a number or letter in it and then count that separately each time with countif? John "SMILE...

Cross referencing named row with named column
I'm trying to find a way to cross reference a column named June with a row named Sales but cant figure out what the syntax is. I thought it used to be =June|Sales but it doesnt seem to work. Hi try =INDEX(A1:H20,MATCH("June",A1:H1,0),MATCH("Sales",A1:A20,0)) -- Regards Frank Kabel Frankfurt, Germany "davide212" <davide212@discussions.microsoft.com> schrieb im Newsbeitrag news:917620B9-9182-45C8-9D0F-56B0878CF617@microsoft.com... > I'm trying to find a way to cross reference a column named June with a row > named Sales but cant figure out ...

Add Spell Icon to tool bar.
I cannot find the Spell Checker Icon in any of my pull down menus or add buttons list. Where is it and how do I instal it on my tool bars in Outlook? It is only available using Word as the editor in Outlook. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Tazz asked: | I cannot find the Spell Checker Icon in any of my pull down menus or | add buttons list. Where is it and how do I instal it on my tool bars | in Outlook? ...

Scroll Bar maximum value
I'm designing an interactive chart using a scroll bar object from the Forms Toolbar. The data for my chart gets updated daily and I'd like to have the Maximum Value of the scroll bar reflect the maximum number of data points. Is there a way to do this? The Maximum Value entry does not seem to accept a cell value or formula. I appreciate any help you can offer to solve this problem. Regards, Hi, The Maximum property can not be linked to a cell but you could use a cell to store the value and update the scroller if that value changes. Private Sub Worksheet_Change(ByVal Target...

removing empty cells in a rows of data
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I have may rows of data and I want to remove the empty cells. eg <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A B C D E F G H <br> 1 X X X X <br> 2 Y Y Y Y <br> 3 Z Z Z Z <br><br>I want it to look like this without having to copy/cut and paste. <br> &nbsp;&nbsp;&nbsp;&nbsp;A B C D <br> 1 X X X X <br> 2 Y Y Y Y <br> 3 Z Z Z Z <br><br>Is there any automated way to achieve this? Thanks Allan ...

"Display Map of Address" not working...
Hi - noticed this on two machines, one XP and the other WIN2K, both running Outlook 2003. When I click on "Display Map of Address" for a contact, a browser window opens, but it cannot connect to the web site it uses, which i believe is expedia maps; so the page is just empty. I've used this feature a lot in the past without problems, and have never had mappoint installed on either machine. I also found this problem when trying two separate browsers as the default. Given that i'm seeing the issue on two separate machines, thinking it's some sort of more global issue...

Delivery Status Notification (Failure)
EX 5.5 sp4 nt4 sp6 i have a client receiving multiple Delivery Status Notification (Failure) messages from multiple domains. what could be causing this and how can i make it stop. TNA, joey forgot to mention the most important part she didn't send the emails in the first place it appears to be SPAM >-----Original Message----- >EX 5.5 sp4 nt4 sp6 i have a client receiving multiple >Delivery Status Notification (Failure) messages from >multiple domains. what could be causing this and how can >i make it stop. > >TNA, >joey >. > I think you just answe...