When you filter data, overall rows are hidden if values in one or more columns Will not meet up with the filtering requirements. You could filter on numeric or textual content values, or filter by colour for cells that have colour formatting placed on their track record or textual content. https://andyhgday.creacionblog.com/33908526/5-simple-statements-about-auto-filter-explained