It'll filter the whole sheet (all 65536 rows (-1 for the header)). But only the
first 1000 unique entries will appear in the dropdown.

You can still use custom to specify any of the others, though.

Debra Dalgleish has some workarounds at:
http://www.contextures.com/xlautofilter02.html#Limits

jeo1 wrote:

Does anyone know the size limitations for using the auto filter function? I
need to know how many rows it will filter.

Thanks

--

Dave Peterson