Auto filter

[Guest]

Is it possiable to filter more than 1000 rows with autofilter? and if so, how?

 

[Dave Peterson]

Select your range and apply the data|autofilter.

I bet you're seeing a maximum of 1000 unique entries under that dropdown. The
range is still filtered--excel just shows a max of 1000 entries.

Debra Dalgleish has some tips you may like:
http://www.contextures.com/xlautofilter02.html#Limits

(and you could always use a custom filter and type what you want (or contains
what you want).

 

[Guest]

Yeah, I was afraid of that - thanks Dave!!

Select your range and apply the data|autofilter.

I bet you're seeing a maximum of 1000 unique entries under that dropdown. The
range is still filtered--excel just shows a max of 1000 entries.

Debra Dalgleish has some tips you may like:
http://www.contextures.com/xlautofilter02.html#Limits

(and you could always use a custom filter and type what you want (or contains
what you want).