The auto filter is only filtering the first 10 pieces of data in the column, not all 60.
M Margaret Jun 28, 2007 #1 The auto filter is only filtering the first 10 pieces of data in the column, not all 60.
P Peo Sjoblom Jun 28, 2007 #2 Remove the filter, then select the whole table before you apply it again. You might have blank cells
