F
felton128
Can you tell me how to print the drop down filter list in Excel. I need to
prune and consolidate the various selections.
prune and consolidate the various selections.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
ShaneDevenshire
Hi,
There is no way to print the onscreen list. But you can use a screen
capture program to do it.
What kind of drop down list are we talking about - Data Validation, Auto
Filter, Form Control, or Active X Control Toolbox item?
There is no way to print the onscreen list. But you can use a screen
capture program to do it.
What kind of drop down list are we talking about - Data Validation, Auto
Filter, Form Control, or Active X Control Toolbox item?
G
Gord Dibben
The dropdown autofilter list is comprised of the first 1000 unique items in the
column.
If you want to copy all the unique items in a column use Advanced Filter>Unique
items only and copy to somewhere.
For more on this, including copying to another sheet, see Debra's site.
http://www.contextures.on.ca/xladvfilter01.html#ExtractWs
Gord Dibben MS Excel MVP
column.
If you want to copy all the unique items in a column use Advanced Filter>Unique
items only and copy to somewhere.
For more on this, including copying to another sheet, see Debra's site.
http://www.contextures.on.ca/xladvfilter01.html#ExtractWs
Gord Dibben MS Excel MVP