how get i see above 1000 date in auto filter?

[sanjay kumar das]

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.

 

[Pete_UK]

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