Here's some notes from Debra Dalgeish:

http://www.contextures.com/xlautofilter02.html#Limits

which give tips on how to overcome these limitations - basically,
filter on other columns first to reduce the number of data values that
you want to filter on.

Hope this helps.

Pete

On Jan 17, 11:53*am, sanjay kumar das <sanjay kumar
wrote:
i have facing a problem in excell auto filter option, i have over 1000 data
when i filter on SR no. and filter on it there is showing only 1000 SR no.