Excel 2000 Auto-Filter
 

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

All help is greatly appreciated.
--
LPS

Excel 2000 Auto-Filter
 

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.

LPS wrote:

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

All help is greatly appreciated.
--
LPS

--

Dave Peterson

Excel 2000 Auto-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

On Tue, 16 Feb 2010 08:04:01 -0800, LPS
wrote:

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

All help is greatly appreciated.