Accedi
 
HomeLibraryRisorseFormazioneDownloadSupportoCommunityForumBlog
Risorse per professionisti IT >
> 
> 
when filtering in excel 2003, how many row can we see?

Beantwortet when filtering in excel 2003, how many row can we see?

  • lunedì 7 maggio 2012 02:19
     
     
    Registrati per votare
    0

    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?

     

Tutte le risposte

  • lunedì 7 maggio 2012 04:26
     
     Con risposta
    Registrati per votare
    0

    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.