AUTO FILTER

  • Thread starter Thread starter lehigh
  • Start date Start date
L

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
 
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
 
Back
Top