show number of selected records in Excel

[Guest]

I recall that in an earlier version of Excel, when I used auto filters to
select a certain group of records in a worksheet, a message always appeared
on the bottom bar of the screen saying "273 records selected" (or whatever
the number was). This now doesn't happen (I'm using Excel 2003 in MS Office
Professional). Can anyone tell me if this feature is still available, and if
so how I turn it on? "Help" has turned up blank.

Many thanks in advance,
Jonathan

 

[Guest]

Right click on that bottom bar and select count.

So, whenever you select the range of cells it will give you the total no of
count.

Hope this could clear you doubt.
Shweta Srivastava

 

[Guest]

Try here

http://support.microsoft.com/kb/213886

Mike

 

[Roger Govier]

Hi Jonathan

Maybe your status bar has been turned off.
Tools>Options>View>tick Status Bar

 

[Guest]

Thanks very much for taking the time to reply Shweta, but that isn't what I
was looking for. Mike H has provided the answer (which is at
http://support.microsoft.com/kb/213886)

cheers,
Jonathan

 

[Guest]

That's it! Many thanks for the answer Mike!

Try here

http://support.microsoft.com/kb/213886

Mike

 

[Guest]

Thanks for your reply Roger, though the status bar was on. Mike H provided
the solution (in http://support.microsoft.com/kb/213886).

All the best,
Jonathan