how i do to make a self filter in more than 3000 lines?
 

When i´ll use a self filter, i can´t use this function in more than 1.000
lines, what i need to do?

how i do to make a self filter in more than 3000 lines?
 

Actually, the Auto Filter works with that many records, BUT the dropdown
lists will only display up to 1,000 unique items. There are workarounds you
can use to facililitate what you may want to do. For instance, by filtering
on one of the fields, other fields may list more values. For more options,
see Debra Dalgleish's site:

http://www.contextures.com/xlautofilter02.html#Limits

***********
Regards,
Ron

XL2002, WinXP-Pro


"V. Ivanov" wrote:

When i´ll use a self filter, i can´t use this function in more than 1.000
lines, what i need to do?