ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED (https://www.excelbanter.com/excel-worksheet-functions/162642-filter-function-does-not-show-total-records-selected.html)

MUSANDAI

FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED
 
The filter function does not indicate number of records selected in the
bottom left-hand corner (i.e. 29 of 100 records). It simply reads "Filter
Mode." I don't know if the file is corrupted. Excel has been re-installed.
I don't have this problem with other spreadsheets that are sent to me.

Peo Sjoblom

FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED
 
http://www.contextures.com/xlautofilter02.html#Count


--


Regards,


Peo Sjoblom


"MUSANDAI" wrote in message
...
The filter function does not indicate number of records selected in the
bottom left-hand corner (i.e. 29 of 100 records). It simply reads "Filter
Mode." I don't know if the file is corrupted. Excel has been
re-installed.
I don't have this problem with other spreadsheets that are sent to me.




JE McGimpsey

FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED
 
See

http://support.microsoft.com/kb/213886/en-us

In article ,
MUSANDAI wrote:

The filter function does not indicate number of records selected in the
bottom left-hand corner (i.e. 29 of 100 records). It simply reads "Filter
Mode." I don't know if the file is corrupted. Excel has been re-installed.
I don't have this problem with other spreadsheets that are sent to me.



All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com