| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 Auto-Filter
Is there a maximum capacity for Auto-filter in Excel 2000.
All help is greatly appreciated. -- LPS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| Excel 2000 does not filter well | Excel Discussion (Misc queries) | |||
Linear Mode
