show number of selected records in Excel
 

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

show number of selected records in Excel
 

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

"Jonathan Dore" wrote:

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

show number of selected records in Excel
 

Try here

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

Mike

"Jonathan Dore" wrote:

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

show number of selected records in Excel
 

Hi Jonathan

Maybe your status bar has been turned off.
ToolsOptionsViewtick Status Bar

--
Regards

Roger Govier


"Jonathan Dore" wrote in
message ...
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

show number of selected records in Excel
 

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

"Shweta Srivastava77" wrote:

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

"Jonathan Dore" wrote:

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

show number of selected records in Excel
 

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

"Mike H" wrote:

Try here

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

Mike

"Jonathan Dore" wrote:

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

show number of selected records in Excel
 

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

"Roger Govier" wrote:

Hi Jonathan

Maybe your status bar has been turned off.
ToolsOptionsViewtick Status Bar

--
Regards

Roger Govier


"Jonathan Dore" wrote in
message ...
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