Excel 2000 Auto-Filter

  • Thread starter Thread starter LPS
  • Start date Start date
L

LPS

Is there a maximum capacity for Auto-filter in Excel 2000.

All help is greatly appreciated.
 
Not that I've seen.

But you may want to explain your question in more detail.

If the filter isn't including all the rows in the range you want filtered, I'd
suggest that you turn it off, then select the range to filter, then re-apply the
filter.
 
If you're talking about the number of items seen in the dropdown..........

1000 unique items is the limit.

If you have more than that you will have to use the Custom feature.

equal to or contains or whatever.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data - Filter - Auto Filter 1
Auto-filter selection 1
Excel 2007 Filtering range 1
Auto Filter 3
Filter results returning a count __ of __ 1
filter not working 2
Use auto filter in a protected worksheet 5
Auto filter for multiple columns 2

Back
Top