View Single Post
  #1   Report Post  
sacwia01
 
Posts: n/a
Default Why does AutoFilter not show all the data in the pull down?

In an Excel spreadsheet with 12,000 lines, and autofilter on, all the
possible selections are not displayed in the filter pull down. I can use
custom filter in the pull down, but is more time consuming. I'd rather
scroll in the pull down. Is there a limit on the amount of lines shown in
the pull down? Or am I missing something?