ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   On Excel, the auto filter feature is not filtering all the data (https://www.excelbanter.com/excel-worksheet-functions/148397-excel-auto-filter-feature-not-filtering-all-data.html)

Margaret

On Excel, the auto filter feature is not filtering all the data
 
The auto filter is only filtering the first 10 pieces of data in the column,
not all 60.


Peo Sjoblom

On Excel, the auto filter feature is not filtering all the data
 
Remove the filter, then select the whole table before you apply it again.
You might have blank cells


--
Regards,

Peo Sjoblom



"Margaret" wrote in message
...
The auto filter is only filtering the first 10 pieces of data in the
column,
not all 60.





All times are GMT +1. The time now is 05:27 AM.

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