G Guest Apr 7, 2006 #1 Does anyone know the size limitations for using the auto filter function? I need to know how many rows it will filter. Thanks
Does anyone know the size limitations for using the auto filter function? I need to know how many rows it will filter. Thanks
D Dave Peterson Apr 7, 2006 #2 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
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
B Bryan Hessey Apr 7, 2006 #3 The limitation is 1,000 different items (ie, 1,000 items in the dro down list).
