Autofilter

  • Thread starter Thread starter jholla
  • Start date Start date
J

jholla

Is there a limit to the amount of data that you can filter using autofilter.
The problem that I have is that I can find my data by a custom search in
autofilter but cannot see all the way to the end of my data when I just use
the drop down arrow.

Thanks in advance

John
 
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