I have a large spreadsheet with over 11,000 rows, when I do an auto filter on
a specific column, it filters out that information, but then shows the other
rows at the end of what I filtered. I thought it would only show the rows of
information that filtered. Any idea? Example: if I filter on column D
(Color), and choose blue, all the rows of information show with that filter
of blue, but at the end of the row with the filter blue, it starts showing
all the other rows with different colors.