Best bet is to use a helper column to get to the appropriate part of the
list. For example, use LEFT(A1) to get the initial letter, filter first by
that initial letter, then you can pick up the detail you need & filter by
that.
--
David Biddulph

"Subhashis Bhowmick" wrote in
message ...
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