| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble identifying selected records | Excel Discussion (Misc queries) | |||
| Extracting selected records from longer list | Excel Discussion (Misc queries) | |||
| How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
| How can I ensure #records in a selected set always shows in Excel | Excel Discussion (Misc queries) | |||
| Excel Charts: Can I show standard deviation on selected series? | Charts and Charting in Excel | |||
Hybrid Mode
