When you filter knowledge, full rows are hidden if values in one or more columns You should not meet up with the filtering conditions. You can filter on numeric or text values, or filter by shade for cells which have colour formatting placed on their track record or textual content. https://autofilter20852.pages10.com/about-auto-filter-69429534