View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Auto filter does not pick up all values in a column

Excel 2003 and earlier versions limit the Auto Filter list to the first 1000
entries. The filter still works on all rows, but only the first 1000 will be
selectable from the drop-down list. Excel 2007 increases this limit to 10000
entries.

There really isn't a way to increase this limit, but there may be some ways
around it. You can use the "Custom" field on the filter, then type in the
value you want to filter by. Or, depending on your data, you may be able to
filter by a different column first, thus reducing the number of entries to
choose from in your desired column.

HTH,
Elkar



"Dries" wrote:

Hi, when I apply an auto filter to a range and I try to filter by a certain
column, the filter does not show all the values in that column. How can I fix
this?

Tx