Record Count in Excel

Sunnyside_One · 11-23-2008, 07:07 AM

My Excel has quit automatically showing the number of records (same as number of rows) in a worksheet. It used to show the count in the bottom left corner. It quit working gradually where it would sometimes show the count and sometimes not. This feature was particularly useful after filtering records. Can someone tell me how to get this feature to work again? Thanks!

**gistek** · 11-23-2008, 03:19 PM

Mine only shows a count of the highlighted rows. This can be turned on and off by right clicking in the bar across the bottom and checking the "Count" option

martes · 11-23-2008, 04:15 PM

This usually shows up when you filter a column, and disappears when some other activity writes to the StatusBar.

Sunnyside_One · 11-24-2008, 11:08 AM

(This is me, the original poster) Just to clarify my problem, in the bottom left corner of the Excel window, I only see "Ready" if I haven't filtered any records. I see "Filter Mode" if I've filtered records. I used to see, as an example, "1143 of 8754 records found." It's working correctly in some spreadsheets but not in others. I'm hoping to find the "turned off" switch that maybe I accidentally hit. In my work, I really need to know how many records are in a working set of records. Is there any help (or any hope) for me? (LOL)

Sunnyside_One · 11-24-2008, 11:35 AM

I found the answer and have fixed my problem. For the benefit of others, the solution can be found at:

http://support.microsoft.com/default.aspx?id=213886

11-23-2008, 07:07 AM	#1 (permalink)
Sunnyside_One Registered User Join Date: Oct 2008 Posts: 4 OS: Windows XP SP3	Record Count in Excel My Excel has quit automatically showing the number of records (same as number of rows) in a worksheet. It used to show the count in the bottom left corner. It quit working gradually where it would sometimes show the count and sometimes not. This feature was particularly useful after filtering records. Can someone tell me how to get this feature to work again? Thanks!

11-23-2008, 03:19 PM	#2 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,896 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: Record Count in Excel Mine only shows a count of the highlighted rows. This can be turned on and off by right clicking in the bar across the bottom and checking the "Count" option __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team

11-23-2008, 04:15 PM	#3 (permalink)
martes Registered User Join Date: Aug 2008 Posts: 21 OS: XP Pro SP2	Re: Record Count in Excel This usually shows up when you filter a column, and disappears when some other activity writes to the StatusBar.

11-24-2008, 11:08 AM	#4 (permalink)
Sunnyside_One Registered User Join Date: Oct 2008 Posts: 4 OS: Windows XP SP3	Re: Record Count in Excel (This is me, the original poster) Just to clarify my problem, in the bottom left corner of the Excel window, I only see "Ready" if I haven't filtered any records. I see "Filter Mode" if I've filtered records. I used to see, as an example, "1143 of 8754 records found." It's working correctly in some spreadsheets but not in others. I'm hoping to find the "turned off" switch that maybe I accidentally hit. In my work, I really need to know how many records are in a working set of records. Is there any help (or any hope) for me? (LOL) Last edited by Sunnyside_One; 11-24-2008 at 11:38 AM.

11-24-2008, 11:35 AM	#5 (permalink)
Sunnyside_One Registered User Join Date: Oct 2008 Posts: 4 OS: Windows XP SP3	Re: Record Count in Excel I found the answer and have fixed my problem. For the benefit of others, the solution can be found at: http://support.microsoft.com/default.aspx?id=213886