Autofilter will work for all 3000 values, it just won't display more
than 1000. That can't be changed.

Check out

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

for some workarounds, or just choose Custom and type the criterion
in.


In article ,
"Ice Man" wrote:

Hi

I got an excel file that contains 3000 rows
when I do autofilter it gives me onbly the top 1000 rows
Who do I extend the range that autofilter works for