View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jan
 
Posts: n/a
Default AutoFilter list problem

I am using Excel 97. I have set the autofilter feature in Excel to the
column labels.
When I select the drop down arrow on column B, it does not show me all the
unique data that could be selected in the list. I only see a portion of
unique values.
The list is contiguous (no blank rows). Is there a limit to how much data
will display in the drop down list?

TIA
Jan