Auto filter
 

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

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).

Lisa Files wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote:

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).

Lisa Files wrote:

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

--

Dave Peterson