V vwest Apr 14, 2008 #1 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 from the 1000 entries allowed to fit an entire range of cells?
M Max Apr 14, 2008 #2 vwest said: How do I expand a filter drop-down box from the 1000 entries allowed to fit an entire range of cells? Click to expand... Not possible, I think. Debra explains it, with alternatives at her: http://www.contextures.com/xlautofilter02.html#Limits ---
vwest said: How do I expand a filter drop-down box from the 1000 entries allowed to fit an entire range of cells? Click to expand... Not possible, I think. Debra explains it, with alternatives at her: http://www.contextures.com/xlautofilter02.html#Limits ---
G Gord Dibben Apr 14, 2008 #3 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
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
