Hi

The records will be visible within the spreadsheet itself, but you are
limited to 1000 unique records displayed in the Autofilter dropdown
(at least in xl2003 and below). There is no way around this limit in
xl2003 and below of which i am aware.

Richard


On 19 Jun, 11:16, Subhashis Bhowmick
wrote:
Sir,

After specifying some range in a worksheet, only 1000 similar records appear
in the autofilter, How I can see more than 1000 records in a filter.

Regards,

Subhashis Bhowmick
Nagpur