Grzegorz, have a look here http://www.contextures.com/xlautofilter02.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Grzegorz Rudnicki" <Grzegorz wrote in
message ...
Hi, I have a problem with Autofiltr in Excel Worksheet. The problem is
that
when I try to use this option with a column (worksheet has apr. 2500 rows)
the results always look like Excel took only first 1000 of rows. Are there
any limitations for this option? Many thanks in advance