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 ??