Please go to Help Microsoft Escel Help and type advanced filter for more
details. this will give you much more information than would be typed here.

"YESHWANT JOSHI" wrote:

HOW DOES ADVANCED FILTER WORKS ???

"Sean Timmons" wrote:

Autofilter's drop-down will only show up to 1000 values in the list. You can
use Advanced filter as an alternative...

"YESHWANT JOSHI" wrote:

hi there ............... i want to know whther there is any restrictions in
excel for filteration ...??

because i have an data of around 12000 lines and if i filter it, it is
applying filter upto row no. 5136 .......... 5137 and onwards rows are not
filtered (even though i have selected all the 12000 rows while appling
filter......... why ??