There is a limit of 1000 entries that the Autofilter can show in versions
prior to 2007. The limit in XL2007 is 10,000.

Regards,
Fred.

"mafeeheda" wrote in message
...
My spreadsheet is about 4000 rows. applied autofilter and it was not
recognizing data below 999