Thread: Print Items in Drop Down Filter List
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Print Items in Drop Down Filter List
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 FilterUnique
items only and copy to somewhere.

For more on this, including copying to another sheet, see Debra's site.

http://www.contextures.on.ca/xladvfi...html#ExtractWs


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 13:07:03 -0800, felton128
wrote:

Can you tell me how to print the drop down filter list in Excel. I need to
prune and consolidate the various selections.

Reply With QuoteReply With Quote