AUTO FILTER

[lehigh]

Hi All:

Is there a way to see more than 1,032 rows in the drop down for "Auto
Filter"?

Thanks for your help


Tom Snyder

 

[Debra Dalgleish]

An AutoFilter dropdown list will only show 1000 entries, and that
setting can't be changed. If your column has more than 1000 unique
items, they can be filtered, but they can't all be displayed in the
dropdown list.

To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the drop-down list, and type the criteria, as
you're currently doing. Also, there are a couple of workarounds here:

http://www.contextures.com/xlautofilter02.html

 

[J.E. McGimpsey]

This is turning out to be a FAQ the last day or so...

The answer is No. Look here for some workarounds by Debra Dalgleish:

http://www.contextures.com/xlautofilter02.html