| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Expand the size of a drop-down box | Excel Discussion (Misc queries) | |||
| Expand Drop down windows | Excel Discussion (Misc queries) | |||
| How do I expand the validation drop down box in a cell? | Excel Discussion (Misc queries) | |||
| Can I expand a drop down list? | Excel Worksheet Functions | |||
Linear Mode
