View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daved
 
Posts: n/a
Default Excel filter dropdown shows all data

In the past, if I filtered a column, then clicked the arrow on the next
column, the dropdown box would only show me the data that had been filtered.
Now it seems to show ALL data. For instance, if I custom-filter to show data
that includes "whole," then click again on that column's filter arrow, the
dropdown list will still show all data, not just those that include "whole."

Similarly, filtering to "whole" then clicking on an adjacent column's filter
arrow will produce a box that shows everything. What's going on?