when filtering in excel 2003, how many row can we see?
-
Montag, 7. Mai 2012 02:19
now we key 2442 row in excel.After that i choose Auto Filter,i go scrow down and find my data.So some data didn't see complete. but i open this excel file at office 2010. i can see and can choose all key in data. how to do at excel 2003 to see all key in data?
- Typ geändert Max MengMicrosoft Contingent Staff, Moderator Freitag, 11. Mai 2012 02:45
Alle Antworten
-
Montag, 7. Mai 2012 04:26
There is no limitation on the number of row on which you can filter.But if you click the drop dwon arrow arrow you will see only 1000 unique items.In Excel 07 it has been extended to 10000.
But you can use custom filter and filter which is not visible in the list.
- Als Antwort markiert Max MengMicrosoft Contingent Staff, Moderator Freitag, 11. Mai 2012 02:45
.png)
.png)
