How do I expand a filter drop-down box?
 

How do I expand a filter drop-down box from the 1000 entries allowed to fit
an entire range of cells?

How do I expand a filter drop-down box?
 

"vwest" wrote:
How do I expand a filter drop-down box from the 1000 entries allowed to fit
an entire range of cells?

Not possible, I think. Debra explains it, with alternatives at her:
http://www.contextures.com/xlautofilter02.html#Limits
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

How do I expand a filter drop-down box?
 

You don't.

You work around the 1000 limit by using the "Custom" feature with "contains" and
"equal to" and "does not contain" and stuff like that.


Gord Dibben MS Excel MVP

On Mon, 14 Apr 2008 14:36:01 -0700, vwest
wrote:

How do I expand a filter drop-down box from the 1000 entries allowed to fit
an entire range of cells?