size limitations on auto filter

[jeo1]

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

Thanks

[Bryan Hessey]

The limitation is 1,000 different items (ie, 1,000 items in the drop down list).

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]

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